# Automation Studio activities, query tuning and monitoring

*Marketing Cloud Engagement Consultant Study Guide · Automation · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/marketing-cloud-engagement-consultant/automation/automation-studio-activities-query-tuning-and-monitoring*

Which Automation Studio starting source, wait, extract, transfer, send and query design fits a data requirement, how to keep SQL Query activities inside their limits, and where to monitor activity errors and automation health.

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

**Official exam objective:**

> Given a customer scenario, provide the appropriate automation type and activities that should be utilized.

## What the exam expects

- Choose the starting source, schedule and run options for a new automation, including external file locations.
- Design waits inside an automation and predict which runs are skipped.
- Pick the activities that move data in and out: Data Copy or Import, data extracts, File Transfer and Send Email.
- Tune SQL Query activities: data action, scope, field design, searchable arguments, staging and concurrency.
- Direct a client to the right monitoring view for one activity or for automation health over time.
- Key terms: **starting source** (Schedule, File Drop or Trigger); **Safehouse** (the secure file location extracts write to); **data action** (Append, Overwrite or Update for a query's target); **data staging** (splitting a large query into smaller queries that write holding tables); **object detail page** (an activity's configuration and run history).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| New scheduled automation | Paused until activated | [Schedule an Automation](https://help.salesforce.com/s/articleView?id=mktg.mc_as_schedule_an_automation.htm&type=5&language=en_US) |
| QueuedFile after pause | Status kept permanently | [Automation Starting Sources](https://help.salesforce.com/s/articleView?id=mktg.mc_as_triggered_automations.htm&type=5&language=en_US) |
| Combined wait time | At most one year | [Wait Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_wait_activity.htm&type=5&language=en_US) |
| Run due during a wait | Skipped | [Wait Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_wait_activity.htm&type=5&language=en_US) |
| Extract then transfer | File Transfer in a separate step | [Data Extract Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_a_data_extract_activity.htm&type=5&language=en_US) |
| Tracking extract time zone | CST without DST unless Use Local TZ in Query | [Data Extract Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_a_data_extract_activity.htm&type=5&language=en_US) |
| Classic-editor Send Email activity | Not editable; replace it | [Send Email Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_send_email_activity.htm&type=5&language=en_US) |
| SQL Query timeout | 30 minutes | [Optimizing a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&type=5&language=en_US) |
| Large copies | Extract plus import, not a query | [Optimizing a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&type=5&language=en_US) |
| Queries per step | One | [Optimizing a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&type=5&language=en_US) |
| SQL Query statements | SELECT only, against data extensions and data views | [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&type=5&language=en_US) |
| No-opens sample query | Jobs under 500,000 subscribers; larger jobs use intermediate tables | [Query: Subscribers with No Opens or Clicks](https://help.salesforce.com/s/articleView?id=mktg.mc_as_query_find_subscribers_with_no_opens_or_clicks_ref.htm&type=5&language=en_US) |
| History dashboard | Updated daily; downloads as CSV | [Get Automation History](https://help.salesforce.com/s/articleView?id=mktg.mc_as_automation_history_dashboard.htm&type=5&language=en_US) |

## Check yourself

- When should a SQL Query activity move to a different tool even though it still finishes?
- Which Automation Studio activities have an object detail page?
- Why might rows in a standard data extension extract file be out of insertion order?
- Why doesn't the History dashboard show an automation that's running now?

## Sources

- [Automation Starting Sources](https://help.salesforce.com/s/articleView?id=mktg.mc_as_triggered_automations.htm&type=5&language=en_US)
- [Schedule an Automation](https://help.salesforce.com/s/articleView?id=mktg.mc_as_schedule_an_automation.htm&type=5&language=en_US)
- [Configure a Trigger Automation](https://help.salesforce.com/s/articleView?id=mktg.mc_as_define_a_file_trigger_automation.htm&type=5&language=en_US)
- [Wait Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_wait_activity.htm&type=5&language=en_US)
- [Automation Studio Activities](https://help.salesforce.com/s/articleView?id=mktg.mc_as_using_automation_studio_activities.htm&type=5&language=en_US)
- [Import or Copy Large Datasets](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_copy_or_import.htm&type=5&language=en_US)
- [Data Extract Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_a_data_extract_activity.htm&type=5&language=en_US)
- [Data Extension Extract in Automation Studio](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_extension_extract.htm&type=5&language=en_US)
- [How to Use the File Transfer Activity in Automation Studio](https://help.salesforce.com/s/articleView?id=mktg.mc_as_using_the_file_transfer_activity.htm&type=5&language=en_US)
- [Send Email Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_send_email_activity.htm&type=5&language=en_US)
- [Optimizing a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&type=5&language=en_US)
- [SQL Reference](https://help.salesforce.com/s/articleView?id=mktg.mc_as_sql_reference.htm&type=5&language=en_US)
- [Query: Subscribers with No Opens or Clicks](https://help.salesforce.com/s/articleView?id=mktg.mc_as_query_find_subscribers_with_no_opens_or_clicks_ref.htm&type=5&language=en_US)
- [Find Activity Configuration and Error Details](https://help.salesforce.com/s/articleView?id=mktg.mc_as_find_activity_configuration_and_error_details.htm&type=5&language=en_US)
- [Automation History and Health](https://help.salesforce.com/s/articleView?id=mktg.mc_as_automation_history_and_health.htm&type=5&language=en_US)
- [Get Automation History](https://help.salesforce.com/s/articleView?id=mktg.mc_as_automation_history_dashboard.htm&type=5&language=en_US)

## About the full unit

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