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 questionsFor 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.
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.
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.
Keep practicing
Take the free MCE-Con-201 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MCE-Con-201 practice questions
- Question 2Northern Trail Outfitters (NTO) wants email subscribers to adopt their app. They are inve…
- Question 3Northern Trail Outfitters wants to suppress their highly engaged email subscribers (multi…
- Question 4Northern Trail Outfitters is growing and acquiring other organizations, each with its own…
- Question 5Northern Trail Outfitters (NTO) wants to send an email to all Contacts who have signed up…
- Question 6A customer asks why the send time values within an email are not being added to a Send Lo…
- Question 7Northern Trail Outfitters (NTO) plans on sending SMS and push notifications together with…
