Understand How Sales / Service Cloud Data in the Marketing Cloud Can Be Segmented. MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   How can email open data from Salesforce (e.g., from EmailMessage records) be used for segmentation?

   • ABy filtering on the 'HasOptedOutOfEmail' field on the Contact.
   • BBy using the 'LastActivityDate' field on the Account object.
   • CBy querying the synchronized EmailMessage object to find contacts who opened emails.
   • DBy importing a report of email opens from Salesforce into a data extension.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A consultant needs to create a segment of contacts who have opened at least one email from a specific send in the last 30 days. The synchronized data extensions include the Send, Job, and Tracking data. Which approach should be used?

   • ACreate a query on the Contact data extension and filter for LastOpenDate within the last 30 days.
   • BUse the Job data extension to identify the send and then manually export the list of opens from Salesforce.
   • CQuery the synchronized Tracking data extension, joining with Send and Contact, filtering for EventType = 'Open' and a date within the last 30 days.
   • DUse the Send data extension and filter for EventType = 'Open'.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A consultant needs to create a segment of contacts who have a 'VIP' flag on their account and have not been contacted in the last 60 days. The synchronized data extensions include Account, Contact, and Send. What is the most efficient way to build this segment?

   • AQuery the Contact data extension, join to Account on Account ID, filter for VIP = true, and left join to Send to exclude contacts with sends in the last 60 days.
   • BQuery the Account data extension for VIP = true and then manually exclude contacts who were sent an email recently.
   • CUse the Send data extension to find contacts who have not received an email in the last 60 days, then join to Account for VIP flag.
   • DCreate two separate queries: one for VIP contacts and one for non-contacted, then combine them manually.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A marketer wants to segment contacts based on the 'Industry' field from the Account object. Which approach uses Salesforce data directly for this segmentation?

   • ACreate a filter on the synchronized Account data extension using the Industry field.
   • BCreate a data extension manually and type in the Industry values for each contact.
   • CAsk the Salesforce admin to change the Industry field values in the CRM.
   • DUse the Marketing Cloud 'Send Preview' feature to select contacts by Industry.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company wants to send a re-engagement campaign to contacts who have not interacted with any email in the last 90 days. The synchronized data extensions include Tracking data. What is the best way to build this segment?

   • ACreate a segment of all contacts and exclude those who have a tracking event in the last 90 days using a filter.
   • BUse the Send data extension to find contacts who were sent an email but did not open.
   • CQuery the Contact data extension and left join to Tracking data, filtering for no tracking events in the last 90 days.
   • DQuery the Tracking data extension for events older than 90 days and use those contacts.
   Reveal Solution Discussion Select an answer first