SAP C_DS_43 Exam Questions Instant Access

Question 1

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

AIS

Bnull

DCA

Answer : C

Question 2

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 3

What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

Aa local variable in a workflow sets the value of an a parameter in a dataflow.

B3 local variable in a job sets the value of an a parameter in a workflow

Ca parameter in a workflow sets the value of a local variable in a dataflow

Da parameter in a job set the value of a local variable in a dataflow

Answer : A, B

Question 4

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 5

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 6

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

Acount_distinct(Account_TYPE)

BCount(*)

Ccount(Account_type)

DGen_Row_Num()

Answer : C

Question 7

In SAP Data Services why would you select the produce default output checkbox in the Case transform?

ATo output all rows that match the case statement

Bto output all rows that do match exactly one case expression

CTo output all rows to the default path regardless if the they match the case expressions.

DTo output all rows that do not match any case expression to the default path

Answer : D

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