hiexam
salesforce · Certified-Marketing-Cloud-Consultant · Q602 · multiple_choice · topic_1

A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will b…

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 SFTP at 10:00 p.m. Which automated workflow meets the customers' requirements?
  • A.A scheduled automation which starts at 2:00 a.m. and executes Data Extract Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
  • B.A drop automation which executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
  • C.A scheduled automation which starts at 2:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.
  • D.A scheduled automation which starts at 12:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.
Explanation
Should start after 1:00 AM after data update. Since its encrypted so File transfer is required.

Reference: examtopics_answer_description

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.