SnowPro Advanced: Administrator Practice Questions

SnowPro Advanced: Administrator (ADA-C02) exam preparationAligned with the official ADA-C02 Study Guide (last updated December 1, 2025)

SnowPro Advanced: Administrator practice questions in English: 170 questions with explanations. The mock exam has 65 questions and 115 minutes.

Open the free questions one by one (10)
  1. Two accounts have the ORGADMIN role enabled: account_123 and…
  2. The audit role r_audit was granted the SNOWFLAKE database…
  3. With a Snowflake OAuth custom client, a reporting tool opens…
  4. The data governance role GOV_R should be able to attach…
  5. From the account that holds a primary database, a…
  6. Hourly task T_BIG runs a large aggregation on user-managed…
  7. A query joins table FACT_SALES (about 120,000…
  8. An ingestion app inserts rows into table T in session 1, and…
  9. A provider administrator ran DROP SHARE on SALES_S by…
  10. In the source account, the FAILOVER privilege on failover…