SAP SAP-Certifications C_DS_42 Questions & Answers

• Question 31:

  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 Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes

  A. To remove the existing audit rule, choose Delete

  B. Choose Add and select Custom .

  C. Right-click the Alpha_AuditCustomer_Job and choose Execute .

  D. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.

  E. In the Trace tab, choose Trace Audit Data .

  F. In the Value field, using the drop down list, change the value to Yes.

  Correct Answer: CDEF

• Question 32:

  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 Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes.

  A. Right-click the Alpha_AuditCustomer_Job and choose Execute .

  B. To remove the existing audit rule, choose Delete

  C. Choose Add and select Custom.

  D. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.

  E. In the Trace tab, choose Trace Audit Data .

  F. In the Value field, using the drop down list, change the value to Yes .

  Correct Answer: ADEF

• Question 33:

  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 Add an Audit label for the new target table and create a custom audit rule to verify the sum of the count of the two target tables is equal to the count of the source table.

  A. In the Local Object Library Data Flow tab, right click the Alpha_AuditCustomer_DF data flow and choose Audit

  B. On the Label tab of the Audit dialog, right click Alpha_Other_customer and choose Count .

  C. Save all changes

  D. In the Audit editor, choose the Rule tab.

  Correct Answer: ABD

• Question 34:

  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 .

  A. Click in the data flow workspace to add a new template table below the Alpha_NA_customer target table.

  B. Choose Execute .

  C. In the Execution Properties dialog box, choose the Execution Options tab, and select the Enable auditing checkbox.

  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

  Correct Answer: ADEFG

• Question 35:

  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 Enable auditing for the execution of the Alpha_AuditCustomer_Job .

  A. Right-click the Alpha_AuditCustomer_Job .

  B. Choose Execute .

  C. In the Execution Properties dialog box, choose the Execution Options tab, and select the Enable auditing checkbox.

  D. Choose the Trace tab and choose Trace Audit Data .

  E. Under Action on failure, select the Raise exception checkbox.

  Correct Answer: ABCD

• Question 36:

  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.

  A. On the Label tab, right click the target table, Alpha_NA_customer , and choose Count .

  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 .

  Correct Answer: BCDEF

• Question 37:

  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 Add audit labels in the Alpha_AuditCustomer_DF data flow to count the total number of records in the source and target tables.

  A. In the Local Object Library , choose the Data Flow tab.

  B. Right click the data flow Alpha_AuditCustomer_DF and choose Audit .

  C. The Audit dialog box displays with a list of the objects that you can audit with any audit functions and labels for those objects.

  D. On the Label tab, right click the source table, customer , and choose Count .

  E. On the Label tab, right click the target table, Alpha_NA_customer , and choose Count .

  F. Drag the Alpha_AuditCustomer_DF from the Local Object Library to the Alpha_AuditCustomer_Job workspace.

  Correct Answer: ABCD

• Question 38:

  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 Add the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .

  A. Drag the Alpha_AuditCustomer_DF from the Local Object Library to the

  B. Alpha_AuditCustomer_Job workspace.

  C. Right click the Omega project in the Project Area.

  D. Choose New Batch Job

  E. Name the new job Alpha_AuditCustomer_Job .

  Correct Answer: A

• Question 39:

  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 Create a new batch job Alpha_AuditCustomer_Job .

  A. In the Local Object Library Data Flow tab right click the

  B. Alpha_NACustomer_DF data flow and choose Replicate .

  C. Rename the copied data flow Alpha_AuditCustomer_DF.

  D. Right click the Omega project in the Project Area.

  E. Choose New Batch Job

  F. Name the new job Alpha_AuditCustomer_Job .

  Correct Answer: CDE

• Question 40:

  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 Replicate the Audit_NACustomer_DF data flow.

  A. In the Local Object Library Data Flow tab right click the Alpha_NACustomer_DF data flow and choose Replicate

  B. Rename the copied data flow Alpha_AuditCustomer_DF.

  C. Right click the Omega project in the Project Area.

  D. Choose New Batch Job

  E. Name the new job Alpha_AuditCustomer_Job .

  Correct Answer: AB