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 have to load a file that contains the following first three lines:

YEAR; MONTH; PLAN_AMOUNT

2014;01;100.00

2014;02;110.00

What setting do you use when you created a file format for this?

AType: Delimited column delimiter:; skip row headen: no

BType: Fixed column length:4,2 and 6 skip row headen: yes

CType: Delimited column delimiter:; skip row headen: yes

DType: Delimited column delimiter:<blank> skip row headen: yes

Answer : C

Question 7

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'Execute the job manually in the Data Services Designer.'

BUse the scheduler in the Data Services Designer

CUse the debug option in the Data Services Management console

DUse the scheduler in the Data Services Management Console

Answer : A, B

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