Chapter 3 of 6 · Snowflake ADA-C02
Data and Object Management
Warehouses, tables, views, stages, Iceberg, tasks, queries and Snowsight sharing.
- 11topics
- 53 minfast track
- 4diagrams and exhibits
- 15%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Virtual Warehouses - Design, Sizing, Properties and Session UseDesign and maintain virtual warehouses: size and type impact on loading and queries, auto-suspend, auto-resume, cache effects and…5 min
- 2Multi-Cluster Warehouses - Use Cases, Scaling Policy and MonitoringManage multi-cluster warehouses: when they help, Maximized versus Auto-scale mode, Standard and Economy scaling policy, cluster…Diagram5 min
- 3Databases, Tables and Table Types - Design and ManagementManage databases, tables and views and choose table types: permanent, transient, temporary, dynamic, hybrid and event tables…5 min
- 4External Tables and Iceberg TablesCreate and manage external tables and Apache Iceberg tables: read-only files in a stage, Snowflake-managed versus externally…4 min
- 5Views, Secure Views, Materialized Views and CloningChoose between standard, secure and materialized views, know their limits, and identify when zero copy cloning of databases and…5 min
- 6Staging Data, Storage Integrations and Data Exfiltration ControlsStage data with internal and external stages, create storage integrations for secure cloud access, and block data exfiltration…Diagram5 min
- 7External Volumes for Iceberg Tables and the Polaris Open CatalogCreate and manage an EXTERNAL_VOLUME for Iceberg tables, set default volumes, and understand the Polaris Catalog now called…Diagram5 min
- 8Tasks - Configure, Schedule and Set PermissionsManage Snowflake tasks: configure them, schedule with intervals, cron or streams, build task graphs, and grant the privileges to…Diagram5 min
- 9Tasks - Troubleshooting, Use Cases and Serverless Versus User-ManagedTroubleshoot task runs with TASK_HISTORY, know where tasks fit, and choose between user-managed tasks and Snowflake-managed…4 min
- 10Queries, Sequences, Persisted Results, Cancelling and Query HistoryRun queries, use sequences and know their limits, reuse persisted query results, cancel statements for one or many users and…5 min
- 11Snowsight Charts, Dashboards, Sharing and RecoveryVisualize results with Snowsight charts, monitor activity with dashboards, share worksheets, dashboards and charts, and know…5 min
About this chapter
What this chapter covers
Data and Object Management is the chapter on the objects an administrator creates and keeps healthy: the compute that runs work, the tables and views that hold data, the stages and integrations that bring data in, the tasks that automate it, and the tools used to watch and share results. For the SnowPro Advanced: Administrator ADA-C02 exam it tests decisions, not definitions: which warehouse setting, table type, integration or task model fits a requirement, and what it costs.
Questions are scenarios that start with "An administrator needs to ...". They are single answer, multiple select or interactive, and the right answer usually hinges on one trade-off such as concurrency against size, or recoverability against storage cost.
How the topics fit together
- Warehouses are sized for the work and made multi-cluster for concurrency.
- Tables, views and cloning decide cost, recoverability and what can be shared.
- Stages, storage integrations and external volumes connect cloud storage safely and limit exfiltration.
- Tasks automate loading and maintenance on user-managed or serverless compute.
- Queries and Snowsight cover sequences, result reuse, cancelling, query history, charts and dashboards.
Many answers here come down to three questions. Is the problem concurrency (more clusters) or one slow query (bigger size)? Must the data be recoverable (permanent table) or rebuilt (transient)? Does access need a secret (no, use an integration)?
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with diagrams, SQL and comparison tables.
- Common mistakes: the classic traps.
- What to remember for the exam: the facts to memorize.
- Check yourself: three questions to test your understanding.
Read the pages in order the first time. The task pages reuse warehouses and streams from the earlier ones.
Ready for more practice?
The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.