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

Question 1

You are loading a database table using SAP Data Services. Which loading options are valid? Note: There are 3 correct answers to this question.

A. Include in transaction

B. Data transfer method

C. Number of loader

D. Abap execution option

E. Rows per commit

Correct Answer: A,C,E

Question 2

What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

A. Display trace and monitor and error logs.

B. Schedule a job for daily execution

C. View the rows and the values being loaded

D. Debug a dataflow to find data issues

E. Display the optional Validation Transform statistics

Correct Answer: B,D,E

Question 3

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

A. To reduce the memory consumption in the source database.

B. To enhance processing performance of datadlows used in real time jobs.

C. To reduce the memory consumption in the target database.

D. To define a connection to SAP HANA

Correct Answer: A

Question 4

a do you use implement a target-based delta that deals with inserts, update and deletes in the source.

A. The auto correct load

B. Table comparison transform

C. A Map_Operation transform

D. A Map_CDC_Operation transform

Correct Answer: D

Question 5

The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.

A. By enabling corresponding trace options in the job execution dialog.

B. by opening the auto documentation page in the Data Services Management Console

C. By starting the job in debubg mode.

D. By opening the dataflow and using the view optimized SQL feature.

Correct Answer: A,D

Question 6

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 Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

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 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

D. 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.

Correct Answer: A

Question 7

You need to import metadata and extract data from an SAP ERP system using SAP Data Services. Which type of datastore must you use?

A. Web Services datastore

B. Adapter datastore

C. Application datastore

D. Database datastore

Correct Answer: C

Question 8

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. Map operation

B. Key generation

C. query

D. History Preserving

Correct Answer: A,D

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C_DS_42 Exam Practice Test

Latest Update

Useful Links

Contact Us