Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Exam - Topic 8 Question 13 Discussion

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions.Which workflow should meet these requirements?
B) Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
A) Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
C) File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
D) File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Exam - Topic 8 Question 13 Discussion

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) exam
Question #: 13
Topic #: 8
[All Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Questions]

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions.

Which workflow should meet these requirements?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Bobbye at May 08, 2022, 10:46 AM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rikki
9 months ago
I'm surprised there's no mention of error handling in these options!
upvoted 0 times
...
Roselle
9 months ago
Wait, can we really rely on the file drop automation for alerts?
upvoted 0 times
...
Honey
9 months ago
I agree with Dorinda, C covers all the requirements.
upvoted 0 times
...
Marci
9 months ago
I think B is better, it skips the file transfer step.
upvoted 0 times
...
Dorinda
9 months ago
Option C seems right since it's a file drop automation.
upvoted 0 times
...
Jacklyn
9 months ago
I’m leaning towards option A because it includes a scheduled automation, which seems necessary for the alert, but I’m not entirely confident about the workflow order.
upvoted 0 times
...
Harrison
9 months ago
I practiced a similar question where we had to separate data into different extensions, and I feel like option B might be the right choice since it skips the file transfer step.
upvoted 0 times
...
Sheridan
9 months ago
I think option C sounds familiar since it directly relates to file drops, but I’m a bit confused about whether we need the alert feature included.
upvoted 0 times
...
Roxane
10 months ago
I remember we discussed the importance of using a File Drop Automation for scenarios like this, but I'm not sure if we need the File Transfer Activity in this case.
upvoted 0 times
...
Armanda
10 months ago
Hmm, I'm not entirely confident about this, but I'll give it my best shot. I'll eliminate the options that don't seem relevant and then choose the two that make the most sense.
upvoted 0 times
...
Justine
10 months ago
Hmm, I'm not totally sure about this. I'll have to review my notes on sales strategies to figure out the right approach.
upvoted 0 times
...
Paris
10 months ago
This seems like a straightforward question about the effects of smoking on vitamin levels. I'm pretty confident I can figure this out.
upvoted 0 times
...

Save Cancel