Exam 1z0-477 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-477

Question #: 34
Topic #: 1

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?

A. Because 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.
B. The campaign launch will error out when Responsys detects multiple matches with the CONTACI'S list from the ORDERS table.
C. When 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.
D. During 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 [deleted] at April 4, 2025, 7:59 a.m.

Comments

Submit Cancel

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