Salesforce Certified Marketing Cloud Email Specialist — Question 6

A marketer is building a highly personalized email which is sent daily to one million subscribers. The data needed for the email is located in several data extensions.
What feature should the marketer use to merge the data into a single data extension to improve sending?

Answer options

• A. SQL Query Activity
• B. File Trigger
• C. Data Filter
• D. Profile Management

Correct answer: A

Explanation

The correct answer is A, SQL Query Activity, as it allows for the combination of data from multiple data extensions into a single output data extension, making it easier to manage and send personalized emails. Options B, C, and D do not provide the same functionality for merging data; File Trigger relates to file-based interactions, Data Filter is for segmenting data, and Profile Management is focused on managing subscriber profiles.