SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 (C-DS-42) Free Practice Test

Question 1

What are SAP data services scripts used for? There are 2 correct answers to this question

A. To perform job initialization tasks to print the job variable values into the trace log using the print() function.

B. To write complex transformation logic using the flexibility of the scripting language.

C. To execute single SQL commands using the sql() function to select a value from a status table for the variable.

D. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.

Correct Answer: B,C

Question 2

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

A. Schedule a job for daily execution

B. Display trace and monitor and error logs.

C. View the rows and the values being loaded

D. Display the optional Validation Transform statistics

E. Debug a dataflow to find data issues

Correct Answer: A,D,E

Question 3

Which features are supported by the SAP Data Services interactive debugger?
3 correct answers

A. Show sample rows of each step

B. Show performance-related statistics

C. Show the optimized execution plan

D. Define additional filters

E. Set breakpoint

Correct Answer: A,D,E

Question 4

You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?

A. Is is rerun with the first failed row.

B. It is rerun only if the dataflow is part of a recovery unit.

C. It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.

D. It is rerun from the beginning and the partially loaded data is always handled automanticaly.

Correct Answer: A

Question 5

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 table loader

B. In the table reader

C. In a query transform

D. In the Map transform

Correct Answer: C

Question 6

What does the expression SUBSTR(FIRST NAME, 1,3) return?

A. U

B. IRS

C. M

D. FIR

Correct Answer: D

Question 7

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. rpad_ext(POSTCPDE,EXTENSION)

B. POSTCODE ||'-'|| EXTENSION

C. POSTCODE AND '-' AND EXTENSION

D. POSTCODE +'-*+ EXTENSION

Correct Answer: B

Question 8

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

A. To group jobs that you want to monitor

B. To transform source data into target data

C. to allow schedulling for dataflows

D. To group data flows that belong together

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 (C-DS-42) Free Practice Test