Free C_DS_42 Practice Test (Page 4 ) & Exam Questions

QUESTION: 6

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?

Specify the DEPARTMENT column on the GROUP BY tab.
Enter avg(SALARY) on the Mapping tab.
Enter avg(SALARY) on the SELECT tab.
Specify the DEPARTMENT code on the WHERE tab.

Answer(s): A,B

Show Answer Next Question

QUESTION: 7

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?

Use multiple Query transforms with one WHERE? Clause per rule. Connect all queries to the source; Use a Case transform with the Row Can Be True for One Case; Only and Preserve Expression Order options enabled.
set a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
Use a Validation transform and add the rules in the proper order for each single column.

Answer(s): B

Show Answer Next Question

QUESTION: 8

You must calculate the total value of all orders, including their discounts, for reporting purposes.
Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to in the transform editor for the Query transform, propose a join between the two source tables?

To open the Query Editor double click the Query.
To connect the Query Transform, select the Query Transform, hold down the mouse button, drag it to the order_sum table, and release the mouse button.
Choose the Where tab or the From tab.
the Propose Join button

Answer(s): A,C,D

Show Answer Next Question