Salesforce Certified Marketing Cloud Email Specialist Practice Questions
Prepare for Marketing-Cloud-Email with more than an answer.
- Exam fee
- $200 USD
- Level
- Specialist
- Valid for
- Requires maintenance exams for each Salesforce release
Domains covered on the exam 6
- Email Marketing Best Practices15%
- Email Message Design13%
- Content Creation and Delivery18%
- Marketing Automation19%
- Subscriber and Data Management28%
- Tracking and Reporting7%
- 1
A university uses a single, master Data Extension for all student communications. They want to send a monthly newsletter, but allow students to opt-out of just the newsletter without being globally unsubscribed. The university does not want to manage dozens of separate Data Extensions for each communication type. What is the most scalable and recommended solution for managing this specific opt-out preference?
Show answer details
Correct answer: C
Publication Lists are the standard, out-of-the-box solution for managing communication-specific opt-outs. By associating a 'Monthly Newsletter' Publication List with the send, subscribers who opt-out will be marked as 'Unsubscribed' on that specific list, leaving their global status intact. This automatically appears as an option in the default Subscription Center.
- 2
Case Study:
An e-commerce company, 'Urban Trendz', has a nightly automation that processes order confirmation emails. The automation has been running successfully for months but has suddenly started failing. The business requires these transactional emails to be sent within 15 minutes of an order being placed.
The automation workflow is as follows:
- File Drop Starting Source: A CSV file of new orders is dropped onto the SFTP.
- Import File Activity: The CSV is imported into a 'DailyOrders' sendable Data Extension, configured to 'Overwrite'.
- Send Email Activity: An email is sent to the 'DailyOrders' DE.
The administrator checks the automation history and sees the 'Import File Activity' has a 'File Not Found' error, even though the operations team confirms the file is being placed on the SFTP every night.
What is the most likely cause of this failure?
Show answer details
Correct answer: C
A 'File Not Found' error on a previously working File Drop automation is a classic symptom of a race condition. It is highly probable that another automation (perhaps a duplicate or an archival process) is also configured to look for the same file pattern in the same SFTP location. That other automation is running first, processing the file, and potentially deleting it, so when this automation runs, the file is no longer there.
- 3
A marketer wants to create a segment of all subscribers who have a Gmail email address. Which segmentation method should be used to create a sendable Data Extension with this audience?
Show answer details
Correct answer: B
While a Data Filter can create a segment, the question specifies creating a sendable Data Extension. An SQL Query Activity is the standard tool for querying a source (like a master DE or a Data View) and populating the results into a target Data Extension. The
LIKEoperator is perfect for finding patterns within a string, such as identifying a specific domain in an email address. - 4
A marketing team is reviewing the tracking data for a recent campaign and is confused by the difference between Total Clicks and Unique Clicks. Which statement accurately describes the distinction?
Show answer details
Correct answer: B
This is the correct definition. If one subscriber clicks three links in an email, it contributes 3 to Total Clicks but only 1 to Unique Clicks. Unique Clicks measures the breadth of the audience that engaged, while Total Clicks measures the overall level of interaction.
- 5
To comply with CAN-SPAM, a physical mailing address must be included in all commercial emails. Which feature provides a centralized, reusable way to manage this address and insert it into emails using a single code snippet?
graph LR A[Email Template] --> B{Code Snippet}; C[Send Classification] --> D[Delivery Profile]; D --> B; B --> E[Final Email];Show answer details
Correct answer: B
The Physical Mailing Address can be defined once in the Account Settings for the business unit. This address can then be inserted into any email using the
%%member_busname%%,%%member_addr%%,%%member_city%%,%%member_state%%,%%member_zip%%personalization strings or thePhysicalMailingAddressAMPscript function. This ensures consistency and compliance. - 6
A financial services firm is implementing a Send Log to archive all email communications for compliance purposes. They have a requirement that the Send Log must capture the specific Journey Builder Activity that initiated the send. Which field must be added to the Send Log Data Extension to automatically capture this information?
Show answer details
Correct answer: C
When an email is sent from Journey Builder, the system can automatically populate the
TriggererSendDefinitionObjectIDfield in a Send Log. This field contains the unique identifier for the Journey Builder Email Activity, allowing marketers to trace a specific send back to its origin within a journey.JourneyIDandActivityIDare not standard system-populated fields in a Send Log for this purpose.JobIDis populated but refers to the overall send job, not the specific journey activity. - 7
A marketing analyst needs to create a report that lists every link clicked by each subscriber for a specific email send job over the past 24 hours. They plan to use a SQL Query Activity in Automation Studio against the system Data Views. Which TWO Data Views must be joined to fulfill this requirement? (Select TWO)
Show answer details
Correct answer: B, C
The
_ClickData View contains records of each click event, includingSubscriberKey,JobID, andLinkNameorLinkContent. This is essential for identifying which links were clicked.The
_SubscribersData View contains subscriber details, including theEmailAddressassociated with aSubscriberKey. This must be joined with the_Clickdata view to retrieve the email address for the report. - 8
A company is migrating from a legacy email platform to Marketing Cloud. The legacy system used Email Address as the unique subscriber identifier. The company wants to use a CRM Contact ID as the Subscriber Key in Marketing Cloud to prepare for a future Sales Cloud integration. During the initial data import into a sendable Data Extension, what is the most critical configuration to ensure the relationship between the old and new identifiers is correctly established at the All Subscribers level?
Show answer details
Correct answer: B
When Subscriber Key is enabled, establishing a Send Relationship on the sendable Data Extension is crucial. By relating the field containing the unique identifier (CRM Contact ID) to the Subscriber Key, you explicitly tell Marketing Cloud to use the values from that field to create new records in the All Subscribers list. This correctly associates the Email Address with the new Subscriber Key (the CRM Contact ID).
- 9
True or False: Once an email job has been sent, the link URLs within the
_ClickData View can be modified using a SQL Query Activity to redirect subscribers to a new page.Show answer details
Correct answer: B
Data Views are read-only system tables. You cannot use SQL DML statements like
UPDATEorINSERTto modify their data. While you can query them to copy data into a Data Extension, the source data within the Data Views is immutable. To change a link post-send, you must use the 'Job Links' feature within Tracking. - 10
A consultant is designing an automation to segment customers for a re-engagement campaign. The goal is to identify subscribers who have not opened or clicked any email in the last 180 days. The consultant proposes the following Automation Studio workflow:
Step 1: SQL Query Activity to join
_Subscribersand_OpenData Views to find recent openers.
Step 2: SQL Query Activity to join_Subscribersand_ClickData Views to find recent clickers.
Step 3: Data Filter Activity to exclude recent openers and clickers from the master subscriber Data Extension.What is the primary flaw in this proposed workflow?
Show answer details
Correct answer: B
This workflow is highly inefficient. A single, more advanced SQL query can identify the unengaged subscribers directly. Using a
LEFT JOINon both the_Openand_ClickData Views from the master subscriber DE and filtering forNULLresults is a far more performant and streamlined approach than running multiple queries and a data filter.
