C_DS_42 by SAP Valid Free Exam Practice Test

Question 1

You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers

A. sum B. Count distinct C. Average D. Min E. Checksum

Correct Answer: A,C,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

What are SAP data services scripts used for? There are 2 correct answers to this question

A. To perform job initialization tasks to print the job variable values into the trace log using the print() function. B. To execute single SQL commands using the sql() function to select a value from a status table for the variable. C. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag. D. To write complex transformation logic using the flexibility of the scripting language.

Correct Answer: B,D

Question 3

Which repository types are used in SAP Data Services? 2 correct

A. Data repository B. Profiler repository C. Remote Repository D. Central Repository

Correct Answer: B,D

Question 4

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. Add lookup function in the where clause to filter out existing rows. D. Set the autocorrect load option in the target table loader option

Correct Answer: A,C

Question 5

In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

A. when you need to capture physical deletes from source B. When almost all of the rows have changes C. When there are large tables with few changes D. When you need to capture intermediate changes

Correct Answer: C

Question 6

A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?

A. Between the pivot transform and the query transform B. Before the pivot transform and after the query transform. C. After the query transform D. Before the pivot transform

Correct Answer: A

Question 7

What can you use a workflow for in SAP Data Services?

A. To group data flows that belong together B. To group jobs that you want to monitor C. To transform source data into target data D. to allow schedulling for dataflows

Correct Answer: A

Question 8

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 trace log. D. In the job server log

Correct Answer: C

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