MARKETING-CLOUD-CONSULTANT practice question 20 of 25

Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE). •…

Full set: 154 questions
Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE). • The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value. • A Customer Reference DE is updated daily and holds subscriber information. • The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items. • The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address. • If the web analytics file is empty, NTO does not want the automation to finish running. Which order of activities should be used to fulfill this requirement?
Answer options
A: Scheduled Automation > Import File Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two
B: File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one >Query Activity for file two > Data Extension Entry Correct answer
C: File Drop Automation > Verification Activity > Query Activity for file one > Data Extension Entry > Query Activity for file two
D: Scheduled Automation > Import File Activity > Verification Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two
Correct Answer:
B. File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one >Query Activity for file two > Data Extension Entry
Explanation

A File Drop event starts when the analytics file arrives. After the file is imported, a Verification activity can stop the run if the resulting data extension is empty. Subsequent Query activities add SubscriberKey/Email data and the five-day purchase file to a sendable DE, which then feeds the Journey via the Data Extension Entry event.

Why Incorrect

A – Scheduled event won’t start automatically on file arrival; no Verification prevents empty-file run. C – Verification precedes Import, so there is nothing to verify; Data Extension entry occurs before the five-day query. D – Scheduled event, not File Drop, and Verification comes before Import so row count can’t be checked.

References

1. Salesforce Help, “Automation Studio File Drop Automations” (Marketing Cloud), Step order section.

2. Salesforce Help, “Verification Activity” – verifies row count after Import and can stop automation (para. 2).

3. Salesforce Help, “Query Activity” – used to transform data between data extensions (Overview).

Scroll to Top