certified-marketing-cloud-consultant Sample Questions & Answers
Built around data modeling through Contact Builder and SQL, the single biggest weight, plus Automation Studio and Journey Builder tied with Marketing Cloud Connect integrations, requirements gathering, account setup, and email build and testing.
Launch the full certified-marketing-cloud-consultant simulator →Showing 10 of 20 free samples.
- Question 1Advanced
Messaging · AMPscript
A marketing team wants to personalize an email with the recipient's most recently purchased product. The sendable data extension contains the
SubscriberKey. A separate data extension namedPurchaseHistorycontainsSubscriberKey,ProductName, andPurchaseDate. How should AMPscript be used to retrieve theProductNamefor the most recent purchase?Show answer & explanation
Correct answer: A
The
LookupOrderedRows()function is the correct choice as it allows you to retrieve a set of rows and specify the order. By ordering thePurchaseDatein descending order and limiting the result to one row (or just taking the first row of the result set), you can reliably get the most recent purchase. - Question 2IntermediateSelect 3
Integration · Marketing Cloud Connect Configuration
A consultant needs to configure Marketing Cloud Connect. Which of the following are mandatory prerequisites for a successful setup? (Select THREE)
Show answer & explanation
Correct answers: A, B, D
The setup requires a user with System Administrator permissions in the CRM org to install the managed package and configure the connection.
The Marketing Cloud user that connects to the CRM org needs full administrative permissions to establish the connection and configure settings within Marketing Cloud.
This describes the creation of the API users. The Marketing Cloud API User connects to Salesforce, and the Salesforce API User (with the specified permission set) connects to Marketing Cloud, forming the secure, authenticated bridge between the two systems.
- Question 3Intermediate
Account Configuration · Business Unit Strategy
A client has two distinct brands, 'Brand A' and 'Brand B', with separate marketing teams, creative assets, and subscriber lists. The legal team requires that subscribers who unsubscribe from Brand A communications must not be unsubscribed from Brand B, and vice-versa. Tracking and reporting must also be kept completely separate. Which account structure should the consultant recommend?
Show answer & explanation
Correct answer: A
Business Units (BUs) are the standard way to segregate branding, assets, subscribers, and reporting. Each BU has its own unsubscribe list, ensuring that an unsubscribe from Brand A only affects that BU. This structure perfectly aligns with the client's requirements for data and operational separation.
- Question 4Beginner
Integration · Sales/Service Cloud Data Segmentation
True or False: When using the Salesforce Data entry source in Journey Builder, the evaluation of entry criteria occurs within the Sales/Service Cloud platform before any data is injected into the Marketing Cloud journey.
Show answer & explanation
Correct answer: A
This is true. The Salesforce Data entry event leverages a 'flow' that runs on the core Salesforce platform. It evaluates records against the defined criteria, and only those that meet the criteria are then passed to Marketing Cloud to enter the journey. This is a key architectural aspect that makes the entry source efficient.
- Question 5Advanced
Automation · Automation Workflows
Case Study:
Global Airways, an international airline, is implementing Marketing Cloud to enhance its customer communication. Their primary goals are to deliver personalized pre-flight, in-flight, and post-flight communications, and to manage their loyalty program, 'SkyMiles'. They have several key systems and requirements.
Systems & Data:
- Booking System (On-Premise): The source of truth for all flight bookings. It outputs a flat file of all new and updated bookings every 15 minutes to a secure FTP server. Each booking has a unique
BookingReferenceand is linked to aPassengerID. - Loyalty System (Cloud-based): Manages the SkyMiles program. It contains member profiles, tier status, and points balance. This system can be accessed via a REST API.
- Sales Cloud: Used by customer service agents to view passenger history and log service cases. It is not the system of record for passenger or loyalty data.
Requirements:
- A pre-flight journey must be triggered 72 hours before a flight's departure time. This journey should check the passenger's SkyMiles tier from the Loyalty System to offer different ancillary services (e.g., lounge access for Gold members).
- A post-flight survey email must be sent 24 hours after the flight's arrival.
- The Subscriber Key in Marketing Cloud must be the unique
PassengerID. - Data from both the Booking and Loyalty systems must be available for segmentation and personalization.
Which combination of Automation Studio and Journey Builder design best meets Global Airways' requirements?
Show answer & explanation
Correct answer: C
This is the most robust and accurate solution. The file drop automation keeps the booking data fresh. A separate, frequently running (hourly) automation acts as the journey 'gatekeeper', precisely identifying and injecting passengers into the journey at the correct time based on their departure date. This ensures the 72-hour pre-flight and 24-hour post-flight timing is met accurately. The Loyalty data can be linked in Contact Builder or queried via AMPscript/API call within the journey.
- Booking System (On-Premise): The source of truth for all flight bookings. It outputs a flat file of all new and updated bookings every 15 minutes to a secure FTP server. Each booking has a unique
- Question 6Beginner
Data Modeling and Management · Data Model Design
A consultant is conducting a discovery session with a new client who is unfamiliar with Marketing Cloud. The client wants to understand the fundamental difference between using a List and a Data Extension for storing subscriber data. Which statement best articulates the primary advantage of using Data Extensions over Lists?
Show answer & explanation
Correct answer: B
This is the core advantage. Data Extensions are flexible tables that can store any type of data, be related to one another (like a database), and crucially, allow a unique identifier other than an email address to be the Subscriber Key. This is fundamental for building a robust, single customer view in Contact Builder and integrating with systems like CRMs.
- Question 7Intermediate
Account Configuration · User Management and Roles
A client wants to ensure that any marketing user who creates emails cannot send them without a final review from a marketing manager. The marketing manager needs the ability to approve content and initiate the send, but should not be able to modify user permissions or account settings. Which combination of standard Marketing Cloud roles should be assigned?
Show answer & explanation
Correct answer: B
This is the correct combination. The Content Creator role can create and edit content but cannot send or publish. The Marketing Cloud Channel Manager role has permissions to review, approve, and send communications across channels like Email Studio and Journey Builder, without having administrative access to account setup or user management.
- Question 8Intermediate
Automation · SQL Query Activity
A consultant is reviewing an Automation Studio workflow that consistently fails on an SQL Query Activity. The error message indicates a primary key violation when trying to overwrite a results data extension. What is the most likely cause of this error?
Show answer & explanation
Correct answer: A
A primary key constraint requires that every value in that column (or combination of columns) must be unique. A primary key violation error during an overwrite or update operation almost always means the SQL query's result set contains two or more rows with the same value for the primary key field.
- Question 9Intermediate
Data Modeling and Management · Send Logging
A client needs to capture detailed send-time data for every email sent, including attributes from the source data extension like
ProductSKUandOfferCode, to use for advanced analytics in an external data warehouse. The standard tracking reports and data views do not provide this level of detail tied to specific send attributes. What Marketing Cloud feature should be implemented?Show answer & explanation
Correct answer: A
Send Logging is the feature specifically designed for this use case. It allows you to create a data extension that captures a row of data for every single email sent to each subscriber. You can include standard email job fields as well as custom attributes from the sendable data extension, such as
ProductSKUandOfferCode, providing the granular data needed for external analytics. - Question 10Beginner
Messaging · Personalization and Dynamic Content
A marketing team at a travel agency wants to send a promotional email. The email's hero image should change based on the subscriber's preferred destination, which is stored in a 'Preferred_Destination' field in the sendable data extension. The possible values are 'Beach', 'Mountain', and 'City'. For any other value, a generic 'Travel' image should be shown. Which personalization method is most suitable for this requirement?
Show answer & explanation
Correct answer: B
Dynamic Content is the ideal feature for this scenario. It allows a user to define rules based on subscriber attributes (like 'Preferred_Destination') to display specific content blocks. It's a user-friendly, declarative tool perfect for a finite number of variations and a default case.
Ready for the real thing?
The full certified-marketing-cloud-consultant simulator has every exam-style question, timed mode, and instant scoring.