Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Exam - Topic 1 Question 110 Discussion

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) exam

Question #: 110
Topic #: 1

[All Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Questions]

Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file drops, they want to be able to have it immediately imported and then segmented to enter a specific journey depending on the data inside the file.

Which two options would meet these requirements?

Choose 2 answers

AScheduled Automation

BFile Drop Automation

CSQL Query

DDecision Split

Show Suggested Answer

Suggested Answer: B, C

by Isabelle at Jul 04, 2025, 11:17 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Abraham

4 months ago

I’m surprised they don’t mention anything about error handling here!

upvoted 0 times

...

Carole

4 months ago

B is a must! It’s designed for file drops.

upvoted 0 times

...

Irene

4 months ago

I think A could work too, but not as efficiently.

upvoted 0 times

...

Mireya

5 months ago

Wait, can you really use Decision Split for this? Seems off.

upvoted 0 times

...

Maybelle

5 months ago

Definitely B and D! That makes the most sense.

upvoted 0 times

...

Rory

5 months ago

Decision Split seems more about branching paths in journeys, so I don't think that's what they're looking for in this case.

upvoted 0 times

...

Nicholle

5 months ago

I practiced a similar question where we had to automate file imports, and I feel like Scheduled Automation might not fit this scenario as well as File Drop Automation.

upvoted 0 times

...

Nakita

5 months ago

I'm not entirely sure, but I remember something about SQL Queries being used for data segmentation. Could that be relevant here?

upvoted 0 times

...

Sueann

6 months ago

I think File Drop Automation could be one of the answers since it directly relates to files being dropped into the SFTP account.

upvoted 0 times

...

Noelia

6 months ago

I'm a little confused on the difference between Scheduled Automation and File Drop Automation. I'll need to review those options more closely to decide which two would work best.

upvoted 0 times

...

Peggie

6 months ago

I'm confident that File Drop Automation and Scheduled Automation are the right choices here. The question is specifically asking for two options that meet the requirements, and those two seem to fit the bill.

upvoted 0 times

...

Virgie

6 months ago

Okay, let's see. The key is that they want to be able to immediately import and segment the file as soon as it drops. So I'm thinking File Drop Automation and Decision Split would be the way to go.

upvoted 0 times

...

Madelyn

6 months ago

Hmm, I'm a bit unsure about this one. I'll need to think through the details of how each option would work to handle the intermittent file drops and data segmentation.

upvoted 0 times

...

Anna

6 months ago

This one seems pretty straightforward. I'd go with File Drop Automation and Scheduled Automation to meet the requirements.

upvoted 0 times

...

Dominic

9 months ago

Wait, are we sure the file isn't being dropped in the SFTP account on purpose? Maybe it's a secret message from the company's CEO, and the real answer is to just read the file and see what it says. *laughs* Just kidding, but you've got to admit, that would be a pretty wild plot twist!

upvoted 0 times

Johnathon

7 months ago

A) Scheduled Automation

upvoted 0 times

...

Fernanda

9 months ago

I'm going with Option B and Option D. File Drop Automation is a no-brainer, but a Decision Split could also come in handy to route the file to the appropriate journey based on the data. This is a tricky one, but I think I've got it figured out.

upvoted 0 times

Felix

8 months ago

Option B for File Drop Automation is a must for immediate import. And Option D for Decision Split will definitely help in segmenting the file for specific journeys.

upvoted 0 times

...

Kenny

8 months ago

I think you made the right choice with Option B and Option D. File Drop Automation ensures quick import, and Decision Split helps with routing based on data.

upvoted 0 times

...

Francesco

9 months ago

I agree, Option B for File Drop Automation is essential to immediately import the file. And Option D for Decision Split will help route the file based on the data.

upvoted 0 times

...

Stacey

9 months ago

I see the rationale behind both options, Scheduled Automation and File Drop Automation would both be efficient solutions.

upvoted 0 times

...

Stanton

9 months ago

Hmm, this is a tough one. I'm leaning towards Option A and Option B. Scheduled Automation could work, but File Drop Automation seems more efficient. I'll have to think this through a bit more.

upvoted 0 times

Rozella

8 months ago

I think using both Option A and Option B would be the most effective solution.

upvoted 0 times

...

Gerald

9 months ago

I agree, Option B seems like the best choice for efficiency.

upvoted 0 times

...

Lashon

9 months ago

I believe B) File Drop Automation could also be a good option to meet the requirements.

upvoted 0 times

...

Richelle

9 months ago

I agree with Blossom, Scheduled Automation would ensure the file is imported immediately.

upvoted 0 times

...

Derick

9 months ago

I agree with Erick. File Drop Automation is the way to go. Scheduled Automation would be too slow, and SQL Query and Decision Split don't seem relevant to the problem at hand.

upvoted 0 times

...

Erick

9 months ago

Option B seems like the obvious choice here. A file drop automation should be able to trigger the import and segmentation process as soon as the file hits the SFTP account.

upvoted 0 times