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 Consultant (MCE-Con-201) Exam - Topic 3 Question 111 Discussion

Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).* The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value.* A Customer Reference DE is updated daily and holds subscriber information.* The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items.* The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.* If the web analytics file is empty, NTO does not want the automation to finish running.Which order of activities should be used to fulfill this requirement?
B) File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one >Query Activity for file two > Data Extension Entry
A) Scheduled Automation > Import File Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two
C) File Drop Automation > Verification Activity > Query Activity for file one > Data Extension Entry > Query Activity for file two
D) Scheduled Automation > Import File Activity > Verification Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

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

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) exam
Question #: 111
Topic #: 3
[All Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Questions]

Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).

* The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value.

* A Customer Reference DE is updated daily and holds subscriber information.

* The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items.

* The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.

* If the web analytics file is empty, NTO does not want the automation to finish running.

Which order of activities should be used to fulfill this requirement?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Jacquelyne at Jul 12, 2025, 04:12 AM

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:

0/2000 characters
Submit Cancel
Magdalene
6 months ago
Definitely not A, it skips the verification step!
upvoted 0 times
...
Vallie
6 months ago
Wait, why wouldn't they want the automation to finish if the web analytics file is empty? That seems odd.
upvoted 0 times
...
Anastacia
6 months ago
I think option B makes the most sense here.
upvoted 0 times
...
Thaddeus
6 months ago
I agree with B, it covers all the bases.
upvoted 0 times
...
Jamal
6 months ago
Sounds like a complex setup with multiple DEs!
upvoted 0 times
...
German
7 months ago
I recall that if the web analytics file is empty, we need to stop the automation. So, I think verification should be prioritized to check that before proceeding.
upvoted 0 times
...
Lashawn
7 months ago
I’m a bit confused about whether to use scheduled or file drop automation. I thought file drop was better for real-time data, but I’m not entirely sure.
upvoted 0 times
...
Gertude
7 months ago
I think we practiced a similar question where the order of activities was crucial. I feel like verification should come before the query activities to ensure data integrity.
upvoted 0 times
...
Fabiola
7 months ago
I remember that the automation needs to start with a file drop, but I'm not sure if verification is necessary right after that.
upvoted 0 times
...
Deangelo
7 months ago
This seems straightforward enough. I'd go with the Scheduled Automation approach, bringing in the files, verifying, and then querying the data to populate the journey. The key will be making sure the automation stops if the web analytics file is empty.
upvoted 0 times
...
Jaclyn
8 months ago
Okay, I think I've got a strategy. I'll start with the File Drop Automation to bring in the third data extension, then use Verification to check if it's empty. From there, I can query the other two data extensions and tie it all together in the Data Extension Entry.
upvoted 0 times
...
Celeste
8 months ago
Hmm, I'm a bit confused about the lack of Subscriber Key and Email Address in the first and third data extensions. I'll need to think through how to tie those together.
upvoted 0 times
...
Viva
8 months ago
This looks like a tricky one. I'll need to carefully map out the data flow and dependencies between the different data extensions.
upvoted 0 times
...
Anna
10 months ago
Ah, the age-old question of abandon cart journeys. I say we just scrap the whole thing and start a new business selling... I don't know, talking toasters or something.
upvoted 0 times
...
Eliz
10 months ago
Hmm, this is a tricky one. I'm leaning towards option C, but I'd want to double-check the order of the Query Activities just to be safe.
upvoted 0 times
...
Mona
10 months ago
Option B looks good to me. The File Drop Automation and Verification Activity should help ensure the data is valid before proceeding with the other steps.
upvoted 0 times
Tesha
8 months ago
Agreed, the File Drop Automation and Verification Activity are crucial.
upvoted 0 times
...
Haydee
8 months ago
I think Option B is the best choice.
upvoted 0 times
...
...
Virgilio
10 months ago
I believe D is the best choice because it includes all the necessary steps in the correct order.
upvoted 0 times
...
Cheryl
10 months ago
I'm not sure, but I think C could also be a possible option.
upvoted 0 times
...
Long
10 months ago
I agree with Naomi, D seems like the correct order.
upvoted 0 times
...
Naomi
10 months ago
I think the answer is D.
upvoted 0 times
...
Lisha
11 months ago
I think option D is the way to go. It seems to follow the logical flow of the requirements and ensures the automation won't run if the web analytics file is empty.
upvoted 0 times
Nida
10 months ago
Yeah, option D makes the most sense based on the requirements provided.
upvoted 0 times
...
Brunilda
10 months ago
I agree, option D seems like the best choice to make sure everything runs smoothly.
upvoted 0 times
...
...

Save Cancel