SAP C_DS_43 Exam Practice Test Instant Access

Question 1

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

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

B3 local variable in a job sets the value of an a parameter in a workflow

Ca parameter in a workflow sets the value of a local variable in a dataflow

Da parameter in a job set the value of a local variable in a dataflow

Answer : A, B

Question 2

An SAP Data Services dataflow must load the source table data into a target table, but the column names are different. Where do you assigg each source column to the matching target column?

AIn the table reader

BIn a table loader

CIn a query transform

DIn the Map transform

Answer : C

Question 3

Where can you set up breakpoints for the SAP Data services interactive debugger?

AIn a dataflow

BIn a workflow

CIn a script

DIn a job

Answer : A

Question 4

You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column

which is populated by the database when the row is saved.

What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column

AInserted and updated rows but not delete rows

BInsert, updates and deletes for a specified time range.

CUpdate rows but NOT insert or deleted records.

DEvery single change made to a row

Answer : A

Question 5

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 6

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

Acount_distinct(Account_TYPE)

BCount(*)

Ccount(Account_type)

DGen_Row_Num()

Answer : C

Question 7

A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.

Where would you place the Data_Transfer transform to do this?

ABefore the pivot transform

BBetween the pivot transform and the query transform

CAfter the query transform

DBefore the pivot transform and after the query transform.

Answer : B

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