MARKETING-CLOUD-CONSULTANT practice question 8 of 25

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: 154 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 large, time-sensitive sends with personalization data spread across multiple data extensions, performance is critical. The most efficient and scalable method is to pre-process the data. An SQL Query Activity in Automation Studio can join the necessary data extensions and consolidate the 10 required fields into a single, flattened, sendable data extension. Sending from this pre-aggregated data extension is significantly faster because it eliminates the need for complex lookups or data retrieval at the time of the send, ensuring a timely delivery.

Why Incorrect

A. Profile attributes are part of the older List model and are less performant for complex segmentation and large sends compared to data extensions.
B. Send Throttling is a feature used to slow down, not speed up, email sends. It limits the number of emails sent per hour.
C. Using AMPscript Lookup functions at send time for over a million subscribers would be extremely slow and could cause the send to time out.

References

1. Salesforce Help, Automation Studio, SQL Query Activity. "Use the SQL Query activity to retrieve data extension or data view information and store it in a data extension." This is the standard method for data preparation.

2. Salesforce Help, Email Studio, Subscribers, Send Speeds with Data Extensions. This documentation implicitly supports data preparation for performance, stating, "For fastest sending, prepare your data in a sendable data extension with all the data you need for the send."

Scroll to Top