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

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

Question #: 1
Topic #: 14

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

A company collects subscriptions on its websites. It does the following:

*Compiles that subscription list in a database in the website content Management System (CMS).

*Posts this encrypted list to Marketing Cloud nightly at 11 p.m.

*Uses Marketing Cloud as the database of record.

*Sends up to five emails a week based on subscriber engagement with prior sends.

What automation sequence (excluding waits) should cover these requirements?

AFile Transfer > Import File > Measures > Send Email

BFile Transfer > Import File > SQL Query > Send Email

CFile Transfer > SQL Query > Measures > Send Email

DFile Transfer > Data Extract > Filters > Send Email

Show Suggested Answer

Suggested Answer: B

by Ernie at May 09, 2022, 01:14 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

Stefanie

4 months ago

I’m surprised they send that many emails a week!

upvoted 0 times

...

Temeka

4 months ago

Wait, why would they use SQL? Seems complicated for this.

upvoted 0 times

...

Brynn

4 months ago

Definitely going with B, it makes the most sense.

upvoted 0 times

...

Corazon

4 months ago

I think A might work too, but not sure.

upvoted 0 times

...

Onita

4 months ago

Sounds like B is the right choice!

upvoted 0 times

...

Lonny

5 months ago

I have a hunch that option B is the right choice since it mentions SQL Query, which seems essential for targeting the right subscribers.

upvoted 0 times

...

Helene

5 months ago

I practiced a similar question, and I think the sequence needs to start with a File Transfer, but I can't recall if Measures or SQL Query comes next.

upvoted 0 times

...

Fausto

5 months ago

I remember we talked about the importance of importing the file correctly before any SQL queries. I think that might help narrow it down.

upvoted 0 times

...

Shayne

5 months ago

I'm not entirely sure, but I feel like the SQL Query option is crucial for segmenting the audience based on engagement.

upvoted 0 times

...

Art

5 months ago

Azure Data Factory could be useful for data processing and integration, but I'm not sure if that's the right approach for this specific problem. I'll need to review the details more closely.

upvoted 0 times

...

Cory

5 months ago

Ah, I think I've got it! The SLAs are defined in the "Define Priorities for Change Request" customizing activity. That's where we set the days and hours by priority.

upvoted 0 times

...

Tatum

5 months ago

I'm not too sure, but I remember something about reliability being a key factor. Maybe A?

upvoted 0 times

...