Marketing Cloud Software Salesforce Marketing Cloud Email Specialist 5 — Questions and Answers
Question 1: Which SQL statement syntax is used in Automation Studio Query Activities to deduplicate subscribers when multiple rows exist per email address?
- GROUP BY EmailAddress HAVING COUNT(*) > 1
- SELECT DISTINCT EmailAddress FROM ... (Correct answer)
- DELETE DUPLICATES FROM ...
- MERGE INTO ... WHEN MATCHED THEN DELETE
Correct answer: SELECT DISTINCT EmailAddress FROM ...
SELECT DISTINCT returns unique rows, eliminating duplicates when you need only one record per email address in a Query Activity result set.
Question 2: A marketer wants Journey Builder to wait until a contact opens an email before proceeding to the next step. Which activity achieves this?
- Wait by Attribute
- Decision Split based on email open engagement
- Random Split
- Engagement Split (Correct answer)
Correct answer: Engagement Split
An Engagement Split evaluates whether a contact opened, clicked, or didn't interact with an email and routes them down different paths accordingly.
Question 3: What is the function of the 'Preference Center' CloudPage in Marketing Cloud best practices?
- It allows subscribers to manage their email frequency, topics, and contact preferences as an alternative to a full unsubscribe (Correct answer)
- It lets marketers configure their account-level sending frequency caps
- It provides a UI for managing Data Extension field definitions
- It houses the suppression list management for the account
Correct answer: It allows subscribers to manage their email frequency, topics, and contact preferences as an alternative to a full unsubscribe
A Preference Center gives subscribers control over what types of emails they receive and how often, reducing full unsubscribes by offering partial opt-down options.
Question 4: In Marketing Cloud, what does the 'SubscriberKey' represent and why is it important?
- A hashed version of the subscriber's email used for encryption
- A unique identifier for each contact that allows tracking across channels beyond just email address (Correct answer)
- The numeric ID auto-assigned by the All Subscribers list
- An API token generated per subscriber for REST API access
Correct answer: A unique identifier for each contact that allows tracking across channels beyond just email address
The SubscriberKey is a unique identifier per contact that enables consistent tracking and data association across multiple channels, even if the email address changes.
Question 5: A marketer notices a high 'Spam Complaint Rate' after a recent send. Which of the following actions is MOST appropriate as an immediate response?
- Increase send frequency to the same audience to rebuild engagement
- Segment the complaint audience, suppress them from future sends, and review list acquisition practices (Correct answer)
- Switch to a different From address and resend the same email
- Disable tracking on future sends to lower the measured complaint rate
Correct answer: Segment the complaint audience, suppress them from future sends, and review list acquisition practices
Suppressing complainers protects sender reputation, while reviewing list acquisition identifies the source of disengaged or illegitimately acquired subscribers.
Question 6: Which Marketing Cloud feature allows a marketer to display different email content to subscribers based on their geographic region stored in a Data Extension?
- Einstein Recommendations
- Dynamic Content rules referencing a Data Extension attribute (Correct answer)
- Predictive Email Subject Lines
- Behavioral Triggers
Correct answer: Dynamic Content rules referencing a Data Extension attribute
Dynamic Content rules can reference Data Extension attributes such as region, displaying different content blocks to subscribers based on their stored values.
Question 7: What is the purpose of setting a 'Publication List' on a send classification in Marketing Cloud?
- It defines which IP pool the send will use for delivery
- It determines the audience size limit for the send
- It links the send to a specific opt-out list so unsubscribes are recorded to the correct list (Correct answer)
- It automatically adds all recipients to an engaged segment after the send
Correct answer: It links the send to a specific opt-out list so unsubscribes are recorded to the correct list
A Publication List on a send classification tells Marketing Cloud which list to update when a subscriber opts out, scoping unsubscribes to the correct publication.
Marketing Cloud Software Salesforce Marketing Cloud Email Specialist 5
Which SQL statement syntax is used in Automation Studio Query Activities to deduplicate subscribers when multiple rows exist per email address?