← Back to exam page

C_DS_42 – SAP Certified Application Associate Data Integration with SAP Data Services 4.2

Loading demo links...

Showing 7–9 of 10 questions

Question 7

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

Select an option, then click Submit answer.

  • ○

    By setting the Audit Data On job execution trace option
  • ○

    By using the interactive debugger
  • ○

    By setting the SQL Transforms on job execution trace option
  • ○

    By adding audit points in the dataflow
Question 8

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.

Select an option, then click Submit answer.

  • ○

    Use a conditional for the second dataflow
  • ○

    Embed the first dataflow in a try-catch
  • ○

    Add a script between the dataflows using the error_number() function
  • ○

    Connect the two dataflows with line
Question 9

You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.

What is the best way to achieve this in SAP Data services?

Select an option, then click Submit answer.

  • ○

    Use twelve query transform to create the desired output. Then combine these transforms.
  • ○

    Use the query transform with multiple IFTHENELSE() functions.
  • ○

    Use the merge transform that is connected to the source
  • ○

    Use the pivot transform with two pivot sets.