← Back to exam page

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

Loading demo links...

Showing 1–3 of 10 questions

Question 1

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.

What can you do to completely load such erroneous files?

Note: There are 2 correct answer

Select all that apply, then click Submit answer.

  • ○

    Place the dataflow between a Try/Catch block to catch all erroneous rows
  • ○

    Use the error handling options for conversion error in the file format definition
  • ○

    Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor
  • ○

    Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
Question 2

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

Select all that apply, then click Submit answer.

  • ○

    A Project can contain a job
  • ○

    A job can contain a job
  • ○

    A dataflow can contain a workflow
  • ○

    A job can contain a workflow
  • ○

    A workflow can contain a workflow
Question 3

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

Select all that apply, then click Submit answer.

  • ○

    To count the number of rows processed at user defined points to collect runtime statistics
  • ○

    To define rules based on the number of records processed overall once the dataflow is finished
  • ○

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

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