SAP C_DS_43 Exam Practice Test Instant Access

Question 1

What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct

ACustom function

BXML function

CJoin

DOrdering

EDistinct

Answer : C, D, E

Question 2

In SAP Data Services which basic operations can you perform with a Query transform?

A'Join data from several sources'

B'Apply functions to columns'

CMap Columns from an input schema to an output schema'

DFlag rows for update

ESet a global variable to a value

Answer : B

Question 3

You are loading a database table using SAP Data Services. Which loading options are valid? Note: There are 3 correct answers to this question.

AAbap execution option

BNumber of loader

CRows per commit

DData transfer method

EInclude in transaction

Answer : B, C, 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?

AIs is rerun with the first failed row.

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

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

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

Answer : A

Question 5

What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?

AOperational Dashborad

BAutodocumentation

CImpact and lineage Analysis

DData quality reports

Answer : B

Question 6

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

ADebug a dataflow to find data issues

BDisplay the optional Validation Transform statistics

CView the rows and the values being loaded

DSchedule a job for daily execution

EDisplay trace and monitor and error logs.

Answer : A, B, D

Question 7

In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question

AMerge transform

BConditionals

CQuery transform

DScripts

EMap CDC transform

Answer : A, C, D

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