Question

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?

Accepted Answer

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

Answer

Split the existing activities into two separate automations.

Answer

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

Answer

Write a custom SSJS script to

Answer

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

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

Take the free MARKETING-CLOUD-CONSULTANT practice test

Other MARKETING-CLOUD-CONSULTANT practice questions