Home / Salesforce / Certified Marketing Cloud Consultant

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

Question list

List of questions

Question 31

(0)

What are data extension data retention policies?

Question 32

(0)

A customer would like to store financial data related to invoicing in its data extensions. Which field type should be used?

Question 33

(0)

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to incl

Question 34

(0)

A customer provides a file containing only new and updated subscriber records exported from its marketing database. * The file will be uploaded to the customer's Enhanced FTP automatically at 3AM d

Question 35

(0)

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity. The l

Question 36

(0)

What is a correct statement about a database of record? Choose 2 answers

Question 37

(0)

A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and othe

Question 38

(0)

A company collects subscriptions on its website. It does the following: * Compiles that subscription list in a database in the website Content Management System (CMS). * Posts this encrypted list

Question 39

(0)

A customer needs to import data from an SFTP site. The customer wants to: * Segment the contents of the file and then send emails. * Transfer the file to the SFTP site at various times daily. * S

Question 40

(0)

A customer is collecting data from a Smart Capture form that stores submissions in a data extension. The customer wants an email sent to the marketing manager each morning that contains the previou

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 wants to have a periodic, dynamic newsletter send to a set data extension, but the data in this data extension will be regularly updated and the subscribers inside could be removed/added multiple times. What option should speed up the delivery while meeting these criteria?

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?

Question 31

What are data extension data retention policies?

Settings to "soft" delete all data in a Data Extension so there is no data loss.

Settings to control when a data extension creates a back-up of the data it contains.

Settings to define when a data extension or the data within the data extension is deleted.

Settings to prevent users from deleting a Data Extension created by another user.

Show Answer Comment (0)

Question 32

A customer would like to store financial data related to invoicing in its data extensions.

Which field type should be used?

Currency

Decimal

Number

Float

Show Answer Comment (0)

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

* CustomerlD

* FirstName

* EmailAddress

* OrderlD

* OrderDate

* ShippedDate

Which SQL statement should the consultant use?

SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD

SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD

SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD

SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

Show Answer Comment (0)

Question 34

A customer provides a file containing only new and updated subscriber records exported from its marketing database.

* The file will be uploaded to the customer's Enhanced FTP automatically at 3AM daily.

* The customer requires that the import completes prior to 4AM.

* On average, the file will contain about 2 million rows of data each day.

Based on the customer's requirements and recommended best practices, how should the daily file be imported?

Import the file to a data extension, using the 'add and update' method.

Import the file to a list, using the 'update only' method.

Import the file to a list, using the 'add and update' method.

Import the file to a data extension, using the 'overwrite' method.

Show Answer Comment (0)

Question 35

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity.

The list is:

* Compiled in a database in the website Content Management System (CMS).

* Imported into Marketing Cloud nightly at 11 p.m.

What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

Engagement metrics will be passed into Marketing Cloud.

They will need to integrate with the Marketing Cloud SOAP API.

Unsubscribes should be synchronized between senders.

The third-party send list should be pulled from the CMS

Show Answer Comment (0)

Question 36

What is a correct statement about a database of record? Choose 2 answers

A database of record is a centralized storage repository of data about objects or people.

A database of record is any database containing subscriber data.

A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber.

A database of record is a system in which a subscriber's status is maintained

Show Answer Comment (0)

Question 37

A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings * Data for the campaign will be in two data extensions: Customer and New Accounts * The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.

* The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.

Which automated workflow meets the customer's requirements?

A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A scheduled automation that starts at 12:00 a.m. and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activity, and Send Email Activity.

Show Answer Comment (0)

Question 38

A company collects subscriptions on its website. It does the following:

* Compiles that subscription list in a database in the website Content Management System (CMS).

* Posts this encrypted list to Marketing Cloud nightly at 11 p.m.

* Uses Marketing Cloud as the database of record.

* Sends up to five emails a week based on subscriber engagement with prior sends.

Which automation sequence (excluding waits) should cover these requirements?

File Transfer, Data Extract, Filters, Sends

File Transfer, Query, Measures, Sends

File Transfer, Import, Measures, Sends

File Transfer, Import, Query, Sends

Show Answer Comment (0)

Question 39

A customer needs to import data from an SFTP site. The customer wants to:

* Segment the contents of the file and then send emails.

* Transfer the file to the SFTP site at various times daily.

* Send to data extensions.

Which workflow should meet these requirements?

Triggered Automation: Import File > SQL Query(s) > Send Email(s)

Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)

Scheduled Automation: Import File > SQL Query(s) > Send Email(s)

Triggered Automation: Import File > Group Refresh > Send Email(s)

Show Answer Comment (0)

Question 40

A customer is collecting data from a Smart Capture form that stores submissions in a data extension.

The customer wants an email sent to the marketing manager each morning that contains the previous day's submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.

Which automation workflow will accomplish this?

Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email

Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email

Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email

Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email

Show Answer Comment (0)

Total 306 questions