C_DS_42 · Question #25
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 B. In the Rule tab, under Auditing Rules , choose Add . C. In the operator drop down list, choose the operator equal (=). D. In the right drop down list, choose the audit label $count_Alpha_NA_customer for the target table. E. Under Action on failure, select the Raise exception checkbox. F. Choose Close. 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 Construct an audit rule that an exception must be entered into the log if the count from both tables is not the same?
Options
- AOn the Label tab, right click the target table, Alpha_NA_customer , and choose Count .
- BIn the Rule tab, under Auditing Rules , choose Add .
- CIn the operator drop down list, choose the operator equal (=).
- DIn the right drop down list, choose the audit label $count_Alpha_NA_customer for the target table.
- EUnder Action on failure, select the Raise exception checkbox.
- FChoose Close .
How the community answered
(36 responses)- A28% (10)
- B72% (26)
Community Discussion
No community discussion yet for this question.