SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 (C_DS_42) Free Practice Test

Question 1

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. Table comparison transform

C. A Map_Operation transform

D. The auto correct load

Correct Answer: A

Question 2

An SAP Data Services dataflow must load the source table data into a target table, but the column names are different. Where do you assigg each source column to the matching target column?

A. In a table loader

B. In the table reader

C. In a query transform

D. In the Map transform

Correct Answer: C

Question 3

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 write complex transformation logic using the flexibility of the scripting language.

C. To execute single SQL commands using the sql() function to select a value from a status table for the variable.

D. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.

Correct Answer: B,C

Question 4

which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

A. Data_Transfer

B. History_Preserving

C. Key_Generation

D. Map_CDC_Operation

E. Table_comparison

Correct Answer: C,D,E

Question 5

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. 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 Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

D. Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.

Correct Answer: C

Question 6

You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.

A. Embed the first dataflow in a try-catch

B. Add a script between the dataflows using the error_number() function

C. Connect the two dataflows with line

D. Use a conditional for the second dataflow

Correct Answer: C

Question 7

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 ensure compatibility with subsequent transforms

B. To increase the speed that the database loads

C. To push the data down for better performance

D. To control how the data is loaded.

Correct Answer: A,D

Question 8

You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?

A. Join the two tables

B. Use a lookup_ext function

C. Use a regular lookup function

D. Perform an outer join between both tables

Correct Answer: C

Welcome to TestSimulate

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 (C_DS_42) Free Practice Test