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?

AScheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

BScheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

CFile Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

DFile Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Show Suggested 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:

Submit Cancel

Rikki

4 months ago

I'm surprised there's no mention of error handling in these options!

upvoted 0 times

...

Roselle

4 months ago

Wait, can we really rely on the file drop automation for alerts?

upvoted 0 times

...

Honey

4 months ago

I agree with Dorinda, C covers all the requirements.

upvoted 0 times

...

Marci

4 months ago

I think B is better, it skips the file transfer step.

upvoted 0 times

...

Dorinda

4 months ago

Option C seems right since it's a file drop automation.

upvoted 0 times

...

Jacklyn

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...