Marketing-Cloud-Email sample questions

Question 1

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?

Accepted Answer

TriggererSendDefinitionObjectID

Answer

JourneyID

Answer

ActivityID

Answer

JobID

Question 2

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)

Accepted Answer

_Click

Accepted Answer

_Subscribers

Answer

_Job

Answer

_Sent

Answer

_Open

Question 3

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?

Accepted Answer

In the sendable Data Extension, create a Send Relationship that relates the CRM Contact ID field to Subscriber Key.

Answer

Set the Email Address field as the Primary Key in the sendable Data Extension.

Answer

Import the data into a list first, then export and re-import into a Data Extension with the Subscriber Key mapped.

Answer

Ensure the import file has a column named 'SubscriberKey' that contains the CRM Contact ID.

Question 4

True or False: Once an email job has been sent, the link URLs within the `_Click` Data View can be modified using a SQL Query Activity to redirect subscribers to a new page.

Accepted Answer

False

Answer

True

Question 5

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 `_Subscribers` and `_Open` Data Views to find recent openers.
Step 2: SQL Query Activity to join `_Subscribers` and `_Click` Data 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?

Accepted Answer

The workflow is inefficient; a single SQL Query Activity can achieve the desired segmentation.

Answer

A Data Filter cannot be used on a master subscriber Data Extension.

Answer

The `_Subscribers` Data View does not contain the necessary information to join with engagement data.

Answer

Engagement data older than 90 days cannot be reliably queried from Data Views.

Question 6

A retail company wants to use a single master sendable Data Extension for all promotional emails. This DE contains profile data but not transactional data. For an upcoming 'Abandoned Cart' email, they need to display product details from a separate 'AbandonedCart_Products' Data Extension. The relationship between a subscriber and their abandoned products is one-to-many. Which AMPscript function is most appropriate for retrieving and displaying all abandoned products for each subscriber within the email?

Accepted Answer

LookupRows()

Answer

Lookup()

Answer

ClaimRow()

Answer

LookupOrderedRows()

Question 7

A marketing team is using Send Throttling to manage the delivery of a large email campaign over 8 hours, from 9 AM to 5 PM. An unexpected server issue causes the Marketing Cloud mail queue to be paused for 2 hours between 11 AM and 1 PM. What will happen to the emails that were scheduled to be sent during the pause?

Accepted Answer

The send will automatically extend past 5 PM to deliver the remaining emails.

Answer

The emails will be discarded and marked as 'Errored' in the send tracking.

Answer

The system will attempt to send the delayed emails at a faster rate to finish by 5 PM.

Answer

The send will complete at 5 PM, and any unsent emails will remain in the queue indefinitely.

Question 8

**Case Study:**

Global Retail Inc. is implementing Marketing Cloud and needs to design a data model to support personalized email campaigns. They have several data sources: a CRM system with customer profiles, a web analytics platform with browsing history, and an e-commerce platform with purchase history. The primary identifier across all systems is a unique `CustomerID`.

The marketing team's requirements are:
1. Segment customers based on their total lifetime value (LTV), which needs to be calculated from all past purchases.
2. Personalize emails with recently viewed products.
3. Create journeys for customers who purchase from a specific product category (e.g., 'Footwear').
4. All email sends must be logged for auditing purposes.

The proposed data architecture in Contact Builder involves creating three main Data Extensions: 'Customers' (from CRM), 'Purchases' (from e-commerce), and 'Web_Views' (from web analytics). The 'Customers' DE will be the primary sendable DE.

Which data model design in Contact Builder best supports all of the stated requirements?

Accepted Answer

Create a single Attribute Group. Link the 'Customers' DE to the Contact Record on CustomerID to Subscriber Key. Then, create one-to-many relationships from 'Customers' to 'Purchases' and 'Web_Views' using CustomerID.

Answer

Create three separate Attribute Groups, one for each data source. Link each to the Contact Record using CustomerID.

Answer

Use an SQL Query to flatten all data into a single, wide sendable Data Extension that is overwritten daily.

Answer

Use Lists for customer profiles and Data Extensions for transactional data, linking them with AMPscript at send time.

Question 9

A consultant is reviewing a client's Marketing Cloud account and finds that their email deliverability has been steadily declining. The investigation reveals that the client has not implemented a Sender Authentication Package (SAP). Which THREE of the following are direct benefits of implementing an SAP? (Select THREE)

Accepted Answer

It provides a dedicated IP address, separating the sender's reputation from other Marketing Cloud customers.

Accepted Answer

It removes all Salesforce branding from links and images, creating a seamless brand experience.

Accepted Answer

It authenticates emails on behalf of the sending domain, helping to build trust with ISPs.

Answer

It automatically cleans the subscriber list of invalid email addresses before each send.

Answer

It guarantees a 100% inbox placement rate at major email providers like Gmail and Outlook.

Question 10

A marketer sets up an A/B test for a subject line. The test is configured to send to 20% of the audience (10% for version A, 10% for version B), wait 4 hours, and declare a winner based on the highest Unique Open Rate. The total audience size is 500,000. After 4 hours, the results are inconclusive because the open rates are statistically tied. What is the default behavior of the A/B test feature in this scenario?

Accepted Answer

The system sends Version A to the remaining 80% of the audience.

Answer

The system sends Version B to the remaining 80% of the audience.

Answer

The remainder send is canceled, and a notification is sent to the user.

Answer

The system randomly splits the remaining 80% of the audience between Version A and Version B.

Top vendors

Top exams

Free Marketing-Cloud-Email sample questions

True or False: Once an email job has been sent, the link URLs within the `_Click` Data View can be modified using a SQL Query Activity to redirect subscribers to a new page.

10 more free samples are waiting