Salesforce Certified Marketing Cloud Consultant Practice Test - Questions Answers, Page 4
List of questions
Question 31

What are data extension data retention policies?
Question 32

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

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?
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?
Explanation:
Since Record count in more than 500 K so DE is used. New and Update is already specified in question.
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?
Question 36

What is a correct statement about a database of record? Choose 2 answers
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?
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?
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?
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?
Question