Salesforce Certified Marketing Cloud Consultant Practice Test - Questions Answers, Page 11
List of questions
Question 101

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?
Question 102

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?
Question 103

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
Question 104

Which two statements are correct about Send Logging? Choose 2 answers
Explanation:
Send Log data extensions are never archived. Its deleted. A business unit can support only one Send Log.
Question 105

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?
Question 106

A restaurant supply company captures email subscribers and leads through trade shows. This has always been a manual process with booth visitors leaving contact information in a fishbowl. The restaurant supply company is updating their process to an online sweepstakes entry that allows entrants to confirm opt-in for a monthly newsletter.
Which two components are appropriate for this solution? Choose 2 answers
Question 107

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?
Question 108

A consulting 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?
Question 109

In which two ways can Contact Builder be used to affect data stored on a data extension? Choose 2 answers
Question 110

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 zeros, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?
Explanation:
The order ID field is conducive because it places all of the items that the customers want under one order. You can imagine how problematic it would be if the rules would be set in different areas. It will be harder for the company to track the orders of each customer.
This may lead to people receiving items that they did not order or not getting any of the things that they have ordered at all. The order ID field will make everything more organized and correct. The fewer mistakes that the company makes in processing orders, the happier the customers will be with their shopping experience.
Question