Oracle Exam 1Z0-1032-20 Topic 4 Question 13 Discussion

Actual exam question for Oracle's 1Z0-1032-20 exam

Question #: 13
Topic #: 4

Your profile list is named CONTACTS. Your supplemental table is ORDERS with a Data Extraction Key of CUSTOMER_ID_ and a Primary Key of ORDER_ID, with TOTAL_ORDER_DOLLARS as a column. You design a campaign to display the ORDER_ID and TOTAL_ORDER_DOLLARS with a default value of 0 (zero) from the ORDERS table for each recipient in the target audience from your CONTACTS list.

What happens if there are multiple matches (more than one ORDER_ID) for a CUSTOMER_ID?

ABecause multiple matches with a record in the CONTACTS list exist in the ORDERS supplemental table, no matching values will be pulled at all, and the default value of 0 (zero) will be used for every email generated.

BThe campaign launch will error out when Responsys detects multiple matches with the CONTACI'S list from the ORDERS table.

CWhen multiple matches with a record in the CONTACTS list exist in the ORDERS supplemental table, the first found match will be used in the campaign.

DDuring the campaign worklist build, Responsys will pause and ask you to select the correct record to use for the campaign personalization.

Show Suggested Answer

Suggested Answer: A

by Donte at May 05, 2022, 10:09 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-1032-20 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!