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

Question 1

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 2

You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?

A. end date

B. Effective date column

C. Increment

D. Julian format

Correct Answer: A

Question 3

What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services? Note: There are 2 correct answers to this question

A. query

B. Key generation

C. History Preserving

D. Map operation

Correct Answer: C,D

Question 4

How do you allow a new team member to view the SAP Data Services repository in read only mode?

A. Use the Auto Documentation feature in the Management Console

B. Use the central repository in the Desinger

C. Export the repository's metadata to an XML file and open it in a browser.

D. Copy the repository and view the copy in the repository manager.

Correct Answer: B

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 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 pivot transform with two pivot sets.

B. Use the query transform with multiple IFTHENELSE() functions.

C. Use the merge transform that is connected to the source

D. Use twelve query transform to create the desired output. Then combine these transforms.

Correct Answer: A

Question 7

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

A. Count(*)

B. count(Account_type)

C. Gen_Row_Num()

D. count_distinct(Account_TYPE)

Correct Answer: B

Question 8

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. Set the autocorrect load option in the target table loader option

B. Use the table comparison transform before the table loader

C. Enable the Delete data before load target table loader option

D. Add lookup function in the where clause to filter out existing rows.

Correct Answer: B,D

Question 9

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

Welcome to TestSimulate

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