SAP C_DS_42 Quiz 18 Topic 5 Questions 86-90

Question: 1

Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?

ATo ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run

BTo ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.

CTo ensure that all dataflow of the workflow are executed in one single transaction during recovery

DTo ensure that each dataflow is recovered as a separate unit during the recovery execution

Show Answer

Question: 2

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).

How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

ASpecify the DEPARTMENT column on the GROUP BY tab.

BEnter avg(SALARY) on the Mapping tab.

CEnter avg(SALARY) on the SELECT tab.

DSpecify the DEPARTMENT code on the WHERE tab.

Show Answer

Question: 3

You want to restore an older version of an object found in a shared object library.

Where do you find this version of the object in SAP Data Services?

AO In the Central repository

BO In the Local repository

CO In the Profiler repository

DO In the Auditing repository

Show Answer

Question: 4

An SAP Data Services dataflow contains multiple transform objects. The target table contains some unexpected results for one column.

How can you review a sample of the data as it passes through each transform?

AExecute the job and review the target table in SQL.

BExecute the job in debug mode with breakpoints set and enabled.

CExecute the job that enables the Trace Optimized Dataflow property.

DExecute the job and review the monitor during execution.

Show Answer

Question: 5

Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it should

NOT be tested for the next criteria.

How should this be implemented using SAP Data Services transforms?

Please choose the correct answer.

AUse multiple Query transforms with one WHERE? clause per rule.
Connect all queries to the source.

BUse a Case transform with the Row Can Be True for One Case
Only and Preserve Expression Order options enabled.

Cse a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.

DUse a Validation transform and add the rules in the proper order for each single column.

Show Answer

Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

You want to restore an older version of an object found in a shared object library.Where do you find this version of the object in SAP Data Services?

An SAP Data Services dataflow contains multiple transform objects. The target table contains some unexpected results for one column.How can you review a sample of the data as it passes through each transform?

Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it shouldNOT be tested for the next criteria.How should this be implemented using SAP Data Services transforms?Please choose the correct answer.

SAP C_DS_42 Quiz:18 Topic:5 Questions:86-90

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).
How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

You want to restore an older version of an object found in a shared object library.
Where do you find this version of the object in SAP Data Services?

An SAP Data Services dataflow contains multiple transform objects. The target table contains some unexpected results for one column.
How can you review a sample of the data as it passes through each transform?

Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it should
NOT be tested for the next criteria.
How should this be implemented using SAP Data Services transforms?
Please choose the correct answer.