SAP C_DS_43 Exam Questions Instant Access

Question 1

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 2

How do you view the data between transforms in SAP Data Services dataflow?

ABy setting the Audit Data On job execution trace option

BBy using the interactive debugger

CBy setting the SQL Transforms on job execution trace option

DBy adding audit points in the dataflow

Answer : B

Question 3

You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?

AThey are flagged for later deletion

BThey are deleted from the target

CThey are added to the overflow file

DThey are filtered by the transform

Answer : D

Question 4

Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

AA Project can contain a job

BA job can contain a job

CA dataflow can contain a workflow

DA job can contain a workflow

EA workflow can contain a workflow

Answer : A, B, C

Question 5

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

AIS

Bnull

DCA

Answer : C

Question 6

What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.

ATo count the number of rows processed at user defined points to collect runtime statistics

BTo define rules based on the number of records processed overall once the dataflow is finished

Cto define rules that each record processed by the dataflow has to comply with

DTo view the data as it is processed by the dataflow in order to ensure its correctness

Answer : A, C

Question 7

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

SAP Certified Application Associate - Data Integration with SAP Data Services C_DS_43 Exam Questions