SAP C_DS_43 Exam Practice Test Instant Access

Question 1

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

3 correct answers

AShow sample rows of each step

BSet breakpoint

CShow the optimized execution plan

DShow performance-related statistics

EDefine additional filters

Answer : A, B, E

Question 2

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

AIS

Bnull

DCA

Answer : C

Question 3

In SAP Data services which function delivers the same results an nested 1FTHENELSE functions?

AMatch_Pattern

BDecode

CLiteral

DMatch_regex

Answer : B

Question 4

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

AThe job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised

BThe 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.

Cthe job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.

DThe job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.

Answer : A, C

Question 5

You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck

AOn the view data tab

BIn the impact and lineage analysis

CIn the monitor log

DIn the trace log

Answer : C

Question 6

You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

ACentral repository

BStandy repository

CBackup repository

DLocal repository

EProfiler repository

Answer : E

Question 7

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

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