SAP C_DS_43 Exam Practice Test Instant Access

Question 1

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

ATo write complex transformation logic using the flexibility of the scripting language.

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

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

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

Answer : A, D

Question 2

You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.

How would you achieve this in SAP Data Services.

AUse a conditional for the second dataflow

BEmbed the first dataflow in a try-catch

CAdd a script between the dataflows using the error_number() function

DConnect the two dataflows with line

Answer : D

Question 3

You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

ADrop and re-created target table

BUse overflow file

Cdelete data before loading

DAuto correct load

Answer : B

Question 4

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

CFIR

DIRS

Answer : C

Question 5

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

Question 6

In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

AWhen there are large tables with few changes

Bwhen you need to capture physical deletes from source

CWhen almost all of the rows have changes

DWhen you need to capture intermediate changes

Answer : A

Question 7

You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.

How can you achieve this in SAP Data Services?

AUse max (SALARY) in a script.

BUse max(SALARY) in a conditional

CCall max(SALARY) from a Custom function

DEnter max (SALARY) in the query transform

Answer : D

SAP Certified Application Associate - Data Integration with SAP Data Services C_DS_43 Exam Practice Test