Given a Customer's Business Requirements, Configure Segmentation Tools to Accurately Model Subscribers and Data. MARKETING-CLOUD-ENGAGEMENT-SPECIALIST Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   A marketer wants to create a segment of VIP customers who have made a purchase in the last 90 days, but exclude those who have unsubscribed. Which Audience Builder feature allows applying this exclusion?

   • AAutomation Studio
   • BQuery Activity
   • CData extension relationship
   • DExclusion filter
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   In a SQL query, which JOIN type returns only the rows that have matching values in both data extensions?

   • AFULL OUTER JOIN
   • BINNER JOIN
   • CRIGHT JOIN
   • DLEFT JOIN
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A retail client stores customer records in a single data extension with fields for CustomerID, Email, FirstName, LastName, and PurchaseDate. The client wants to send a campaign to customers who have purchased in the last 90 days, but the marketing team also needs to track each customer's total number of purchases. What is the most appropriate data model change to support this requirement?

   • ACreate a separate data extension for purchases with a foreign key to CustomerID, and use a query to aggregate purchase counts per customer.
   • BUse the existing data extension as-is and create a filter to select customers with a PurchaseDate within the last 90 days.
   • CCreate a new data extension that duplicates all customer fields plus a PurchaseCount field, and populate it via a one-time import.
   • DAdd a new field called TotalPurchases to the existing data extension and update it manually each time a purchase occurs.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A filter is set to include subscribers who are from 'New York' AND have a 'VIP' status. What does the AND operator do in this filter logic?

   • ARequires both conditions to be true
   • BRequires at least one condition to be true
   • CGroups conditions for readability only
   • DExcludes records that meet either condition
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   In a filter, which operator would you use to include subscribers whose age is greater than or equal to 18?

   • A>
   • B=
   • C<
   • D>=
   Reveal Solution Discussion Select an answer first