Practice C_DS_43 Exam Online

Question 1

A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?

A : Use a script with an SQL function to read from status table

B : Use a catch block and set the variable to 'yes1

C : Use a dataflow to set the value via a template table

D : Use a global variable to persist the value accros job executions

Answer: B

Question 2

You are joining tables using the query transform of SAP Data Services.

A : Maximum of two tables

B : Left outer joins and inner joins

C : Only equal conditions

D : Only inner joins

Answer: B

Question 3

Your customer has rules requiring that each row in the source be tested for certain criteria in a

specific order. When a row passes one criteria, it should

NOT be tested for the next criteria.

How should this be implemented using SAP Data Services transforms?

Please choose the correct answer.

A : Use multiple Query transforms with one WHERE? clause per rule. Connect all queries to the source

B : Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression Order options enabled.

C : se a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox

D : Use a Validation transform and add the rules in the proper order for each single column.

Answer: B

Question 4

By which application you do Analyze the end-to-end impact and lineage for source and target objects used within the Data Services local repository?

A : Administrator

B : Impact and Lineage Analysis

C : Operational Dashboard

D : Data Validation Dashboard

E : Auto Documentation

F : Data Quality Reports

Answer: B

Question 5

How to Connect the source table to the target table?

A : Click the right side of the source table

B : Hold the left mouse button down while dragging to the left side of the target table

C : To save changes, choose OK

D : Choose Execute

Answer: A,B

Name:	SAP Certified Application Associate - Data Integration with SAP Data Services
Exam Code:	C_DS_43
Certification:	SAP Certified Application Associate
Vendor:	SAP
Total Questions:	160
Last Updated:	Apr 24, 2024

SAP C_DS_43