Certified Marketing Cloud Consultant

Certified Marketing Cloud Consultant practice questions, page 9 of 11, with answer review and explanations.

Question 41

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.)

  1. Marketing Cloud Channel Manager
  2. Marketing Cloud Administrator
  3. Marketing Cloud Email Marketing Manager
  4. Marketing Cloud Regional or Local Administrator

Question 42

A Consultant has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed. Which import type should be used?

  1. Overwrite
  2. Update Only
  3. Add Only
  4. Add/Update

Question 43

ABC Company 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 constant influx of new users and would like to speed up the turnaround of granting new users access to the Marketing Cloud. In what two ways can this be accomplished? (Choose two.)

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

Question 44

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?

  1. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  2. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  3. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
  4. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Question 45

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?

  1. Filter target audiences based on mapped profile attributes to reduce Bulk API calls.
  2. Use Data Stream to sync object data into a Data Extension in the Marketing Cloud.
  3. Share Sales Cloud user licenses across Marketing Cloud users.
  4. Upgrade the Marketing Cloud Account to ConnectedApp Authentication.