Download SAP.C_DS_42.Dump4Pass.2022-01-04.80q.tqb
| Vendor: | SAP |
| Exam Code: | C_DS_42 |
| Exam Name: | SAP Certified Application Associate - Data Integration with SAP Data Services 4-2 |
| Date: | Jan 04, 2022 |
| File Size: | 337 KB |
Demo Questions
Question 1
How to Create a new template table alpha_NA_customer in the Delta datastore as the target object?
- To add a new template table to the workspace, in the tool palette, choose the Template Table icon, and click the workspace
- In the Create Template dialog box, in the Table name field, enter alpha_NA_customer
- In the In datastore field, choose Delta from the dropdown list
- Select the customer table from the Alpha datastore.
Correct answer: ABC
Question 2
You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow.
Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job,Alpha_AuditCustomer_Job .
Set up auditing on the data flow lpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes
- To remove the existing audit rule, choose Delete
- Choose Add and select Custom .
- Right-click the Alpha_AuditCustomer_Job and choose Execute .
- In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.
- In the Trace tab, choose Trace Audit Data .
- In the Value field, using the drop down list, change the value to Yes.
Correct answer: CDEF
Question 3
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 Query transform, create a new output column TOTAL_VALUE , which will hold the new calculation.
- To map the ORDERID column from the input schema to the same field in the output schema, select ORDERID and drag to the output schema
- In the output schema, right click ORDERID and choose New output column.
- Choose the Where tab or the From tab.
- Choose Insert Below.
Correct answer: ABD
