MCE-Con-201 practice question 1 of 10

Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer. How should they accomplish this task?

Full set: 160 questions
Answer options
A: Create and populate profile attributes for each of the 10 data extension fields and schedule a send with high priority.
B: Enable Send Throttling on high to ensure the speed is increased to process the email as fast as possible.
C: Use the Lookup AMPscript function in the email to pull the fields from the data extensions for each subscriber.
D: Create and send to a sendable data extension containing those needed fields using a query activity. Correct answer
Correct Answer:
D. Create and send to a sendable data extension containing those needed fields using a query activity.
Explanation

For a large, time-sensitive send with personalization from multiple data sources, performance is critical. The most efficient method is to pre-aggregate all required data into a single, sendable data extension. Using a SQL Query Activity in Automation Studio to join the various data extensions and populate this final sendable data extension ensures that all data is readily available at send time. This avoids slow, real-time lookups for each of the one million subscribers, resulting in the fastest possible send initiation and completion.

Why Incorrect

A. Profile attributes are part of the less scalable List model and are not ideal for large, complex datasets from multiple sources, which can degrade send performance.
B. Send Throttling is a feature designed to slow down email sends to manage deliverability and IP reputation, which is the opposite of the stated goal.
C. Using the Lookup() AMPscript function would execute ten database lookups for each of the one million subscribers at send time, severely degrading performance and delaying the send.

References

1. Salesforce Help. (2023). Data Extensions. "For large sending and high-frequency sending, we recommend using data extensions."

2. Salesforce Help. (2023). SQL Query Activity. "Use the SQL query activity to retrieve data from data extensions or Data Views and place it in a target data extension." This documentation outlines the process for creating the pre-aggregated sendable data extension.

3. Salesforce Developer. (2023). AMPscript Language Elements. The documentation on the Lookup() function implies its use for retrieving single values, which is inefficient when scaled to millions of records for multiple fields.

Scroll to Top