Home / Salesforce / Certified Marketing Cloud Consultant

Salesforce Certified Marketing Cloud Consultant Practice Test - Questions Answers, Page 11

Question list

List of questions

Question 101

(0)

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 impl

Question 102

(0)

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 extensio

Question 103

(0)

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 mark

Question 104

(0)

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

Question 105

(0)

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 me

Question 106

(0)

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 restaur

Question 107

(0)

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

Question 108

(0)

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 ca

Question 109

(0)

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

Question 110

(0)

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 include

Related questions

Northern Trail Outfitters wants to include the body of marketing email replies captured by Reply Mail Management (RMM) within auto-forwarded messages to their Customer Success team. How could they accomplish this?

A customer manages their field technicians in Salesforce CRM connected to Marketing Cloud. Once an appointment with a contact is scheduled for the technician through CRM, the notification message should be sent to the contact informing them about the scheduled visit date. When the notification is sent the "Confirmation sent" checkbox on the appointment record should be updated in CRM. All appointments scheduled on a given day will have their status updated in CRM at the end of business hours. The Appointment object does not have a direct relationship with the contact. What solution would a consultant recommend to address this use case?

Northern Trail Outfitters has configured Reply Mall 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'

Northern Trail Outfitters is using a triggered send to send customers their order confirmations. Their commerce platform provides a JSON payload for order details. What would they use to format the JSON within the email?

Northern Trail Outfitters (NTO) account will be used for email communications with its clients and employees. They want to send from two different subdomains, so they have delegated e.nto.com as their SAP domain and mail.nto.com as an additional Private Domain. Which statement describes how this will impact the account?

What are two possible outcomes when "Multipart MIME" is selected during the send process? Choose 2 answers

A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits. What should the consultant suggest to minimise the impact of Marketing Cloud Connect on daily API limits? Choose 2

Northern Trail Outfitters wants to target Contacts in an abandoned cart Journey with a Facebook ad. An Ad Campaign Activity has been added to the Journey canvas. Which extension product should be enabled to use the Ad Campaign Activity?

A customer wants to create a mobile app that requires users to log in or register before accessing their dat a. Their source of truth Is Sales Cloud which Is connected to Marketing Cloud. Users who log In with existing credentials will have their device associated with their ContactKey. Users who register with the mobile app will not have their devices associated with a ContactKey for up to 24 hours. What consideration should a consultant provide to the customer?

Northern Trail Outfitters noticed that clicks are NOT showing up on Contact records in Salesforce. Which two reasons could be the cause? Choose 2 answers

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?

A global unsubscribe

An auto-exclusion list

An auto-suppression list

An exclusion list

Show Answer Comment (0)

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?

Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Show Answer Comment (0)

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

Assign Administration User permissions to the Channel Manager role.

Assign Channel Managers the role of Marketing Cloud Analyst.

Assign Administration User permissions to each business unit.

Assign Administration User permissions to individual users.

Show Answer Comment (0)

Question 104

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

Send Log data extensions are archived automatically based on retention settings.

AMPscript can be used to pull data from Send Logs for use within emails.

A business unit can support up to three Send Logs.

SQL Query Activities can reference Send Logs in combination with system data views.

Show Answer Comment (0)

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?

Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity

Report activity that generates Recent Send Summary report > Report delivered directly to SFTP

SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity

Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity

Show Answer Comment (0)

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

CloudPage with Web Collect to add entrants in to a data extension

Send Email Activity with a link to a subscription center

CloudPage with Smart Capture to add entrants in to a data extension

Data extension with double opt-in status defined

Show Answer Comment (0)

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?

Personalization Strings

Substitution Strings

Dynamic Content Areas

Guide Template Language

Show Answer Comment (0)

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?

Overwrite

Add Only

Add/Update

Update Only

Show Answer Comment (0)

Question 109

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

Reconcile contact data on multiple Contact IDs

Add a single record to a data extension

Export data from a data extension to any SFTP location

Clear the data from a data extension

Show Answer Comment (0)

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?

Number

Text (15)

Decimal (15,0)

Decimal (15,2)

Show Answer Comment (0)

Total 306 questions

9 10 11 12 13

Go to page: of 31