Exam Certified Marketing Cloud Email Specialist topic 1 question 47 discussion

It should be B. Filter activity can’t merge 2 data extension

Should be B. Filter activity only works with 1 data extension.

B. SQL Query Activity Sql query can be used to join two or more data extensions data

B is correct ans because using SQL query only you can join / merge data into Single DE from more than one or multiple DES . Using dat filter you can't merge / join data from oither DE . So correct answer is Option B SQL query Activity

i am glad that i am not the only one thinking it is Sql.

Filter can’t combine 2DE. SQL can

This explains how to use Filter activity to join multiple data extensions: https://help.salesforce.com/s/articleView?id=sf.mc_es_multi_join_filters_scenario.htm&type=5

The SQL Query Activity allows you to write SQL (Structured Query Language) queries to extract and combine data from different data extensions based on specified criteria. With SQL queries, you can perform joins, filter data, and create new data extensions containing the combined data. In this case, the SQL Query Activity can be used to join the Shipping data extension and the Purchase data extension based on common fields (e.g., Order ID, Customer ID, or any other unique identifier) to retrieve the necessary information for the shipping notifications. Option A (Filter Activity) is used to filter data within a data extension based on specific conditions, but it does not allow for joining data from different data extensions. Option C (Group Refresh) is used to refresh a filtered or grouped data extension, and it does not perform data joins. Option D (File Transfer Activity) is used to transfer files between Marketing Cloud and external systems, but it is not intended for joining data from different data extensions.

should be B