SAP C_DS_43 Exam Practice Test Instant Access

Question 1

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.

AUse a conditional for the second dataflow

BEmbed the first dataflow in a try-catch

CAdd a script between the dataflows using the error_number() function

DConnect the two dataflows with line

Answer : D

Question 2

You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?

AThey are flagged for later deletion

BThey are deleted from the target

CThey are added to the overflow file

DThey are filtered by the transform

Answer : D

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

AMerge transform

BConditionals

CQuery transform

DScripts

EMap CDC transform

Answer : A, C, D

Question 4

In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

AWhen there are large tables with few changes

Bwhen you need to capture physical deletes from source

CWhen almost all of the rows have changes

DWhen you need to capture intermediate changes

Answer : A

Question 5

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

ARun the nightly job with the enable recovery flag turned on.

BDesign the dataflow to ensure a second run does not result in duplicate

Cadd a try block before each dataflow and a Catch block after each dataflow

DMerge the dataflows from the job and rerun it.

Answer : B, C

Question 6

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.

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

BUse 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.

CUse 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

DUse 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

Answer : D

Question 7

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?

APerform an outer join between both tables

BUse a regular lookup function

CJoin the two tables

DUse a lookup_ext function

Answer : B

SAP C_DS_43 SAP Certified Application Associate - Data Integration with SAP Data Services Exam Practice Test