Free Certified Marketing Cloud Consultant Exam Braindumps (page: 10)

Page 10 of 74

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?

  1. 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.
  2. A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
  3. 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.
  4. 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.

Answer(s): C



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?

  1. File Transfer, Data Extract, Filters, Sends
  2. File Transfer, Query, Measures, Sends
  3. File Transfer, Import, Measures, Sends
  4. File Transfer, Import, Query, Sends

Answer(s): D



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?

  1. Triggered Automation: Import File > SQL Query(s) > Send Email(s)
  2. Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)
  3. Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
  4. Triggered Automation: Import File > Group Refresh > Send Email(s)

Answer(s): A



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?

  1. Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email
  2. Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email
  3. Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email
  4. Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email

Answer(s): D



Page 10 of 74



Post your Comments and Discuss Salesforce Certified Marketing Cloud Consultant exam with other Community members:

Shobena commented on June 19, 2024
Yesterday I gave this exam. Passed it on the first try. This prep material is very accurate and cover all topics.
INDIA
upvote