SAP C_DS_43 Exam Practice Test Instant Access

Question 1

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 2

You import a table from a database into a datastore.

Which information is added into the SAP Data Services repository?

AThe complete metadata information of the table

BOnly the table name

CThe whole table with all its source data

DThe table name and all column names with their dataypes.

Answer : A

Question 3

What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

AYou can see which rules were violated in one output

BYou can set different failed paths for each rule

CYou can have multiple rules on a single column.

DYou can produce statistics

EYou can call a recovery dataflow

Answer : A, B, C

Question 4

You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?

ACreate a workflow containing two dataflows and connect them with a line.

BCreate a workflow containing two dataflows without connecting them with a line.

CCreate a workflow containg two dataflows and deselect the execute Only once property of the workflow.

DCreate a workflow containing two dataflows and set a degree of parallelism to 2.

Answer : B

Question 5

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 6

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

AIS

Bnull

DCA

Answer : C

Question 7

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.

What can you do to completely load such erroneous files?

Note: There are 2 correct answer

APlace the dataflow between a Try/Catch block to catch all erroneous rows

BUse the error handling options for conversion error in the file format definition

CSpecify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

DDefine the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

Answer : A, C

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