MARKETING-CLOUD-CONSULTANT practice question 11 of 25

Northern Trail Outfitters (NTO) stores customer purchase data m an external system. NTO ingests this data into Marketing Cloud through a file drop…

Full set: 154 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?
Answer options
A: Split the existing activities into two separate automations.
B: Implement a Wait Activity to wait until the data extension is populated with records.
C: Place a Verification Activity between the import and SQL Query activity. Correct answer
D: Write a custom SSJS script to
E: validate the row count of the staging data extension and send a notification email.
Correct Answer:
C. Place a Verification Activity between the import and SQL Query activity.
Explanation

Verification Activity can be placed between the import and SQL steps to evaluate the staging data-extension row count. If rows exceed 1,000, the activity can stop the automation and send an alert, preventing the SQL step (and thus the sendable DE update) from running.

Why Incorrect

A. Splitting automations doesn’t provide conditional row-count checks or automatic stoppage.
B. Wait Activity merely delays execution; it does not validate row counts or block subsequent steps.
D. Custom SSJS could work but adds unnecessary code complexity; Verification Activity delivers the same capability natively.

References

1. Salesforce Help, “Verification Activity,” Automation Studio Guide, sections ‘Purpose’ & ‘Define Conditions’ (https://help.salesforce.com/s/articleView?id=mcasverificationactivity.htm&type=5).

2. Salesforce Help, “Automation Studio Activities Overview,” Marketing Cloud Doc, table of activities.

Scroll to Top