SAP C_DS_42 Quiz 19 Topic 7 Questions 91-95

Question: 1

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

ABy setting the Audit Data On job execution trace option

BBy using the interactive debugger

CBy setting the SQL Transforms on job execution trace option

DBy adding audit points in the dataflow

Show Answer

Question: 2

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

APlace the dataflow between a Try/Catch block to catch all erroneous rows

BUse the error handling options for conversion error in the file format definition

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

DDefine the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

Show Answer

Question: 3

You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

Aworkflow

Bsubdataflow

CJOB

DDataflow

EEmbedded dataflow
Select the level within a job that you want to distribute to multiple Job Servers for processing:
Job: The whole job will execute on an available Job Server.
Data flow: Each data flow within the job can execute on an available Job Server.
Sub data flow: Each sub data flow (can be a separate transform or function) within a data flow can execute on an available Job Server.
For more information, see''Using grid computing to distribute data flows execution''in thePerformance Optimization Guide.

Show Answer

Question: 4

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

ARun the nightly job with the enable recovery flag turned on.

BDesign the dataflow to ensure a second run does not result in duplicate

Cadd a try block before each dataflow and a Catch block after each dataflow

DMerge the dataflows from the job and rerun it.

Show Answer

Question: 5

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

ABy setting the Audit Data On job execution trace option

BBy using the interactive debugger

CBy setting the SQL Transforms on job execution trace option

DBy adding audit points in the dataflow

Show Answer

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

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

You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

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

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

SAP C_DS_42 Quiz:19 Topic:7 Questions:91-95

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

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