Certified Marketing Cloud Consultant Practice Test Free – 50 Real Exam Questions to Boost Your Confidence
Preparing for the Certified Marketing Cloud Consultant exam? Start with our Certified Marketing Cloud Consultant Practice Test Free – a set of 50 high-quality, exam-style questions crafted to help you assess your knowledge and improve your chances of passing on the first try.
Taking a Certified Marketing Cloud Consultant practice test free is one of the smartest ways to:
- Get familiar with the real exam format and question types
- Evaluate your strengths and spot knowledge gaps
- Gain the confidence you need to succeed on exam day
Below, you will find 50 free Certified Marketing Cloud Consultant practice questions to help you prepare for the exam. These questions are designed to reflect the real exam structure and difficulty level. You can click on each Question to explore the details.
After implementing Marketing Cloud Connect, the customer notices tracking details from Email Studio initiated sends are not being sent back to Sales Cloud. Which configuration in Marketing Cloud should the customer verify?
A. Report is saved in Standard Salesforce folder.
B. Email Address column is included in the report used for sending.
C. Required profile attributes are properly mapped.
D. Sendable data extension is saved in the Salesforce Data Extensions folder.
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 wants to send an email to website visitors who add items to their cart but fail to make a purchase. The email will include a list of products they added to their shopping cart. ✑ A sendable data extension contains the contact information and a session ID field for each subscriber who has abandoned their cart. ✑ A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL. Which feature should be used to display the list of products for each subscriber in this email?
A. Enhanced Dynamic Content Block
B. Lookup AMPscript function
C. LookupRows AMPscript function
D. Dynamic Content Block
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”?
A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account's Enhanced SFTP on a monthly basis on the 15th day of each month, expecting the email to be deployed upon completion of the import activity. However, if the 15th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15th and expect the promotional email to be sent on that Friday. Which method should be used to automate their monthly promotional email?
A. Create a scheduled daily automation which includes an Import File Activity and Send Email Activity.
B. Create a file drop automation which includes an Import File Activity and Send Email Activity.
C. Create a scheduled monthly automation which includes an Import File Activity and triggered send.
D. Create a file drop automation which includes an Import File Activity and triggered send.
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 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.
Northern Trail Outfitters has acquired a new company and is importing customer data to Marketing Cloud. They want to ensure commercial emails are not sent to email addresses who have previously opted-out. Which feature should they use?
A. Exclusion Script
B. Auto-suppression List
C. Suppression List
D. Exclusion List
Northern Trail Outfitters' marketing team is made up of a marketing manager, a communications specialist, and a graphic designer. The team is new to Marketing Cloud and has very little coding experience. Currently, they use Excel and VLOOKUP to segment their email audiences and import them into Marketing Cloud. What solution should be recommended to allow for long-term self-sufficiency in segmentation?
A. Attribute Groups
B. Publication Lists
C. Query Activities
D. Data Filters
A customer has an email newsletter to send out, but wants to deliver it with a targeted message for customers within a specified age range. These data have been defined in attributes from a sign-up landing page. How should the customer individualize the email content?
A. Guide Template Language
B. Substitution Strings
C. Dynamic Content Areas
D. Personalization Strings
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.
Northern Trail Outfitters (NTO) experienced a 24-hour website outage beginning on a peak shopping day, as a result, a number of logged-in customer's shopping sessions were disrupted. When the site is back online, the retailer would like to encourage those shoppers to return the site and continue their shopping. What action should Northern Trail Outfitters (NTO) take?
A. Create and send an apology email which includes a discount for a future purchase to all customers.
B. Do NOT send an email, as outage may have increased negative sentiment, resulting in unsubscribes.
C. Import a file of logged-in customers into NTO’s existing Abandoned Cart journey in Journey Builder.
D. Create a user-initiated message to logged-in customers to send once the website is restored .
Northern Trail Outfitters is using Journey Builder to send emails to loyalty members based on recent activity. They anticipate that approximately half of their contacts will meet the entry criteria for their journey. How should they configure their entry source?
A. Use an Import Activity in Automation studio to filter the data as a Data Extension Entry Source.
B. Use a Contact Data Entry Source to segment the data configured in Attribute Groups in Contact Builder.
C. Use a Data Extension Entry Source with an applied filter based on recent member activity.
D. Use a Query Activity in Automation Studio to create a segment before entering the journey.
Northern Trail Outfitters wants to have a periodic, dynamic newsletter send to a set data extension, but the data in this data extension will be regularly updated and the subscribers inside could be removed/added multiple times. What option should speed up the delivery while meeting these criteria?
A. Scheduled Automation utilizing Triggered Send Emails
B. Journey that allows re-entry after exiting
C. Scheduled Automation using a Send Activity
D. Single Send Journey
ABC Company wants to automate the sending of shipping notices and a customer survey. - Shipping notices will be sent once a day. - The shipping file will be placed on the FTP some time after 4:00 p.m. - The shipping data will be sorted in the Shipping Notice data extension. - A field in the data extension will contain the shipping date. - The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer's order ships. Which workflow would most effectively enable ABC Company to do this? A.B.
C.
D.
An entertainment company is hosting events across the country in different venues. They want to use Contact Builder to feed Journey Builder. Contact who enter a journey will go through a decision split based on the type of event. The journey will send a series of emails and one of them will contain the venue details dynamically populated with AMP script. The Company collects the following information: - Customer data (email address, first name, last name...). - Event registration (email address, event ID, event name, event type, venue ID...). - Venue details (venue ID, venue name, venue address...). - Payment details (email address, event ID, total paid...). The Company does not want to link everything in Contact Builder. Which are the two data sources that must be incorporated inside Contact Builder? (Choose two.)
A. Event Registration
B. Customer Data
C. Venue Details
D. Payment Details
A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits. What should the consultant suggest to minimize the impact of Marketing Cloud Connect on daily API limits?
A. Filter target audiences based on mapped profile attributes to reduce Bulk API calls.
B. Use Data Stream to sync object data into a Data Extension in the Marketing Cloud.
C. Share Sales Cloud user licenses across Marketing Cloud users.
D. Upgrade the Marketing Cloud Account to ConnectedApp Authentication.
Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer. How should they accomplish this task?
A. Create and populate profile attributes for each of the 10 data extension fields and schedule a send with high priority.
B. Create and send to a sendable data extension containing those needed fields using a query activity.
C. Enable Send Throttling on high to ensure the speed is increased to process the email as fast as possible.
D. Use the LookUp AMPscript function in the email to pull the fields from the data extensions for each subscriber.
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
A customer wants to create a loyalty program by identifying all subscribers who clicked on a link within any email sent within the last six months. What should be recommended?
A. Create and execute a Data Filter on the _Click data view.
B. Create and execute a Subscriber Engagement report.
C. Create and execute a SQL Query against the _Click data view.
D. Create and execute a Tracking Extract.
A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails. What should a consultant recommend?
A. Create an auto-suppression list populated with the known email addresses.
B. Create an exclusion list with the known email addresses.
C. Populate a list using a query to exclude the subscriber key.
D. Create an auto-suppression list populated with subscriber keys.
A company is leveraging Marketing Cloud Connect to trigger near real-time communication in Journey Builder via Salesforce Entry Events. They would like to set up another business unit specifically for their new European subsidiary and also leverage Salesforce Entry Events. They want to continue to use one Sales Cloud instance for all regions, but the head of the European marketing team wants to guarantee European customers are never visible to the users of the existing business unit for data privacy reasons, just as they are in Sales Cloud. The integration user in Sales Cloud has the profile `System Administrator`. What action should the consultant take to accomplish this?
A. Enable the Scope By User setting in Salesforce Integration tab
B. Implement a custom integration to support this requirement
C. Once users are integrated Salesforce Entry Events automatically filter contacts based on Sales Cloud permissions
D. Ensure each business unit has a different Integration User with the relevant roles in Sales Cloud
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 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)
A company collects subscriptions on its website. It does the following: ✑ Compiles that subscription list in a database in the website Content Management System (CMS). ✑ Posts this encrypted list to Marketing Cloud nightly at 11 p.m. Uses Marketing Cloud as the database of record.✑ Sends up to five emails a week based on subscriber engagement with prior sends. Which automation sequence (excluding waits) should cover these requirements?
A. File Transfer > Import File > Measures > Send Email
B. File Transfer > SQL Query > Measures > Send Email
C. File Transfer > Data Extract > Filters > Send Email
D. File Transfer > Import File > SQL Query > Send Email
A user in Marketing Cloud needs to send an email to a Salesforce Report via a Send Flow process. How should the consultant meet this requirement?
A. Assign the integrated user the Marketing Cloud for AppExchange User permission in Sales Cloud.
B. Create data validation rules for the integrated user in Sales Cloud.
C. Create a Salesforce Data Extension for the user to select during a Send Flow.
D. Add custom VisualForce Page to the page layouts in Marketing Cloud.
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 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
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
Northern Trail Outfitters' marketing team is new to Marketing Cloud and has very little coding experience. They have employed a consultant to help them design an automated solution for maintaining an auto-suppression list. Which solution should the consultant recommend?
A. Use a query activity to populate the auto-suppression
B. Use Einstein Segment Recommendations
C. Use an import activity to import a file from the SFTP
D. Use the Import Wizard in Automation Studio
Northern Trail Outfitters wants to create a query to populate a data extension with email subscribers who belong to a specific Publication List. Which Data View could they use to achieve this?
A. _Subscribers
B. _PublicationSubscriber
C. _EnterpriseAttribute
D. _ListSubscribers
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.
A financial company wants to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following: ✑ Payments.csv will arrive on the Enhanced SFTP each Monday at 1 a.m. ✑ Payments.csv will be encrypted. ✑ Payments.csv will contain data from the previous week. ✑ Late payment notices will be sent each Monday at noon. ✑ They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send. Which automation sequence represents a viable solution?
A. File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
B. Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
C. File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfer
D. File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer
During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria: ✑ Customer data will be fully refreshed every night via Import File Activity from the customer's data warehouse. ✑ Contact records will be augmented by relational data tables via Contact Builder. ✑ Customer ID will be used as the unique identifier for each contact. Which statement differentiates the use of data extensions over lists?
A. Data extensions are necessary for Contact Builder.
B. Data extensions allow for add/update Import File Activity.
C. Data extensions can store HTML code as an attribute.
D. Data extensions support Customer ID to be used as Subscriber Key.
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
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
Northern Trail Outfitters noticed that clicks are NOT showing up on Contact records in Salesforce. Which two reasons could be the cause? (Choose two.)
A. Individual Level Tracking was not selected in Marketing Cloud Configuration
B. Email Address was used as Subscriber Key
C. Synchronized Data Sources only push data every 15 minutes
D. ContactID was used as Subscriber Key
Customer Event gathers data through a tablet-based webform as part of a raffle into a data extension. Winner is randomly selected. After the event, an email should be sent to the participants to gather opt ins for marketing emails. Define two things necessary. (Choose two.)
A. Data extension with opt in status
B. SmartCapture
C. WebCollect
D. Send email activity which contains a link to subscription center
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
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.
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 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
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 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
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
ABC Company needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks: ✑ Maintain ABC Company's master suppression list. ✑ Configure data relationships. ✑ Create new subscriber attributes. Which role should be assigned to the IT staff member?
A. Administrator
B. Data Manager
C. Analyst
D. Content Creator
ABC Company is setting up new hires on its instance of Marketing Cloud, which includes Email Studio, Mobile Connect, and Social Studio. One of the hires needs to manage the operations of all of the North American Business Units. What two roles, custom or standard, could be assigned to this user to meet the requirement? (Choose two.)
A. Marketing Cloud Channel Manager
B. Marketing Cloud Administrator
C. Marketing Cloud Email Marketing Manager
D. Marketing Cloud Regional or Local Administrator
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
A consultant wants to trigger an email whenever the Status field on the Lead Object changes to Hot. Tracking data will need to be kept in the Sales Cloud. Which three steps should the consultant use in the solution? (Choose three.)
A. Put a SOAP API in place via the Marketing Cloud API.
B. Write an Apex Trigger on the Lead Object.
C. Create the Triggered Send Definition in the Marketing Cloud.
D. Create the Triggered Send Definition in the Sales Cloud.
E. Enable Triggered Sends on the Lead Object in configuration.
Free Access Full Certified Marketing Cloud Consultant Practice Test Free Questions
If you’re looking for more Certified Marketing Cloud Consultant practice test free questions, click here to access the full Certified Marketing Cloud Consultant practice test.
We regularly update this page with new practice questions, so be sure to check back frequently.
Good luck with your Certified Marketing Cloud Consultant certification journey!