C-DS-43 Exam Training Practice Tests (SAP Certified Application Associate - Data Integration with SAP Data Services)]

Question 1

What can you use a workflow for in SAP Data Services?

A. to allow schedulling for dataflows B. To transform source data into target data C. To group jobs that you want to monitor D. To group data flows that belong together

Correct Answer: D

Question 2

You SAP Data Services job design includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery How would you expect the system to behave when you run the job in recovery mode?
Note: There are 2 correct answers to this question

A. The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow. B. the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped. C. The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised D. The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.

Correct Answer: B,C

Question 3

How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?

A. By using the table comparison transform B. by setting the target table loader with Bulk Load and Auto Correct Load enabled. C. by setting the target table loader with bulk load enabled D. By creating two dataflows and executing the Auto Correct Load version when reired

Correct Answer: D

Question 4

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?

A. They are flagged for later deletion B. They are added to the overflow file C. They are deleted from the target D. They are filtered by the transform

Correct Answer: D

Question 5

What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

A. Display the optional Validation Transform statistics B. Debug a dataflow to find data issues C. Schedule a job for daily execution D. View the rows and the values being loaded E. Display trace and monitor and error logs.

Correct Answer: A,B,C

Question 6

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

A. POSTCODE AND '-' AND EXTENSION B. rpad_ext(POSTCPDE,EXTENSION) C. POSTCODE ||'-'|| EXTENSION D. POSTCODE +'-*+ EXTENSION

Correct Answer: C

Question 7

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?

A. In a query transform B. In the table reader C. In the Map transform D. In a table loader

Correct Answer: A

Question 8

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

A. null B. CA C. ? D. IS

Correct Answer: C

Question 9

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 global variable to persist the value across job executions B. Use a dataflow to set the value via a template table C. Use a catch block and set the variable to 'yes1 D. Use a script with an SQL function to read from status table

Correct Answer: C

SAP Certified Application Associate - Data Integration with SAP Data Services - C-DS-43 Exam Practice Test