Certified Marketing Cloud Consultant Mock Test Free – 50 Realistic Questions to Prepare with Confidence.
Getting ready for your Certified Marketing Cloud Consultant certification exam? Start your preparation the smart way with our Certified Marketing Cloud Consultant Mock Test Free – a carefully crafted set of 50 realistic, exam-style questions to help you practice effectively and boost your confidence.
Using a mock test free for Certified Marketing Cloud Consultant exam is one of the best ways to:
- Familiarize yourself with the actual exam format and question style
- Identify areas where you need more review
- Strengthen your time management and test-taking strategy
Below, you will find 50 free questions from our Certified Marketing Cloud Consultant Mock Test Free resource. These questions are structured to reflect the real exam’s difficulty and content areas, helping you assess your readiness accurately.
A retail company's database of record resides at a third party company that also keeps track of purchase history. Their database only updates once a day where new records can be created and merged. The database uses the unique identified "Customer ID". The company wants to send real-time Welcome emails to newly registered website users who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Customer ID" in the database. What three key issues should be addressed? (Choose three.)
A. How will Marketing Cloud and the database synchronize?
B. What will be used as Subscriber Key?
C. Will the company need a custom preference center?
D. What publication lists will be used?
E. Will new users have a “Customer ID”?
Northern Trail Outfitters wants to automate the daily segmentation of their master subscriber data extension into smaller data extensions based on subscriber preferences. Which two Automation Studio activities could they choose from to segment their data into existing data extensions? (Choose two.)
A. Script Activity
B. Refresh Group Activity
C. Publish Audience Activity
D. Query Activity
How do you add a contact in contact builder? (Choose two.)
A. Import to All Subscribers List.
B. Add manually to All Subscribers.
C. Import to MyLists.
D. Import to DE.
A customer is developing a new eCommerce section of their website and plans to leverage transactional data in customer journeys. Which two Marketing Cloud features will support this effort? (Choose two.)
A. Data Designer
B. Cloud Pages
C. Web Analytics Connector
D. Content Builder
Northern Trail Outfitters is having their regional supplier conference and wants to allow attendees to request event-specific safety notifications, schedule or room changes, and surprise pop-up sessions. Which solution should they use?
A. Existing Email Event Notification Subscription
B. CloudPages opt in to Event Journey
C. Smart Capture and Triggered email messaging
D. Keyword opt in and SMS Messaging
Northern Trail Outfitters (NTO) account will be used for email communications with its clients and employees. They want to send from two different subdomains, so they have delegated e.nto.com as their SAP domain and mail.nto.com as an additional Private Domain. Which statement describes how this will impact the account?
A. Links within emails will be wrapped with the same subdomain used for the From Address within the Sender Profile.
B. Links within emails will be wrapped with e.nto.com, and images within Content Builder will use e.nto.com.
C. Links within emails will be wrapped with mail.nto.com, but images within Content Builder will use e.nto.com.
D. Links within emails will be wrapped with e.nto.com, but images within Content Builder will use mail.nto.com.
A customer provides a file containing only new and updated subscriber records exported from its marketing database. ✑ The file will be uploaded to the customer's Enhanced FTP automatically at 3 a.m. daily. ✑ The customer requires that the import completes prior to 4 a.m. ✑ On average, the file will contain about two million rows of data each day. Based on the customer's requirements and recommended best practices, how should the daily file be imported?
A. Import the file into a list, using the ‘update only’ method.
B. Import the file into a list, using the ‘add and update’ method.
C. Import the file into a data extension, using the ‘add and update’ method.
D. Import the file into a data extension, using the ‘overwrite’ method.
A customer is creating a re-engagement campaign. The campaign only targets subscribers who have had emails fail at send time due to held status within the last 60 days. The goal is to send an SMS to the subscribers asking them if they want to update their email address. What should a consultant recommend to meet the criteria?
A. Use SQL Query and File Transfer activities from Automation Studio to inject the subscribers into an API Event used as an Entry Source by Journey Builder.
B. Use Tracking Extract, File Transfer, and Import activities from Automation Studio to inject the subscribers into a data extension used as an Entry Source by Journey Builder.
C. Use SQL Query and Import activities from Automation Studio to inject the subscribers into a data extension used as an Entry Source by Journey Builder.
D. Use Data Extension Extract and Import activities from Automation Studio to inject the subscriber into a CloudPage used as an Entry Source by Journey Builder.
Northern Trail Outfitters is using a triggered send to send customers their order confirmations. Their commerce platform provides a JSON payload for order details. What would they use to format the JSON within the email?
A. TransformJSON() AMPscript Function
B. ParseJSON content block within Content Builder
C. BuildRowSetFromJSON() AMPscript Function
D. SSJS platform function ParseJSON
A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and Products. The data extensions contain the following information: ✑ Orders: OrderID, CustomerID, OrderNumber, OrderDate, OrderTotal, GrandTotal. ✑ Order_Details: ProductID, OrderID, Qty, UnitPrice, ExtendedPrice, Discount. ✑ Products: ProductID, SKU, Name, Description, Cost, Price. Which two actions should be taken in Data Designer? (Choose two.)
A. Create a one-to-many relationship between Orders and Order_Details.
B. Create a one-to-one relationship between Orders and Order_Details.
C. Create a one-to-one relationship between Order_Details and Products.
D. Create a one-to-one relationship between the contact record and Order_Details.
Northern Trail Outfitters wants to suppress their highly engaged email subscribers (multiple opens and clicks for a target campaign) from active display campaigns to reduce overall cost and eliminate unnecessary targeting to the user. What should be recommended?
A. Google Analytics 360
B. Data Studio
C. Einstein Engagement Scoring
D. Audience Studio
A customer wants to limit the number of emails a subscriber receives to a maximum of one email every 14 days. After the 14-day period, the subscriber is eligible to receive the next message. What should a consultant recommend to meet these criteria?
A. Query all subscribers from the Sent Data View when creating the send.
B. Create an exclusion data extension populated with the identified subscribers.
C. Create a suppression list populated with the identified subscribers.
D. Import the identified subscribers into a list when creating the send.
Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way. What should be recommended?
A. Implement a new SSL Certificate for the new brand.
B. Request a second SAP for the existing business unit.
C. Create a new business unit for the new brand.
D. Request a Private Domain to be added to the existing business unit.
Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to five emails per week based on subscriber activity. The list is: ✑ Compiled in a database in the website Content Management System (CMS). ✑ Imported into Marketing Cloud nightly at 11 p.m. What action should be taken if a third party is sending a message for the customer outside of Marketing Cloud?
A. Unsubscribes should be synchronized between senders.
B. They will need to integrate with the Marketing Cloud SOAP API.
C. Engagement metrics will be passed into Marketing Cloud.
D. The third-party send list should be pulled from the CMS.
The customer has the following requirements for storing engagement data in their data warehouse: ✑ All email open and click activity must be pulled daily from Marketing Cloud. ✑ Output files must meet the specific requirements for the data warehouse. ✑ All the activity must be provided via SFTP in one file. Which automation workflow meets the customer requirements?
A. Report activity that generates Recent Send Summary report > Report delivered directly to SFTP
B. Data Extract activity of Tracking Extracts that combines data into required file > File Transfer Activity
C. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity
D. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity
Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed. What should the consultant do to diagnose the issue?
A. Ensure the System User is assigned the Standard User Profile.
B. Change the connection option to Scope by User.
C. Initiate a log to troubleshoot package-related API calls.
D. Manually clear the OAuth token to refresh the connection.
A customer wants to automate the process of sending a series of welcome emails based on the subscriber's data. ✑ Emails should be sent weekly for up to five weeks. ✑ If a subscriber makes a purchase, they should stop receiving welcome emails. ✑ A Boolean flag should be set in a data extension if the subscriber makes it through the welcome series. Which steps should be used to accomplish this in Journey Builder?
A. Update Contact Data, Wait, Send Email, Join.
B. Random Split, Send Email, Wait Define Goal.
C. Define Goal, Send Email, Wait, Decision Split.
D. Define Goal, Update Contact Data, Send Email, Wait.
A customer needs to link demographic information to its contact model in Contact Builder. What type of relationship should be used?
A. One-to-Many Relationship
B. Many-to-One Relationship
C. Many-to-Many Relationship
D. One-to-One Relationship
A customer is collecting data from a Smart Capture form that stores submissions in a data extension. The customer wants an email was sent to the marketing manager each morning that contains the previous days submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled. Which automation workflow will accomplish this?
A. Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email
B. Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email
C. Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
D. Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email
If I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out. What is the issue causing less emails to go out?
A. Preference center is too strict.
B. High Watermark if journey builder.
C. Email frequency too high.
D. Deliverability issues on account.
Northern Trail Outfitters (NTO) wants to use dynamic content within their emails to provide customers with more personalized communications. This includes using a Dynamic Sender Profile to customize the From Name and From Email Address to use the regional store manager's information. If a new manager is assigned to a region, NTO only wants to update the information in one place. What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?
A. Each customer’s region code and the manager’s name and email address for each region code.
B. Name and email address for each regional store manager stored on a lookup table.
C. Regional store manager’s name and email address for each customer.
D. Region code, regional store manager’s name, and email address for each customer.
A customer wants to display a subscriber's first name and the date of send in its monthly newsletter. Subscriber first name data is stored in a data extension that will not be used in the send definition. Which option should be in this scenario?
A. Guide Template Language
B. Personalization strings
C. AMPscript
D. SQL Query
A customer is using Marketing Cloud Connect but not sending tracking back to Sales Cloud. They want to create a Task on Contact and Lead records for follow up when someone has not opened five emails in a row. Which activities could be used to fulfill this requirement?
A. API Event Entry, SQL Query Activity, Task Activity
B. Scheduled Automation, Filter Activity; Data Extension Entry, Contact Activity
C. Salesforce Data Entry, SQL Query Activity, Task Activity
D. Scheduled Automation, SQL Query Activity; Data Extension Entry, Task Activity
Northern Trail Outfitters stores birthdate on the contact object in the Salesforce CRM. They want to inject the contact into a journey on their birthday. Which two Journey Builder entry process configurations allow for an injection using the customer's birthday? (Choose two.)
A. An automation with query activity using Contact object Synchronized Data Extension then Journey Entry Activity
B. Journey Builder Date Based Event using Contact Data related to Synchronized Data Source Attribute Group
C. DMP Entry Event from Audience Studio using Date of Birthday equal to Today Segmentation
D. Salesforce Data Entry event with filter criteria on Contact Object where ‘Date of Birthday equal to Today’
ABC Company has scenario of a journey for "post-purchasing communication". Which re-entry setting is correct?
A. re-entry after time
B. re-entry only after exiting
C. no re-entry
D. re-entry anytime
A marketer wants to create and edit email content, as well as generate reports and manage subscriber data. Using the principle of least privilege, which two pre-defined roles should be assigned? (Choose two.)
A. Administrator
B. Data Manager
C. Content Creator
D. Analyst
A pharmaceutical company is hosting a monthly event and will be sending an invitation to new local contacts. The customer would like to automatically update a data extension to determine who will be attending. ✑ The data extension will hold each contact's response as well as the time stamp of the click. ✑ The contact will receive an email two days after the click event. ✑ Both emails should be sent via Journey Builder. What is the optimal solution to record the click activity prior to sending the second email?
A. Leverage the Decision Split and create a Custom Activity.
B. Use a landing page to record the click and trigger an email.
C. Leverage the Engagement Split and the Update Contact Activity.
D. Use a landing page to record the click in the data extension.
Northern Trail Outfitters sends emails for Password Resets from their web store when requested. An SMS message should be deployed if the password reset email is not sent. What processes should they utilize to ensure a timely delivery across email and SMS?
A. Transactional email send with the event notification service response to determine and trigger an API call to an SMS message
B. Multiple path journey with engagement split if password reset link clicked; if link not clicked, then SMS Password Reset activity
C. Triggered send definition, and use API response to determine and send API call to trigger an SMS password reset
D. Triggered send definition and use data extract Not Sent to a data extension then send SMS to those failed sends
What is the capability of the Import within Contact Builder? (Choose two.)
A. The target destination can be a DE, list, or All Contacts for Mobile Push or Connect.
B. The data source can be a local file, data filter, or file on any FTP.
C. Like the Import Wizard, the Contact Builder import definition can be executed without saving.
D. In order to use Map by Header Row, the fields in the DE and file must match exactly.
A restaurant supply company captures email subscribers and leads through trade shows. They hold a giveaway at each trade show to entice booth visitors to leave their contact information. In the past, they have used a fishbowl to capture business cards, but need to update this to an online sweepstakes entry vehicle displayed on a mounted tablet. Individuals should only be allowed to enter once, and the winner will be selected randomly. All entrants receive a follow-up email after the trade show asking them to confirm their opt-in for a monthly newsletter. Which two components are appropriate for this solution? (Choose two.)
A. Microsite with Web Collect to store entrants on a data extension.
B. Send Email Activity with a link to a subscription center.
C. Data Extension with double opt-in status defined.
D. Microsite with Smart Capture to store entrants on a data extension.
Northern Trail Outfitters has configured Reply Mail Management to handle manual unsubscribe requests. However, they have received complaints from customers who are still getting marketing emails despite having sent multiple unsubscribe replies including phrases like `take me off your list` or `opt out`. How could this behavior be corrected?
A. Ensure ג€Common Misspellingsג€ is selected as one of the Reply Filters
B. Ensure the DNS Record Redirect is correctly configured
C. Ensure the two phrases are added to a filtered keyword list
D. Ensure the two phrases are added to the ג€Filtered Keywordsג€ data extension
A customer has been having problems with SMS responses getting the default keyword response rather than the appropriate next keyword response. What are two potential reasons for this unexpected response? (Choose two.)
A. Next keyword was not specified on the outbound message.
B. Response contained ג€stopג€ in the message content.
C. Responses are not sent within 24 hours of the outbound message.
D. Responses are sent after the 60 minute conversation window.
An entertainment customer has added a new business unit for one of its record labels. It has also purchased a Sender Authentication Package (SAP) and owns the branded domain. What is necessary to complete SAP setup?
A. Configure link wrapping to redirect to the business unit’s subdomain
B. Configure custom Reply Mail Management for the business unit’s subdomain
C. Delegate a specific subdomain to the Marketing Cloud name servers
D. Route the domain through an IP address unique to the business unit
Which three statements are correct about Data Designer? (Choose three.)
A. Each attribute group contains one data extension, and each data extension can include up to 50 attributes.
B. Each attribute group can contain multiple lists, and each list can include multiple attributes.
C. Data extensions can be linked to either the contact record or different data extensions, including data extensions from other attribute groups.
D. Each attribute group can contain multiple data extensions, and each data extension can include multiple attributes.
E. Data extensions should be linked directly to the contact record prior to being linked to different data extensions.
A customer wants Sales Cloud users to create and send Marketing Cloud emails. Which two recommendations should the consultant make? (Choose two.)
A. The consultant should enable deep linking in Marketing Cloud Connect configuration.
B. Each user should have a one-to-one relationship between the Marketing Cloud user and the Sales Cloud user.
C. Each Sales Cloud user should have a System Administrator Profile and a Role at the top of the Role Hierarchy.
D. The consultant should enable the Create Email feature on the user Profile in Sales Cloud.
A customer plans to configure multiple Business Units (BU) to support the digital marketing efforts of five international offices. Which reason warrants this implementation?
A. Support non-English responses with Reply Mail Management.
B. Localized language and display options based on location and culture.
C. Localized physical mailing address displayed in the default email footer.
D. Tracking information for campaigns sent by each office.
Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, is housed in a separate data extension than the one used for journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the journey source and transaction data extensions. Which activity would they use to accomplish this?
A. Decision Split Activity using both Contact and Journey Data
B. Decision Split Activity using only Journey Data
C. Einstein Split Activity
D. Decision Split Activity using only Contact Data
Collect addresses through Smartcapture, segment the data, send emails referencing data from a data extension. What skillset is needed?
A. AMPscript
B. CSS
C. HTML
D. SQL
Northern Trail Outfitters (NTO) wants to send using the From Address of marketing@email.nto.com . They will then automatically forward replies to customerservice@nto.com . NTO also wants to include an automatic reply to the customer's email address customer@example.com . Which email address would appear as the From Address for the automatic reply to the customer?
A. reply@marketingcloud.com
B. marketing@email.nto.com
C. customerservice@nto.com
D. customer@example.com
What are two possible outcomes when "Send as Multipart MIME" is selected during the send process? (Choose two.)
A. The email will avoid detection by various SPAM filters.
B. Open and click activity are tracked in either version.
C. An auto-generated text version will be sent with your HTML email.
D. A custom text version will be sent with your HTML email.
Northern Trail Outfitters (NTO) wants to find ways to better drive return on investment and growth via their marketing sends. They plan to centralize their analytics data to allow for a more efficient analysis of this data across all of their campaigns. NTO currently has Marketing Cloud, Sales Cloud, and Amazon Redshift. What product would help their use case?
A. Report Studio
B. Datorama
C. Interaction Studio
D. Web Analytics Connector
Northern Trail Outfitters has a data extension that stores all of their orders. They want to send out a daily email for orders with their status changed to `˜shipped' that day through a journey. Which two methods should be used to filter entry into the journey? (Choose two.)
A. Entry Source Filter
B. Decision Split
C. SQL Query
D. Filter Activity
A subscriber asked to be removed from a customer's email list multiple times by replying directly to the customer's marketing message, but continues to receive emails. Which three settings should be confirmed? (Choose three.)
A. Reply Mail Management (RMM) is configured for the customer’s account.
B. The RMM setting ‘Delete auto-replies and out-of-office replies’ is set to NO.
C. An email address was provided as the Routing Address for Remaining Replies.
D. The RMM setting ‘Unsubscribe Manual Requests’ is set to YES.
E. The subscriber’s request contained one of the standard terms that qualify for automatic unsubscribe.
Northern Trail Outfitters is interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a data extension for sending. The data warehouse can be configured to place a file daily on an SFTP. Which three questions are relevant to determining a solution? (Choose three.)
A. Does someone need to be notified if an error happens on import?
B. Will the file have more than 5,000 rows?
C. Does the file have demographic data?
D. Is the data file a delta or a historical file?
E. Will the data file be placed on the SFTP at the same time daily?
Northern Trail Outfitters sends a monthly loyalty balance email to inform members of their current points balance. Emails are segmented based on loyalty status, and no segment should contain more than 2500 contacts for any send. What should be used to prevent emails from being sent if they exceed 2500 contacts?
A. Query Activity
B. Script Activity
C. Stop Activity
D. Verification Activity
Northern Trail Outfitters wants to improve their personalization of goods and services using an expansive set of data. What product facilitates the sharing of first, second, and third-party data between data gathering partners?
A. Data Studio
B. Personalization Builder
C. Contact Builder
D. Interaction Studio
Northern Trail Outfitters recently upgraded their preference center to allow customers to indicate which products they are interested in and to have the ability to opt up and down in send volume. They would like to configure the Delivery Options in a Journey Builder Email Activity to take these new data points into account. Which two options could allow them to meet the requirement? (Choose two.)
A. Suppression List
B. Auto-Suppression List
C. Domain Exclusion
D. Publication List
A B2B customer has customized journeys they want to use for several key accounts they are trying to sell into. How could Marketing Cloud Connect be used to initiate these sends when contacts for select accounts are created?
A. Salesforce Data Entry Source on the Contact Object
B. Salesforce Campaign Entry Source on the Lead Object
C. Salesforce Data Entry Source on the Account Object
D. Welcome Email Configuration on the Account Object
Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeroes, but they will NOT be included in the final values. Which data type should they use for the Order ID field?
A. Number
B. Text (15)
C. Decimal (15,2)
D. Decimal (15,0)
Analyst of Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting. These metrics need to be reported per email campaign for each of NTO's Business Units: * Number of Sends * Delivery Rate * Overall Bounce Rate * Block Bounce Rate * Open Rate * Click Rate * Complaint Rate * Unsubscribe Rate Which email report should NTO's Marketing Analyst pull from Marketing Cloud to get this information?
A. Campaign Email Tracking Report
B. Account Send Summary Report
C. Email Send Report
D. Email Performance Over Time Report
Access Full Certified Marketing Cloud Consultant Mock Test Free
Want a full-length mock test experience? Click here to unlock the complete Certified Marketing Cloud Consultant Mock Test Free set and get access to hundreds of additional practice questions covering all key topics.
We regularly update our question sets to stay aligned with the latest exam objectives—so check back often for fresh content!
Start practicing with our Certified Marketing Cloud Consultant mock test free today—and take a major step toward exam success!