ExamGecko
Login
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
Open VPLUS File
Convert VPLUS to PDF

Related questions

A retail company's database of record resides at a 3rd-party company that also keeps track of purchase history. That database only updates once a day where new records can be created and merged. The database uses an "Email ID," which is a numeric field that represents both the business unit and email address. The company now wants to be able to send real-time Welcome emails to people (newly registered website users) who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Email ID" in the database. What key issue should be addressed? Choose 3 answers
What are two possible outcomes when "Multipart MIME" is selected during the send process? Choose 2 answers
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?
Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file drops, they want to be able to have it immediately imported and then segmented to enter a specific journey depending on the data inside the file. Which two options would meet these requirements? Choose 2 answers
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?
What are data extension data retention policies?
What is a correct statement about Send Log data? Choose 3 answers
A financial services customer states that families often share email addresses across multiple checking, savings, loan, and credit accounts. The customer needs to allow individual accounts to use the same email address in Marketing Cloud but maintain separate subscriber attributes. Which component should be discussed with the customer to allow for this use case?
Northern Trail Outfitters (NTO) is the holding company of three subsidiaries: Universal Containers, Ursa Major Solar, and Cloud Kicks. NTO recently purchased Marketing Cloud and has asked its consultant to recommend a scalable business unit (BU) hierarchy. They don't plan on executing any marketing campaigns on behalf of the NTO holding company, but NTO employees would like access to all subscribers and aggregate reporting. Additionally, each subsidiary business will be regularly running campaigns and should have their own branding, content, and subscribers. Which solution should the consultant recommend?
Northern Trail Outfitters wants to monitor available coupon codes and sends a notification to their email specialist instructing them to request more codes for importing if the available coupon count falls below 500 available codes. Which two activities would be automation? Choose 2 answers