C-DS-42 Exam Training Practice Tests (SAP Certified Application Associate - Data Integration with SAP Data Services 4.2)]

Question 1

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

A. null B. CA C. ? D. IS

Correct Answer: C

Question 2

An SAP data services job was executed in the past.
Where can you see the order that the dataflows were executed in?
There are 2 correct answers to this question.

A. In the operational dashboard B. In the impact and Lineage Analysis report C. In the job server log D. In the job trace log.

Correct Answer: D

Question 3

What does the expression SUBSTR(FIRST NAME, 1,3) return?

A. M B. U C. FIR D. IRS

Correct Answer: C

Question 4

You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?

A. Use the merge transform that is connected to the source B. Use the pivot transform with two pivot sets. C. Use the query transform with multiple IFTHENELSE() functions. D. Use twelve query transform to create the desired output. Then combine these transforms.

Correct Answer: B

Question 5

What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

A. a local variable in a workflow sets the value of an a parameter in a dataflow. B. 3 local variable in a job sets the value of an a parameter in a workflow C. a parameter in a workflow sets the value of a local variable in a dataflow D. a parameter in a job set the value of a local variable in a dataflow

Correct Answer: A,B

Question 6

You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column

A. Inserted and updated rows but not delete rows B. Every single change made to a row C. Insert, updates and deletes for a specified time range. D. Update rows but NOT insert or deleted records.

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. Adapter datastore B. Application datastore C. Database datastore D. Web Services datastore

Correct Answer: B

Question 8

You are joining tables using the query transform of SAP Data Services.

A. Only equal conditions B. Only inner joins C. Left outer joins and inner joins D. Maximum of two tables

Correct Answer: C

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C-DS-42 Exam Practice Test