ExamGecko
Ask Question

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

List of questions

Question 31

Report
Export
Collapse

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 "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 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 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.
Settings to prevent users from deleting a Data Extension created by another user.
Suggested answer: C
asked 23/09/2024
Luigi Trigilio
42 questions

Question 32

Report
Export
Collapse

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

Which field type should be used?

Currency
Currency
Decimal
Decimal
Number
Number
Float
Float
Suggested answer: B
asked 23/09/2024
Kevin Margan
45 questions

Question 33

Report
Export
Collapse

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 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 * 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 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
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
Suggested answer: D
asked 23/09/2024
Daniel Hernandez Villar
37 questions

Question 34

Report
Export
Collapse

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 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 'update only' method.
Import the file to a list, using the 'add and update' method.
Import the file to a list, using the 'add and update' method.
Import the file to a data extension, using the 'overwrite' method.
Import the file to a data extension, using the 'overwrite' method.
Suggested answer: A

Explanation:

Since Record count in more than 500 K so DE is used. New and Update is already specified in question.

asked 23/09/2024
Ankitkumar Pandya
34 questions

Question 35

Report
Export
Collapse

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.
Engagement metrics will be passed into Marketing Cloud.
They will need to integrate with the Marketing Cloud SOAP API.
They will need to integrate with the Marketing Cloud SOAP API.
Unsubscribes should be synchronized between senders.
Unsubscribes should be synchronized between senders.
The third-party send list should be pulled from the CMS
The third-party send list should be pulled from the CMS
Suggested answer: B
asked 23/09/2024
Judith Persons
43 questions

Question 36

Report
Export
Collapse

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 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 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 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
A database of record is a system in which a subscriber's status is maintained
Suggested answer: A, D
asked 23/09/2024
Christie Clark
40 questions

Question 37

Report
Export
Collapse

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 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 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 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.
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.
Suggested answer: C
asked 23/09/2024
DMITRY Yunov
33 questions

Question 38

Report
Export
Collapse

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, Data Extract, Filters, Sends
File Transfer, Query, Measures, Sends
File Transfer, Query, Measures, Sends
File Transfer, Import, Measures, Sends
File Transfer, Import, Measures, Sends
File Transfer, Import, Query, Sends
File Transfer, Import, Query, Sends
Suggested answer: D
asked 23/09/2024
Thomas Kincer
39 questions

Question 39

Report
Export
Collapse

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)
Triggered Automation: Import File > SQL Query(s) > Send Email(s)
Scheduled Automation: Transfer File > 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)
Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
Triggered Automation: Import File > Group Refresh > Send Email(s)
Triggered Automation: Import File > Group Refresh > Send Email(s)
Suggested answer: A
asked 23/09/2024
Bart Hakstege
38 questions

Question 40

Report
Export
Collapse

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
Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email
Scheduled 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
Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email
Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
Suggested answer: D
asked 23/09/2024
brandon millette
50 questions
Total 306 questions
Go to page: of 31
Search

Related questions