Exam Certified Marketing Cloud Email Specialist topic 1 question 119 discussion

A. Query Activity: This allows you to use SQL queries to segment and manipulate data. You can create a query that adds new subscribers to the segment and updates existing ones without removing those who no longer meet the criteria. This gives you the flexibility and control to achieve the desired outcome. B. Filter Activity: While this allows you to create a segment based on specific criteria, it doesn't provide the same level of control as a Query Activity. If a subscriber no longer meets the criteria, they might be removed from the segment. C. Synchronized Data: This is primarily used to bring data from Salesforce CRM into Marketing Cloud. It's not specifically for segmenting data in the way described. D. Data Filter: This is essentially a saved set of criteria (similar to Filter Activity) that you can apply to a data extension. Again, it might not provide the level of control needed for the described scenario. So, the best choice for Northern Trail Outfitters' requirements is A. Query Activity.

Answer is A as its the Query Activity that will add and update data into data extention. Data Filter will only filter existing data extention and will not add and update another data extention and keep the data that does not match criteria.