C_DS_42 · Question #27
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…
The correct answer is A. Click in the data flow workspace to add a new template table below the Alpha_NA_customer D. Name the new template table Alpha_Other_customer . E. Create the table in datastore Delta . F. Choose OK . G. Add a second Query transform to the data flow. See the full explanation below for the reasoning.
Question
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 Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables. How to Modify the data flow to send customers outside North America to a second template table, Alpha_Other_customer?
Options
- AClick in the data flow workspace to add a new template table below the Alpha_NA_customer
- BChoose Execute .
- CIn the Execution Properties dialog box, choose the Execution Options tab, and select the Enable
- DName the new template table Alpha_Other_customer .
- ECreate the table in datastore Delta .
- FChoose OK .
- GAdd a second Query transform to the data flow
How the community answered
(53 responses)- A85% (45)
- B9% (5)
- C6% (3)
Community Discussion
No community discussion yet for this question.