Online Access Free C-DS-43 Practice Test

What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question

• A.Transformation rules
• B.User security
• C.in flight data
• D.Target metadata

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?

• A.count(Account_type)
• B.count_distinct(Account_TYPE)
• C.Count(*)
• D.Gen_Row_Num()

which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

• A.History_Preserving
• B.Key_Generation
• C.Table_comparison
• D.Map_CDC_Operation
• E.Data_Transfer

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?

• A.They are filtered by the transform
• B.They are flagged for later deletion
• C.They are added to the overflow file
• D.They are deleted from the target

An SAP Data Services dataflow has validation error.
What is the cause?

• A.The source data is incorrect and the dataflow therefore requires a validation transform.
• B.The dataflow has a syntax error that has to be correct before executing it.
• C.A conversion is missing
• D.The source data does NOT comply with the rules entered in the Validation transform