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

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

Suggested Answer: B

Get Premium Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Rikki 12 months ago

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

Roselle 12 months ago

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

Honey 12 months ago

I agree with Dorinda, C covers all the requirements.

Marci 1 year ago

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

Dorinda 1 year ago

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

Jacklyn 1 year 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.

Harrison 1 year 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.

Sheridan 1 year 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.

Roxane 1 year 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.

Armanda 1 year 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.

Justine 1 year 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.

Paris 1 year ago

This seems like a straightforward question about the effects of smoking on vitamin levels. I'm pretty confident I can figure this out.

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