Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email…

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.

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.