10 beginner questions on the SnowPro Core (COF-C03) domains: Snowflake AI Data Cloud Features & Architecture, Account Management and Data Governance, Data Loading, Unloading, and Connectivity, Performance Optimization, Querying, and Transformation, and Data Collaboration. They cover virtual warehouses, system roles, resource monitors, Snowpipe, semi-structured data, the result cache, multi-cluster warehouses, FLATTEN and Secure Data Sharing.

Ready to test yourself? Take the graded Beginner test (free; sign in with Google, one click) to get your score.

  1. Snowflake's architecture has three layers. Which layer actually executes SQL queries?

    • A. Database storage
    • B. Compute (virtual warehouses) ✔ correct
    • C. Cloud services
    • D. Client connectivity (drivers and connectors)

    Answer: B. Virtual warehouses form the compute layer and execute SQL statements. Database storage holds the loaded data in cloud storage, and the cloud services layer coordinates activities such as sign-in, metadata and query dispatch.

    Source: docs.snowflake.com/en/user-guide/intro-key-concepts · Domain: Snowflake AI Data Cloud Features & Architecture

  2. Each Snowflake virtual warehouse is an independent compute cluster, so a heavy workload on one warehouse does not slow down queries running on another warehouse.

    • A. True ✔ correct
    • B. False

    Answer: A. True. Snowflake separates storage and compute, and each virtual warehouse has its own compute resources that are not shared with other warehouses, so different workloads can be isolated.

    Source: docs.snowflake.com/en/user-guide/intro-key-concepts · Domain: Snowflake AI Data Cloud Features & Architecture

  3. A company wants to tightly limit who holds the top-level system-defined role in an account, which encapsulates both SYSADMIN and SECURITYADMIN. Which role is this?

    • A. SECURITYADMIN
    • B. USERADMIN
    • C. ACCOUNTADMIN ✔ correct
    • D. PUBLIC

    Answer: C. ACCOUNTADMIN encapsulates SYSADMIN and SECURITYADMIN and is the top-level role, so it should be granted to a small, controlled set of users. USERADMIN manages users and roles, and PUBLIC is granted to everyone.

    Source: docs.snowflake.com/en/user-guide/security-access-control-overview · Domain: Account Management and Data Governance

  4. An administrator wants a warehouse to be suspended automatically when it has used its monthly credit quota. Which Snowflake object should they create?

    • A. A network policy
    • B. A masking policy
    • C. A row access policy
    • D. A resource monitor ✔ correct

    Answer: D. A resource monitor tracks warehouse credit usage against a quota and can notify, suspend, or suspend immediately when thresholds are reached. Network, masking and row access policies control access, not spending.

    Source: docs.snowflake.com/en/user-guide/resource-monitors · Domain: Account Management and Data Governance

  5. A team wants new files to be loaded into a table automatically, typically within minutes of arriving in a stage, without scheduling load jobs themselves. Which feature fits?

    • A. Snowpipe ✔ correct
    • B. Zero-copy cloning
    • C. Time Travel
    • D. Materialized views

    Answer: A. Snowpipe continuously loads data from files as they arrive in a stage, typically within a minute after it learns about a file. Cloning, Time Travel and materialized views do not ingest files.

    Source: docs.snowflake.com/en/user-guide/data-load-snowpipe-intro · Domain: Data Loading, Unloading, and Connectivity

  6. Which two file formats can Snowflake load as semi-structured data into a VARIANT column? (Select TWO)

    • A. JSON ✔ correct
    • B. PNG
    • C. Parquet ✔ correct
    • D. MP4
    • E. DOCX

    Answer: A, C. Snowflake imports semi-structured data from JSON, Avro, ORC, Parquet and XML and stores it in the VARIANT type. Images, videos and documents are unstructured files, which are handled through stages and file URLs instead.

    Source: docs.snowflake.com/en/user-guide/semistructured-intro · Domain: Data Loading, Unloading, and Connectivity

  7. A user runs exactly the same query as an hour ago, and the underlying table data has not changed. How can Snowflake answer it fastest?

    • A. By reusing the persisted query result (result cache) ✔ correct
    • B. By rebuilding micro-partitions before running the query
    • C. By scaling the warehouse up one size automatically
    • D. By restoring the table with Time Travel first

    Answer: A. Snowflake persists query results for 24 hours (renewed each time they are reused). If the query text matches and the data has not changed, the stored result is returned without executing the query again.

    Source: docs.snowflake.com/en/user-guide/querying-persisted-results · Domain: Performance Optimization, Querying, and Transformation

  8. Individual queries run fast, but at peak times many users submit queries at once and the queries queue on one warehouse. Which change is designed for this situation?

    • A. Enable Time Travel for 90 days
    • B. Use a multi-cluster warehouse that adds clusters ✔ correct
    • C. Create a zero-copy clone of the database
    • D. Increase the auto-suspend time of the warehouse to one hour

    Answer: B. Multi-cluster warehouses (Enterprise Edition) scale out by adding clusters to improve concurrency for many users and queries. Resizing helps slow individual queries; Time Travel, cloning and auto-suspend do not reduce queuing.

    Source: docs.snowflake.com/en/user-guide/warehouses-multicluster · Domain: Performance Optimization, Querying, and Transformation

  9. A column holds a JSON array of order lines. Which table function turns each element of the array into its own row?

    • A. PARSE_JSON
    • B. ARRAY_AGG
    • C. FLATTEN ✔ correct
    • D. TO_VARCHAR

    Answer: C. FLATTEN (often used with LATERAL) explodes a VARIANT, OBJECT or ARRAY value into rows. PARSE_JSON converts a string into a VARIANT, and ARRAY_AGG does the opposite by aggregating rows into an array.

    Source: docs.snowflake.com/en/sql-reference/functions/flatten · Domain: Performance Optimization, Querying, and Transformation

  10. A company wants to give a partner's Snowflake account read-only access to live tables without copying or moving any data. What should it use?

    • A. Unload the tables to files and send them
    • B. Secure Data Sharing with a share ✔ correct
    • C. Replicate the database every night
    • D. Clone the tables into a new database

    Answer: B. With Secure Data Sharing, the provider adds objects to a share and grants it to consumer accounts. No data is copied or transferred between accounts, and shared objects are read-only for the consumer.

    Source: docs.snowflake.com/en/user-guide/data-sharing-intro · Domain: Data Collaboration

Original practice questions written by xOps School (DevOpsSchool Private Limited) from the public Snowflake exam objectives (COF-C03 exam domain breakdown (5 domains)), checked 2026-10-25. They are not actual exam questions. xOps School is not affiliated with or endorsed by Snowflake; exam names are trademarks of their owners. Official exam page: learn.snowflake.com/en/certifications/snowpro-core-c03/.

Last modified: Sunday, 25 October 2026, 9:57 PM