Practice C_DS_42 Exam Online

Question 1

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row.This causes the dataflow to

terminate with an error.

What can you do to completely load such erroneous files?

A : Place the dataflow between a Try/Catch block to catch all erroneous rows

B : Use the error handling options for conversion error in the file format definition

C : Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

D : Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

Answer: A

Question 2

In the transform editor for the Query transform, How to map all columns from the Schema In to the Schema Out?

A : In the Query editor, choose the WHERE tab.

B : To open the Query Editor , in the data flow workspace, double click the Query transform

C : To select all columns in the Schema In , choose the CUSTOMERID column, hold the shift key, and choose the PHONE column

D : Drag all columns to the Schema Out

Answer: B,C,D

Question 3

You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data servicces?

A : Click the view enabled descriptions button on the toolbar.

B : Enter a description in the properties of the object.

C : right-click the object then choose enable description .

D : Right - click on the job in the project hierarchy to enable all descriptions.

E : disiable the hide non - executable elements setting in the difference viewer.

Answer: C

Question 4

An SAP Data Services Validation transform outputs all invalid rows. If more than ten rows are invalid, the data is considered to be failed. How do you implement this?

A : Create an auditing rule that raises an exception

B : Raise an exception in a Conditional connected to the target table.

C : Set a breakpoint on the line connected to the target table.

D : Use the raise_exception function in the validation transform.

Answer: A

Question 5

What are estandar component os SAP Dataservices?

A : Job server

B : Desing studio

C : Secure local repository

D : Access server

E : Real time services

Answer: A

Name:	SAP Certified Application Associate - Data Integration with SAP Data Services 4.2
Exam Code:	C_DS_42
Certification:	SAP Certified Application Associate
Vendor:	SAP
Total Questions:	80
Last Updated:	Apr 22, 2024

SAP C_DS_42