ExamGecko
Ask Question

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

List of questions

Question 101

Report
Export
Collapse

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
A global unsubscribe
An auto-exclusion list
An auto-exclusion list
An auto-suppression list
An auto-suppression list
An exclusion list
An exclusion list
Suggested answer: C
asked 23/09/2024
Alex Pilallis
43 questions

Question 102

Report
Export
Collapse

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
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
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
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
File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Suggested answer: B
asked 23/09/2024
Abdelilah BAKIR
27 questions

Question 103

Report
Export
Collapse

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 Administration User permissions to the Channel Manager role.
Assign Channel Managers the role of Marketing Cloud Analyst.
Assign Channel Managers the role of Marketing Cloud Analyst.
Assign Administration User permissions to each business unit.
Assign Administration User permissions to each business unit.
Assign Administration User permissions to individual users.
Assign Administration User permissions to individual users.
Suggested answer: A, C
asked 23/09/2024
Francisco Jesús Cano Hinarejos
53 questions

Question 104

Report
Export
Collapse

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

Send Log data extensions are archived automatically based on retention settings.
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.
AMPscript can be used to pull data from Send Logs for use within emails.
A business unit can support up to three Send Logs.
A business unit can support up to three Send Logs.
SQL Query Activities can reference Send Logs in combination with system data views.
SQL Query Activities can reference Send Logs in combination with system data views.
Suggested answer: B, D

Explanation:

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

asked 23/09/2024
Balanavaneethan Nitharsan
29 questions

Question 105

Report
Export
Collapse

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
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
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
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
Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity
Suggested answer: C
asked 23/09/2024
Peter Dunčko
40 questions

Question 106

Report
Export
Collapse

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
CloudPage with Web Collect to add entrants in to a data extension
Send Email Activity with a link to a subscription center
Send Email Activity with a link to a subscription center
CloudPage with Smart Capture to add entrants in to a data extension
CloudPage with Smart Capture to add entrants in to a data extension
Data extension with double opt-in status defined
Data extension with double opt-in status defined
Suggested answer: C, D
asked 23/09/2024
Artur Sierszen
48 questions

Question 107

Report
Export
Collapse

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
Personalization Strings
Substitution Strings
Substitution Strings
Dynamic Content Areas
Dynamic Content Areas
Guide Template Language
Guide Template Language
Suggested answer: C
asked 23/09/2024
Ryan Harris
42 questions

Question 108

Report
Export
Collapse

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
Overwrite
Add Only
Add Only
Add/Update
Add/Update
Update Only
Update Only
Suggested answer: C
asked 23/09/2024
Danilo Paolucci
42 questions

Question 109

Report
Export
Collapse

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
Reconcile contact data on multiple Contact IDs
Add a single record to a data extension
Add a single record to a data extension
Export data from a data extension to any SFTP location
Export data from a data extension to any SFTP location
Clear the data from a data extension
Clear the data from a data extension
Suggested answer: A, C
asked 23/09/2024
Ariel Acosta
35 questions

Question 110

Report
Export
Collapse

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
Number
Text (15)
Text (15)
Decimal (15,0)
Decimal (15,0)
Decimal (15,2)
Decimal (15,2)
Suggested answer: C

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.

asked 23/09/2024
Patrick Evelinton de Souza Borges
33 questions
Total 306 questions
Go to page: of 31
Search

Related questions