SAP C_DS_43 Exam Questions Instant Access

Question 1

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

Question 2

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

AIS

Bnull

DCA

Answer : C

Question 3

What does the data services repository of SAP Data services contain?

There are 2 correct answers to this question

Ain flight data

BTarget metadata

CTransformation rules

DUser security
The SAP Data Services repository is a set of tables that hold user-created and predefined system objects, source and target metadata, and transformation rules. Set up repositories on an open client/server platform to facilitate sharing metadata with other enterprise tools.
https://blogs.sap.com/2015/12/27/sap-data-services-repositories-definition-and-configuration-part-1/#:~:text=The%20SAP%20Data%20Services%20repository,metadata%20with%20other%20enterprise%20tools.

Answer : B, C

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

What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.

ATo count the number of rows processed at user defined points to collect runtime statistics

BTo define rules based on the number of records processed overall once the dataflow is finished

Cto define rules that each record processed by the dataflow has to comply with

DTo view the data as it is processed by the dataflow in order to ensure its correctness

Answer : A, C

Question 6

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 7

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

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