SAP C_DS_43 Exam Questions Instant Access

Question 1

You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?

3 correct answers

AClick the view enabled descriptions button on the toolbar.

BEnter a description in the properties of the object.

Cright-click the object then choose enable description .

DRight - click on the job in the project hierarchy to enable all descriptions.

Edisiable the hide non - executable elements setting in the difference viewer.

Answer : A, C, E

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

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 4

An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.

How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?

2 correct answers

AEnable the Delete data before load target table loader option

BAdd lookup function in the where clause to filter out existing rows.

CSet the autocorrect load option in the target table loader option

DUse the table comparison transform before the table loader

Answer : B, D

Question 5

The performance of a dataflow is slow in SAP Data Services.

How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.

Aby opening the auto documentation page in the Data Services Management Console

BBy enabling corresponding trace options in the job execution dialog.

CBy opening the dataflow and using the view optimized SQL feature.

DBy starting the job in debubg mode.

Answer : B, C

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 errors can you handle in SAP Services when you use a file format target?

ASemantic error

BData type conversion error

CRow- format error

DFile type error

Answer : C

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