Exam Certified Marketing Cloud Email Specialist topic 1 question 53 discussion

should be A

It should be A

SQL query for sure

Answer is : A to merger the data from more than one DE to one De is possoble only using SQL query Activity

i am glad many people think it is sql. i saw this question somewhere else and it said filter there also, so i was very confused.

Should be SQL Query Activity. Data filter does not allow joining of Data Extensions

The SQL Query Activity allows the marketer to write SQL (Structured Query Language) queries to extract, combine, and transform data from multiple data extensions based on specified criteria. By using SQL queries, the marketer can merge relevant data from different data extensions into a new data extension, which can then be used for sending the highly personalized email. Option B (File Trigger) is not used for merging data from multiple data extensions; it is used to trigger an automation based on the presence of a file in a specified location. Option C (Data Filter) is used to filter data within a data extension based on specific conditions; it does not merge data from multiple data extensions. Option D (Profile Management) is not specifically designed for merging data from multiple data extensions; it focuses on managing subscriber profiles and attributes.

should be A