C-DS-42 試験問題を無料オンラインアクセス

How do you allow a new team member to view the SAP Data Services repository in read only mode?

• A.Export the repository's metadata to an XML file and open it in a browser.
• B.Use the central repository in the Desinger
• C.Use the Auto Documentation feature in the Management Console
• D.Copy the repository and view the copy in the repository manager.

You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.
How can you achieve this in SAP Data Services?

• A.Enter max (SALARY) in the query transform
• B.Call max(SALARY) from a Custom function
• C.Use max (SALARY) in a script.
• D.Use max(SALARY) in a conditional

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

• A.Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor
• B.Use the error handling options for conversion error in the file format definition
• C.Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
• D.Place the dataflow between a Try/Catch block to catch all erroneous rows

An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer

• A.Merge the dataflows from the job and rerun it.
• B.Run the nightly job with the enable recovery flag turned on.
• C.Design the dataflow to ensure a second run does not result in duplicate
• D.add a try block before each dataflow and a Catch block after each dataflow

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

• A.A job can contain a workflow
• B.A job can contain a job
• C.A dataflow can contain a workflow
• D.A workflow can contain a workflow
• E.A Project can contain a job