SAP C_DS_43 Exam Questions Instant Access

Question 1

A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:

POSTECODE:99999

EXTENSION: 9999

Desired result is ZIP4:99999-9999

APOSTCODE AND '-' AND EXTENSION

Brpad_ext(POSTCPDE,EXTENSION)

CPOSTCODE +'-*+ EXTENSION

DPOSTCODE ||'-'|| EXTENSION

Answer : D

Question 2

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 3

What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services? Note: There are 2 correct answers to this question

Aquery

BKey generation

CMap operation

DHistory Preserving

Answer : C, D

Question 4

You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

ACentral repository

BStandy repository

CBackup repository

DLocal repository

EProfiler repository

Answer : E

Question 5

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 6

What operations can be pushed down in SAP Data Services?

AAggregation operations used with a group by statement

Bjoin operations between a file and a database table

CLoad operations that contain trigger

DJoin operations between sources that are on the same database servers

Answer : D

Question 7

You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?

AJulian format

BIncrement

CEffective date column

Dend date

Answer : D

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