SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C_DS

Question 1

What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.

A. To define rules based on the number of records processed overall once the dataflow is finished B. To count the number of rows processed at user defined points to collect runtime statistics C. To view the data as it is processed by the dataflow in order to ensure its correctness D. to define rules that each record processed by the dataflow has to comply with

Discussion 0

Correct Answer: B,D Vote an answer

Question 2

You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

A. Drop and re-created target table B. Use overflow file C. delete data before loading D. Auto correct load

Discussion 0

Correct Answer: B Vote an answer

Question 3

What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services? Note: There are 2 correct answers to this question

A. Key generation B. History Preserving C. query D. Map operation

Discussion 0

Correct Answer: B,D Vote an answer

Question 4

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

A. Gen_Row_Num() B. Count(*) C. count(Account_type) D. count_distinct(Account_TYPE)

Discussion 0

Correct Answer: C Vote an answer

Question 5

What operations can be pushed down in SAP Data Services?

A. Load operations that contain trigger B. Join operations between sources that are on the same database servers C. Aggregation operations used with a group by statement D. join operations between a file and a database table

Discussion 0

Correct Answer: B Vote an answer

Question 6

Why would you use a memory datastore in your SAP Data Services dataflow design?

A. To reduce the memory consumption in the target database. B. To define a connection to SAP HANA C. To reduce the memory consumption in the source database. D. To enhance processing performance of datadlows used in real time jobs.

Discussion 0

Correct Answer: C Vote an answer

Question 7

In SAP Data Services which basic operations can you perform with a Query transform?

A. Flag rows for update B. "Join data from several sources" C. Map Columns from an input schema to an output schema" D. "Apply functions to columns" E. Set a global variable to a value

Discussion 0

Correct Answer: D Vote an answer

Question 8

You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution How do you design this requirement in SAP Data services.

A. Use a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow B. Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value. C. Use a job containing a script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow. D. Use a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

Discussion 0

Correct Answer: D Vote an answer

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C_DS_42 FREE EXAM DUMPS QUESTIONS & ANSWERS