Online Access Free C_DS_42 Exam Questions

You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.

• A.Add a script between the dataflows using the error_number() function
• B.Connect the two dataflows with line
• C.Embed the first dataflow in a try-catch
• D.Use a conditional for the second dataflow

Which repository types are used in SAP Data Services? 2 correct

• A.Data repository
• B.Profiler repository
• C.Remote Repository
• D.Central Repository

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

• A.You can see which rules were violated in one output
• B.You can have multiple rules on a single column.
• C.You can call a recovery dataflow
• D.You can set different failed paths for each rule
• E.You can produce statistics

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

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

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(*)
• B.count(Account_type)
• C.Gen_Row_Num()
• D.count_distinct(Account_TYPE)