# Automation Studio query, verification and wait activities

*Marketing Cloud Engagement Specialist Study Guide · Marketing Automation · Last updated October 29, 2026 · https://www.certifyforce.com/study-guide/marketing-cloud-engagement-specialist/marketing-automation/automation-studio-query-verification-and-wait-activities*

How to order activities in automation steps, what a SQL Query activity can and can't do, how to keep data view history beyond six months, and when to add a Verification, Wait, Send Email with Einstein Send Time Optimization, or Filter activity.

- Certification: Salesforce Marketing Cloud Engagement Specialist
- Exam section: Marketing Automation
- Study guide: https://www.certifyforce.com/study-guide/marketing-cloud-engagement-specialist

**Official exam objective:**

> Given a customer scenario, build the appropriate Automation Studio solution.

## What the exam expects

- Order activities across automation steps so an activity that reads data comes in a later step than the query that builds it.
- Build a valid SQL Query activity: separate target, named columns with a JOIN, supported SQL only, and the 30-minute timeout.
- Keep more than six months of data view history with a scheduled query into your own data extension.
- Add a Verification activity to stop or alert on bad data, a Wait activity to hold until a time, and a Filter activity for no-SQL segments.
- Configure a Send Email activity with Einstein Send Time Optimization and know what it switches off.
- Key terms: **step** (a stage of an automation that holds one or more activities); **target data extension** (where a query writes its results); **data view** (a system table of up to six months of subscriber and journey data); **Verification activity** (checks a data extension and stops or notifies); **Wait activity** (holds the automation for a duration or until a time).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Reading a query's output | Place the reader in a later step | [Automation Studio Tasks](https://trailhead.salesforce.com/content/learn/modules/automation-studio-activities/automate-marketing-cloud-tasks) |
| Query target | Can't be a data extension used in the query | [Build a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_the_sql_query_activity.htm&language=en_US&type=5) |
| JOIN with SELECT * | Not permitted; name each column | [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&language=en_US&type=5) |
| NOLOCK | Unnecessary; queries run READ UNCOMMITTED | [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&language=en_US&type=5) |
| Query timeout | 30 minutes | [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&language=en_US&type=5) |
| Suspended query | System error or 24 consecutive failures | [Retrieving and Segmenting Data](https://help.salesforce.com/s/articleView?id=mktg.mc_as_using_the_query_activity.htm&language=en_US&type=5) |
| Data views | Up to six months of data | [Retrieving and Segmenting Data](https://help.salesforce.com/s/articleView?id=mktg.mc_as_using_the_query_activity.htm&language=en_US&type=5) |
| Verification actions | Stop the automation, email a notification, or both | [Verification Activity](https://help.salesforce.com/s/articleView?language=en_US&id=mktg.mc_as_verification_activity.htm&type=5) |
| Verification step | Only Verification activities in that step; not reusable | [Verification Activity](https://help.salesforce.com/s/articleView?language=en_US&id=mktg.mc_as_verification_activity.htm&type=5) |
| Wait activity | Duration or specific time; combined waits up to one year | [Wait Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_wait_activity.htm&language=en_US&type=5) |
| STO in Send Email | Turns off throttling; about 20 minutes per million subscribers | [Send Email Activity](https://help.salesforce.com/s/articleView?id=mc_as_send_email_activity.htm&language=en_US&type=5) |
| Filter activity | Applies a data filter; creates a group or data extension | [Filter Activity](https://help.salesforce.com/s/articleView?id=sf.mc_es_data_filter_activity.htm&language=en_US&type=5) |

## Check yourself

- When might Einstein Send Time Optimization need up to 72 hours before you can use it in a Send Email activity?
- When is a SQL Query activity suspended?
- Which SQL elements does the SQL Query activity reject?
- What is the longest combined wait time an automation can have?

## Sources

- [Build a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_the_sql_query_activity.htm&language=en_US&type=5)
- [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&language=en_US&type=5)
- [Retrieving and Segmenting Data with a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_using_the_query_activity.htm&language=en_US&type=5)
- [Automate Marketing Engagement Tasks with Automation Studio](https://trailhead.salesforce.com/content/learn/modules/automation-studio-activities/automate-marketing-cloud-tasks)
- [Verification Activity](https://help.salesforce.com/s/articleView?language=en_US&id=mktg.mc_as_verification_activity.htm&type=5)
- [Verification Activity Example](https://help.salesforce.com/s/articleView?id=sf.mc_as_verification_activity_example.htm&language=en_US&type=5)
- [Wait Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_wait_activity.htm&language=en_US&type=5)
- [Send Email Activity](https://help.salesforce.com/s/articleView?id=mc_as_send_email_activity.htm&language=en_US&type=5)
- [Filter Activity in Marketing Cloud Engagement](https://help.salesforce.com/s/articleView?id=sf.mc_es_data_filter_activity.htm&language=en_US&type=5)
- [Automation Studio](https://help.salesforce.com/s/articleView?id=mktg.mc_as_automation_studio.htm&language=en_US)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 9 linked practice questions, and unlimited timed mock exams are included with the Marketing Cloud Engagement Specialist pack (USD $19): https://www.certifyforce.com/practice-exams