SnowPro Advanced: Administrator (ADA-C02) — Practice Questions and Mock Exam

The SnowPro Advanced: Administrator Certification (ADA-C02) validates expertise in Snowflake account administration, including managing and monitoring accounts, enforcing data security and compliance, handling database objects and virtual warehouses, performance tuning, data sharing via Marketplace and Exchange, and implementing disaster recovery and replication strategies. It covers the full operational scope of a Snowflake administrator.

This certification is designed for database administrators, cloud administrators, and data platform operators with two or more years of Snowflake administration experience. It demonstrates the ability to maintain secure, performant, and compliant Snowflake environments at enterprise scale and is essential for roles managing production deployments.

Security, RBAC, and user administration carry the most weight at 31%, covering the built-in role hierarchy, custom role design, federated authentication and MFA, and network policy configuration. Performance monitoring and tuning follows at 20%, testing query profile analysis, caching behavior, DML concurrency, and cost management through resource monitors and the ACCOUNT_USAGE schema. Account management and data governance (18%) and data and object management (15%) cover the remaining operational core: organizational parameters, warehouse sizing, table and view design, and data masking or row-access policies.

Disaster recovery and data sharing close out the blueprint at 9% and 7%, still testing replication groups, failover, Time Travel, and Marketplace listing management in depth despite the low weight. The split reflects how a production administrator spends their week: more time granting and auditing access and chasing slow queries than configuring outbound data shares or building a DR runbook from scratch.

The exam consists of 65 questions in 115 minutes, drawn from multiple-choice, multiple-select, and interactive formats such as matching and drag-and-drop. Most items work from an operational scenario: a described account, role structure, or performance issue that you resolve by choosing the right SQL statement, parameter, or policy setting. At roughly 1.8 minutes per question, the pace rewards candidates who don't have to stop and work out the role hierarchy from scratch.

Every domain of the SF-ADM exam has enough questions in the pool to practice it in depth. A mock exam asks 65 questions in one sitting, on the same 115-minute clock as the real thing.

How long you'll need depends on how much hands-on experience you bring. The rest is set by the vendor: how the exam is delivered, how soon you can retake it, and how long the credential stays valid.

Delivered by online proctoring or at an onsite testing center, in English. The certification expires two years after your issue date; you recertify through the Snowflake Continuing Education program with an eligible instructor-led training course or an equivalent or higher-level SnowPro certification.

Administrators who manage Snowflake only through Snowsight often struggle once questions turn to SQL-based role grants, programmatic authentication, and network policy configuration at the account versus user level. The built-in role hierarchy (ACCOUNTADMIN, SECURITYADMIN, USERADMIN, SYSADMIN) trips up candidates who haven't traced how a custom role inherits privileges through it. The same gap shows up in cost and governance questions: resource monitors track credit consumption, not storage, and dynamic data masking is not the same control as a row access policy.