Online Access Free C-DS-42 Practice Test

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

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

Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?

• A.To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.
• B.To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run
• C.To ensure that each dataflow is recovered as a separate unit during the recovery execution
• D.To ensure that all dataflow of the workflow are executed in one single transaction during recovery

In SAP data services what does the date generation transform allow you to generate?

• A.The current date for a column to see when each row was loaded.
• B.The rows for a given date range
• C.the valid to date based on a dataset the contains valid to information only
• D.the valid from date based on a dataset the contains valid to information only

You want to back up an SAP Data Services repository. How does the system store repositories?

• A.As tables in a relational database management system
• B.As an XML file on the data services job server
• C.As an binary file on the Data servives job server
• D.As an XML file on the Data services Access Server

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.Before the pivot transform
• B.Between the pivot transform and the query transform
• C.Before the pivot transform and after the query transform.
• D.After the query transform