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

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

Which field type should be used?

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?

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?

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?

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

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 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?

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?

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?