Salesforce Exam Marketing Cloud Consultant Topic 14 Question 76 Discussion

Actual exam question for Salesforce's Marketing Cloud Consultant exam

Question #: 76
Topic #: 14

[All Marketing Cloud Consultant Questions]

Northern Trail Outfitters (NTO) stores customer purchase data m an external system. NTO ingests this data into Marketing Cloud through a file drop automation. The automation contains an import activity which overwrites a staging data extension, as well as an SQL Query activity which brings this data into a sendable data extension.

NTO's marketing manager wants to be informed If mort than 1,000 records are ever imported through this automation, and would also like to prevent the sendable date extension from being updated that day.

Which solution ts appropriate in this situation?

ASplit the existing activities into two separate automations.

BImplement a Wait Activity to wait until the data extension is populated with records.

CPlace a Verification Activity between the import and SQL Query activity.

DWrite a custom SSJS script to

Evalidate the row count of the staging data extension and send a notification email.

Show Suggested Answer

Suggested Answer: C

by Oretha at Dec 24, 2023, 12:12 PM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Consultant Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Talia

9 days ago

I'm not sure about option E. I think splitting the activities into two separate automations (option A) could also work well in this situation.

upvoted 0 times

...

Leslee

10 days ago

I agree with Sabra. Option E will also prevent the sendable data extension from being updated that day.

upvoted 0 times

...

Detra

12 days ago

I'm leaning towards B. The Wait Activity will ensure that the data extension is fully populated before moving on to the SQL Query. This way, we don't have to worry about the record count or any potential data issues. It's a straightforward solution that should do the trick.

upvoted 0 times

...

Sabra

12 days ago

I think option E is the best solution. It will notify the marketing manager if more than 1,000 records are imported.

upvoted 0 times

...

Roxane

15 days ago

E seems like the best solution to me. Using a custom SSJS script to validate the row count and send a notification email is a robust and flexible approach. It gives us more control over the process and allows us to tailor the notification to the marketing manager's needs.

upvoted 0 times

...

Walker

17 days ago

I think option C is the way to go. The Verification Activity will allow us to check the record count before proceeding to the SQL Query activity. This way, we can prevent the sendable data extension from being updated if the count exceeds 1,000. Simple and effective!

upvoted 0 times

Lisha

2 days ago

I agree, option C seems like the best solution. It allows us to control the flow based on the record count.

upvoted 0 times

...

Elli

18 days ago

I prefer option C. Placing a Verification Activity will ensure data integrity before sending out any emails.

upvoted 0 times

...

Anika

24 days ago

I agree with Carma. Option E will also prevent the sendable data extension from being updated that day.

upvoted 0 times

...

Carma

27 days ago

I think option E is the best solution. It will notify the marketing manager if more than 1,000 records are imported.

upvoted 0 times

...