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 31 discussion

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

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?

  • 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
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
Shwet1111
Highly Voted 1 year, 11 months ago
Should be C
upvoted 14 times
...
srikanthreddyw
Most Recent 8 months ago
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
...
hyperhp
1 year, 1 month ago
Selected Answer: C
i vote for C....
upvoted 1 times
...
AccosecAndrew
1 year, 1 month ago
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 1 times
...
AleAleAleAle
1 year, 3 months ago
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
...
Vishwas4
1 year, 5 months ago
should be C
upvoted 2 times
...
Oleg_M
1 year, 7 months ago
Selected Answer: C
It can't 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 4 times
...
dsadca
1 year, 9 months ago
The questions in the exam have 3 answers not 4 so none of these come up
upvoted 1 times
...
SFDevGroup
2 years ago
Selected Answer: A
This should be A
upvoted 3 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 ...