New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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

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

Northern Trail Outfitters in interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a extension for sending. The data warehouse can be configured to place a file daily on an SFTP.

Which three questions are relevant to determining a solution?

Choose 3 answers

Show Suggested Answer Hide Answer
Suggested Answer: A, D, E

Three questions that are relevant to determining a solution for automating a process of importing data from a data warehouse into Marketing Cloud are:

Is the data file a delta or a historical file? This question will help determine how to handle existing records and avoid duplication or overwrite. A delta file contains only new or updated records, while a historical file contains all records regardless of changes.

Will the data file be placed on the SFTP at the same time daily? This question will help determine how to schedule an automation or trigger an event based on file drop. If the data file is placed on the SFTP at different times, then a File Drop Automation may be more suitable than a Scheduled Automation.

Does someone need to be notified if an error happens on import? This question will help determine how to handle errors and exceptions during import. If someone needs to be notified, then an email notification activity or a verification activity may be added to the automation.

Whether the data extension has a data relationship or not is not relevant to determining a solution for importing data, as it is only used for creating relationships between data extensions in Email Studio. Whether the file has more than 5,000 rows or not is not relevant to determining a solution for importing data, as it does not affect how data is imported or processed. Reference: https://help.salesforce.com/s/articleView?id=sf.mc_as_file_drop_automation_studio_triggers.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_import_file_activity.htm&type=5


Contribute your Thoughts:

0/2000 characters
Helga
3 months ago
B seems a bit off, why would data relationships matter here?
upvoted 0 times
...
Edwin
3 months ago
Wait, does it really matter if the file has over 5,000 rows?
upvoted 0 times
...
Noel
3 months ago
I think E is also key, can't have errors go unnoticed!
upvoted 0 times
...
Janae
4 months ago
Totally agree, D is crucial for scheduling.
upvoted 0 times
...
Corinne
4 months ago
A is super important to know if we're dealing with deltas.
upvoted 0 times
...
Maryln
4 months ago
I wonder if we need to consider error notifications. It seems like a good practice, but I can't recall if it’s essential for this scenario.
upvoted 0 times
...
Lenna
4 months ago
I feel like knowing the timing of the file on the SFTP is key too. If it’s not consistent, it could mess up the automation.
upvoted 0 times
...
Margurite
4 months ago
I'm not entirely sure, but I remember something about data relationships being important for how the extension processes the data.
upvoted 0 times
...
Paulina
5 months ago
I think understanding whether the data file is delta or historical is crucial. It affects how we handle updates, right?
upvoted 0 times
...
Deane
5 months ago
I think the timing of the file placement on the SFTP is a crucial detail. We'll need to make sure the import process can handle that consistently.
upvoted 0 times
...
Candra
5 months ago
The question about file size is interesting. I wonder if that would impact the solution in any way. I'll have to consider that as I work through this.
upvoted 0 times
...
Galen
5 months ago
Okay, let's see. I'd want to know if the data file is a delta or historical, and whether the extension has a data relationship. Those seem like important factors.
upvoted 0 times
...
Kizzy
5 months ago
Hmm, I'm a bit unsure about this one. I'll need to think through the key details to determine the most relevant questions.
upvoted 0 times
...
Aretha
5 months ago
This question seems pretty straightforward. I'd focus on understanding the data file and the import process.
upvoted 0 times
...
Lon
5 months ago
This seems straightforward - the flow logs indicate an ICMP deny, so it's likely an inbound security group rule blocking the ping request. I'll start there and see if I can quickly resolve the issue.
upvoted 0 times
...
Merissa
1 year ago
I agree with the others, but I'm also curious about B. Does the data extension have any relationships that could affect the import?
upvoted 0 times
Malcom
1 year ago
B) Does the data extension have a data relationship?
upvoted 0 times
...
Essie
1 year ago
E) Does someone need to be notified if an error happens on import?
upvoted 0 times
...
Ines
1 year ago
C) Will the file have more than 5,000 rows?
upvoted 0 times
...
Celestina
1 year ago
A) Is the data file a delta or a historical file
upvoted 0 times
...
...
Glenn
1 year ago
Ha, if there are more than 5,000 rows, I hope they're not trying to do this manually! Gotta automate that process.
upvoted 0 times
...
Kindra
1 year ago
I'd throw in C as well. The number of rows could impact the solution and how it's implemented.
upvoted 0 times
Queenie
1 year ago
E) Does someone need to be notified if an error happens on import?
upvoted 0 times
...
Mitsue
1 year ago
C) Will the file have more than 5,000 rows?
upvoted 0 times
...
Whitney
1 year ago
A) Is the data file a delta or a historical file
upvoted 0 times
...
...
Kenneth
1 year ago
Definitely need to know if it's a delta or historical file, and if the import will happen at the same time each day. Notification of errors is also important.
upvoted 0 times
Lenna
1 year ago
E) Does someone need to be notified if an error happens on import?
upvoted 0 times
...
Carry
1 year ago
D) Will the data file be placed on the SFTP at the same time daily?
upvoted 0 times
...
Eun
1 year ago
A) Is the data file a delta or a historical file
upvoted 0 times
...
...
Daniel
1 year ago
I'm not sure about B and D, but A, C, and E seem crucial for finding the right solution.
upvoted 0 times
...
Lajuana
1 year ago
Hmm, I think the key questions here are A, D, and E. The data source and timing of the file are crucial to automating the process.
upvoted 0 times
Launa
1 year ago
E) Does someone need to be notified if an error happens on import?
upvoted 0 times
...
Venita
1 year ago
D) Will the data file be placed on the SFTP at the same time daily?
upvoted 0 times
...
Hannah
1 year ago
A) Is the data file a delta or a historical file
upvoted 0 times
...
...
Camellia
1 year ago
I agree with Mary. Those questions will help determine the solution.
upvoted 0 times
...
Mary
1 year ago
I think A, C, and E are relevant questions.
upvoted 0 times
...

Save Cancel