Salesforce Certified Marketing Cloud Email Specialist — Question 3

Northern Trail Outfitters is using a Smart Capture form in CloudPages to capture contest registrations in a data extension. Corporate has requested a nightly file with all registrants in this data extension be sent daily from Marketing Cloud to an external SFTP.
Which automation configuration should be used?

Answer options

• A. Schedule Starting Source > SQL Query Activity > File Transfer Activity
• B. File Drop Starting Source > SQL Query Activity > File Transfer Activity
• C. Schedule Starting Source > Data Extract Activity > File Transfer Activity
• D. File Drop Starting Source > Data Extract Activity > File Transfer Activity

Correct answer: C

Explanation

The correct answer is C because a Schedule Starting Source with a Data Extract Activity is appropriate for extracting data from a data extension and sending it to an external location on a routine basis. Options A and B utilize SQL Query Activity, which is not needed for this straightforward extraction, while option D uses a File Drop, which is unsuitable for a scheduled task.