SAP C_DS_43 Exam Questions Instant Access

Question 1

In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.

Where are the records that fail both rule #1 and rule #2 sent?

AOnly to the Fail output

BOnly to the Rule Violation output

COnly to the Pass output

DTo both the Pass and Fail output

Answer : A

Question 2

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

Question 3

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 4

An SAP data services job was executed in the past.

Where can you see the order that the dataflows were executed in?

There are 2 correct answers to this question.

AIn the operational dashboard

BIn the impact and Lineage Analysis report

CIn the job trace log.

DIn the job server log

Answer : C

Question 5

What can you use a workflow for in SAP Data Services?

ATo group data flows that belong together

BTo group jobs that you want to monitor

Cto allow schedulling for dataflows

DTo transform source data into target data

Answer : A

Question 6

What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

APrimary keys in the input schema must be mapped to only one column in the output schema

BEach column in the output schema must be mapped to one or more columns in the input schema

CAll columns of the input schema must be mapped to the output schema

DEvery column of the output schema must have a mapping

Answer : B

Question 7

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

AYou can see which rules were violated in one output

BYou can set different failed paths for each rule

CYou can have multiple rules on a single column.

DYou can produce statistics

EYou can call a recovery dataflow

Answer : A, B, C

SAP Certified Application Associate - Data Integration with SAP Data Services C_DS_43 Exam Questions