Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Marketing Cloud Email Specialist All Questions

View all questions & answers for the Certified Marketing Cloud Email Specialist exam

Exam Certified Marketing Cloud Email Specialist topic 1 question 71 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Email Specialist
Question #: 71
Topic #: 1
[All Certified Marketing Cloud Email Specialist Questions]

The marketing team at a bank needs to receive a file of all subscribers who were sent payment reminder emails and opened them each week. The file needs to be encrypted and placed on the bank's external SFTP.
How should the scheduled automation be configured to achieve this?

  • A. Filter Activity > File Transfer Activity > Data Extract Activity
  • B. Filter Activity > SQL Query Activity > File Transfer Activity
  • C. SQL Query Activity > Data Extract Activity > File Transfer Activity
  • D. Data Extract Activity > SQL Query Activity > File Transfer Activity
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
srikanthreddyw
8 months ago
C. SQL Query Activity > Data Extract Activity > File Transfer Activity step 1) SQL Query Activity would be used to create a query to select the relevant subscribers. step 2)The resulting data is then extracted using a Data Extract Activity. step 3) the extracted file is transferred to the bank's external SFTP using a File Transfer Activity.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...