10/204 questions · Unlock full access
Q1

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?

Q2Multiple answers

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)

Q3

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?

Q4

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.

Q5

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?

Q6

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?

Q7

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?

Q8

**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?

Q9Multiple answers

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)

Q10

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?