Salesforce Certified Marketing Cloud Email Specialist — Question 4

As part of a daily shipping notification automation, Northern Trail Outfitters needs to join data from the Shipping data extension and the Purchase data extension.
What activity is designed to address this scenario?

Answer options

• A. Filter Activity
• B. SQL Query Activity
• C. Group Refresh
• D. File Transfer Activity

Correct answer: B

Explanation

The SQL Query Activity is the correct choice because it allows for the combination and manipulation of data from multiple data extensions using SQL commands. The other options, such as Filter Activity and File Transfer Activity, do not provide the capability to join data from different sources, while Group Refresh is not relevant to data merging.