Free Certified Marketing Cloud Consultant Sample Questions — Certified Marketing Cloud Consultant

Free Certified Marketing Cloud Consultant sample questions for the Certified Marketing Cloud Consultant exam. No account required: study at your own pace.

Want an interactive quiz? Take the full Certified Marketing Cloud Consultant practice test

Looking for more? Click here to get the full PDF with 95+ practice questions for $5 for offline study and deeper preparation.

Question 1

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
Show Answer
Correct Answer:
B. Data Manager
Question 2

A school corporation uses one contact per parent/child combination, updating the email address based on who they are sending to. However, they would like to pull data on which email addresses receive which emails. What functionality could be used to accomplish this?

  • A. Data Views
  • B. Tracking Extract
  • C. Send Log
  • D. Recent Email Send Report
Show Answer
Correct Answer:
C. Send Log
Question 3

When more than one subscriber email address field is created within Contact Builder, what action tells the platform which email address to prioritize in the Email application?

  • A. Create a new Import to populate subscriber email addresses into All Subscribers
  • B. Add all email address fields into the Mobile Application and Predictive Intelligence Applications
  • C. Create a new Attribute Group referencing all email address fields in Data Designer
  • D. Add all email address fields into the Contact Configuration screen in the correct order
Show Answer
Correct Answer:
A. Create a new Import to populate subscriber email addresses into All Subscribers
Question 4

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
Show Answer
Correct Answer:
  • A. Marketing Cloud Channel Manager
  • D. Marketing Cloud Regional or Local Administrator
Question 5

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
Show Answer
Correct Answer:
B. Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
Question 6

A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. Click activity will be cross-referenced with subscribers' regional markets on a master subscriber data extension. What skill set should the customer team have for this solution to be viable?

  • A. HTML
  • B. SSJS
  • C. AMPscript
  • D. SQL
Show Answer
Correct Answer:
D. SQL
Question 7

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)
Show Answer
Correct Answer:
D. Decimal (15,0)
Question 8

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
Show Answer
Correct Answer:
  • A. Script Activity
  • D. Query Activity
Question 9

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
Show Answer
Correct Answer:
C. Create a Salesforce Data Extension for the user to select during a Send Flow
Question 10

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: ✑ Imported into a staging data extension. ✑ Separated into two different data extensions. Which workflow should meet these requirements?

  • A. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  • B. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  • C. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  • D. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Show Answer
Correct Answer:
B. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

Aced these? Get the Full Exam

Download the complete Certified Marketing Cloud Consultant study bundle with 95+ questions in a single printable PDF.