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?
A. SQL Query Activity
B. File Trigger
C. Data Filter
D. Profile Management
|
Download Printable PDF. VALID exam to help you PASS. |
 |
A is the correct answer.
Use a SQL Query Activity when you have a complex segmentation need:
Your data is in multiple data extensions and needs to be joined together.
You need to join data extension data with data from system tables, such as Opens, Clicks, or Subscriber Status.
– Ex: Only sending to the subscribers who have opened an email in the last 60 days.
– Ex: Excluding subscribers who have had a bounce event in the last 30 days.
You have large amounts of data that needs to be staged for sends or Journey Builder activities.
Source: Salesforce Trailhead Academy
Wrong. A.