Free SAP C-DS-42 Exam Dumps Questions & Answers

You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?
2 correct answers

• A.  Use the scheduler in the Data Services Management Console
• B.  Use the scheduler in the Data Services Designer
• C.  Use the debug option in the Data Services Management console
• D.  "Execute the job manually in the Data Services Designer."

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

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

You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.
How can you achieve this in SAP Data Services?

• A.  Enter max (SALARY) in the query transform
• B.  Use max (SALARY) in a script.
• C.  Call max(SALARY) from a Custom function
• D.  Use max(SALARY) in a conditional

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.

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