Salesforce Marketing Cloud Email Specialist · Free Practice Question Hard
Question 2
A marketing team is using a Smart Capture form on a CloudPage landing page to capture registrations to it's opening event within a data extension. The marketing manager has requested that a nightly file with all registrants in this data extension be sent daily from Marketing Cloud to an external SSH File Transfer Protocol. Which automation configuration sequence should be used to accomplish this task?
- A Schedule Starting Source > SQL Query Activity > File Transfer Activity
- B File Drop Starting Source > SQL Query Activity > File Transfer Activity
- C File Drop Starting Source > Data Extract Activity > File Transfer Activity
- D Schedule Starting Source > Data Extract Activity > File Transfer Activity
Reveal correct answer
Correct answer: D
Explanation
The correct answer is Schedule Starting Source > Data Extract Activity > File Transfer Activity. The reason for this is that the Smart Capture form on the CloudPage landing page is capturing registrations into a data extension. In order to retrieve the data from the data extension and transfer it to an external SSH File Transfer Protocol, the following steps need to be taken: Schedule Starting Source: This allows the automation to run on a specific schedule, in this case, nightly. This ensures that the automation will run every day and retrieve the updated registrant data from the data extension. Data Extract Activity: This activity is used to extract data from the data extension. In this case, it would extract all the registrant data from the data extension. File Transfer Activity: This activity is used to transfer the extracted data to an external SSH File Transfer Protocol. It ensures that the file containing the registrant data is sent to the specified destination every night. The other answer options are incorrect because they either use the File Drop Starting Source, which is not necessary in this scenario as the data is being captured in a data extension, or they use the SQL Query Activity instead of the Data Extract Activity, which is used to extract data directly from a SQL query, not from a data extension.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
