Free Certified Marketing Cloud Consultant Exam Braindumps
Salesforce Certified Marketing Cloud Consultant Questions 101–105 (page: 22)

Updated On: 10-Feb-2026

During discovery a consultant confirmed:

*A master audience file containing contact information and data points will be used for segmentation and imported nightly.
*The customer would like to implement a mechanism that consistently prevents sending promotional emails to subscribers who work for their top three competitors.

What feature should a consultant include in the solution?

  1. A global unsubscribe
  2. An auto-exclusion list
  3. An auto-suppression list
  4. An exclusion list

Answer(s): C



A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:

*Imported iota a staging data extension.
*Separated into two different data extensions.

Which automation should meet these requirements?

  1. Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  2. File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  3. Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  4. File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Answer(s): B



Northern Trail Outfitters is expanding its marketing efforts globally. Each country’s marketing department has its own business unit and is responsible for the creation and execution of all the marketing campaigns. The Marketing Cloud Administrator is having trouble keeping up with the consultant influx of new users and would like to speed up the turnaround of granting new users access to Marketing Cloud.
In which two ways could this be accomplished? Choose 2 answers

  1. Assign Administration User permissions to the Channel Manager role.
  2. Assign Channel Managers the role of Marketing Cloud Analyst.
  3. Assign Administration User permissions to each business unit.
  4. Assign Administration User permissions to individual users.

Answer(s): A,C



Which two statements are correct about Send Logging? Choose 2 answers

  1. Send Log data extensions are archived automatically based on retention settings.
  2. AMPscript can be used to pull data from Send Logs for use within emails.
  3. A business unit can support up to three Send Logs.
  4. SQL Query Activities can reference Send Logs in combination with system data views.

Answer(s): B,D

Explanation:

Send Log data extensions are never archived. Its deleted. A business unit can support only one Send Log.



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?

  1. Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity
  2. Report activity that generates Recent Send Summary report > Report delivered directly to SFTP
  3. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity
  4. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity

Answer(s): C



Viewing page 22 of 60
Viewing questions 106 - 110 out of 293 questions


Post your Comments and Discuss Salesforce Certified Marketing Cloud Consultant exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!