Online Access Free C-DS-42 Practice Test

What are standard component of SAP Dataservices? There are 3 correct answers

• A.Job server
• B.Access server
• C.Design studio
• D.Secure local repository
• E.Real time services

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

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

An SAP Data Services dataflow has validation error.
What is the cause?

• A.The source data does NOT comply with the rules entered in the Validation transform
• B.The dataflow has a syntax error that has to be correct before executing it.
• C.A conversion is missing
• D.The source data is incorrect and the dataflow therefore requires a validation transform.

An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers

• A.Use the table comparison transform before the table loader
• B.Enable the Delete data before load target table loader option
• C.Set the autocorrect load option in the target table loader option
• D.Add lookup function in the where clause to filter out existing rows.

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

• A.A Map_CDC_Operation transform
• B.A Map_Operation transform
• C.The auto correct load
• D.Table comparison transform