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?
Select an option, then click Submit answer.
Reference / correct answer:
Schedule Starting Source > Data Extract Activity > File Transfer Activity
Most accepted answer: C. Schedule Starting Source > Data Extract Activity > File Transfer Activity
Community votes: A=1, C=4
Should be C upvoted 14 times
To meet the corporate’s requirement of sending a nightly file with all contest registrants from Marketing Cloud to an external SFTP, the most suitable automation configuration is Option C: upvoted 1 times
Selected Answer: C i vote for C.... upvoted 1 times
Selected Answer: C Answers B & D are totally wrong. Between A&C it cant be A because we need to generate an outcome file. If you run SQL activity, it will just put all records to the target DE. So the answer is C upvoted 2 times
Selected Answer: C Option C (Schedule Starting Source Data Extract Activity File Transfer Activity) aligns with the steps needed to schedule the automation and perform the data extract and file transfer. This configuration ensures that the nightly file with all contest registrants is sent daily to the external SFTP, meeting the corporate's requirements. Option A (Schedule Starting Source SQL Query Activity File Transfer Activity) and Option D (File Drop Starting Source Data Extract Activity File Transfer Activity) involve unnecessary components for the specified task. Option B (File Drop Starting Source SQL Query Activity File Transfer Activity) is not the ideal configuration for achieving the nightly file transfer requirement. upvoted 1 times