Free SAP C_DS_42 Exam Dumps Questions & Answers

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

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

A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?

• A.  To increase the speed that the database loads
• B.  To push the data down for better performance
• C.  To ensure compatibility with subsequent transforms
• D.  To control how the data is loaded.

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

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

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.  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.
• 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.  Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.

An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer

• A.  Run the nightly job with the enable recovery flag turned on.
• B.  Design the dataflow to ensure a second run does not result in duplicate
• C.  Merge the dataflows from the job and rerun it.
• D.  add a try block before each dataflow and a Catch block after each dataflow