SAP Certified Application Associate - Data Integration with SAP Data Services (C-DS-43) Free Practice Test

Question 1

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

A. CA

B. IS

C. ?

D. null

Correct Answer: C

Question 2

What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

A. You can call a recovery dataflow

B. You can have multiple rules on a single column.

C. You can produce statistics

D. You can set different failed paths for each rule

E. You can see which rules were violated in one output

Correct Answer: B,D,E

Question 3

In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question

A. Conditionals

B. Merge transform

C. Scripts

D. Map CDC transform

E. Query transform

Correct Answer: B,C,E

Question 4

You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

A. Central repository

B. Profiler repository

C. Standy repository

D. Backup repository

E. Local repository

Correct Answer: B

Question 5

What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

A. a local variable in a workflow sets the value of an a parameter in a dataflow.

B. 3 local variable in a job sets the value of an a parameter in a workflow

C. a parameter in a workflow sets the value of a local variable in a dataflow

D. a parameter in a job set the value of a local variable in a dataflow

Correct Answer: A,B

Question 6

You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers

A. Average

B. sum

C. Count distinct

D. Min

E. Checksum

Correct Answer: A,B,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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 8

You SAP Data Services job design includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery How would you expect the system to behave when you run the job in recovery mode?
Note: There are 2 correct answers to this question

A. the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.

B. The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow.

C. The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised

D. The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.

Correct Answer: A,C

Question 9

You are loading a database table using SAP Data Services. Which loading options are valid? Note: There are 3 correct answers to this question.

A. Number of loader

B. Include in transaction

C. Abap execution option

D. Rows per commit

E. Data transfer method

Correct Answer: A,B,D

Welcome to TestSimulate

SAP Certified Application Associate - Data Integration with SAP Data Services (C-DS-43) Free Practice Test