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 questionsFor 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.
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.
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."
Keep practicing
Take the free MARKETING-CLOUD-CONSULTANT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MARKETING-CLOUD-CONSULTANT practice questions
- Question 1Northern Tril Outfitters wants to connect relational data into their Journey without over…
- Question 2Northern Trail Outfitters continually adds rows for subscribers to a data extension via A…
- Question 3An analytics team wants to get real-time updates on transactional email metrics, specific…
- Question 4A customer wants to integrate a new dataset with pre-existing contacts. This data will be…
- Question 5Northern Trail (NTO), a longtime Marketing Cloud customer, has decided to adopt Journey B…
- Question 6Northern Trail Outfitter wants to integrate Marketing Cloud with it existing point-of-sal…
