Salesforce Certified Marketing Cloud Consultant — Question 52

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?

Answer options

• 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.

Correct answer: C

Explanation

Option C is correct because it starts at 2:00 a.m., allowing time for the Customer data to be updated before processing the New Accounts data. The other options either start too early, missing the necessary data updates, or do not follow the correct sequence of activities required for the workflow.