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

AIs the data file a delta or a historical file

BDoes the data extension have a data relationship?

CWill the file have more than 5,000 rows?

DWill the data file be placed on the SFTP at the same time daily?

EDoes someone need to be notified if an error happens on import?

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

by Lashon at Sep 15, 2024, 10:04 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:

Submit Cancel

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