SAP C_DS_43 Quiz 1 Topic 1 Questions 1-5

Question: 1

Which types of errors can you capture using a file format option? Note: There are 2 correct answers

to this question.

ARoot directory

BData conversion

CFile name

DRow format

Show Answer

Question: 2

You built a delta load dataflow to be executed every night. The source table contains a CHANGE

DATE column that is populated by the database when the row is saved.

Which changes can this approach identify in the source based on the CHANGE_DATE column?

AOnly updates where the value of the primary key is unchanged

BAll changes in the prior 24 hours

CInserts and Updates

DDeleted rows since last job execution

Show Answer

Question: 3

Where can you set up breakpoints when using the interactive debugger?

AIn the output schema of a Query transform

BBetween data flows in a workflow

CIn the input schema of a Query transform

DBetween transforms in a data flow

Show Answer

Question: 4

You execute a job with Enable Recovery activated. One of the data flows in the job raises an

exception that interrupts the execution. You run the job again with Recover from Last Failed

Execution enabled.

What happens to the data flow that raised the exception during the first execution?

AThe data flow is executed starting with the first failed row.

BThe data flow is skipped and execution proceeds to the next step in the job.

CThe data flow is re-executed only if the data flow is part of a recovery unit

DThe data flow is re-executed from the beginning

Show Answer

Question: 5

How do you view the data between transforms in a data flow?

AUse the interactive debugger.

BAdd audit points in the data flow.

CSet the Audit Data job execution trace option to Yes.

DSet the SQL Transforms job execution trace option to Yes

Show Answer

SAP C_DS_43 Quiz:1 Topic:1 Questions:1-5