About the Exam

This Snowflake certification validates essential platform skills, including the user interface, Snowflake Notebooks, data management, account structure, roles, compute resources, stages, and Snowflake Cortex LLM functions. It is aimed at candidates with 3 or more months of Snowflake knowledge. Passing demonstrates foundational ability to work with the Snowflake AI Data Cloud and apply core platform concepts in practice. This exam retired on May 4, 2026.

Exam Topics

  • Set up and navigate the Snowflake user interface and Snowflake Notebooks17%
  • Create databases and stages, and use compute resources17%
  • Load and leverage structured, semi-structured, and unstructured data17%
  • Understand Snowflake roles, and data access management17%
  • Understand and manage the Snowflake Account structure16%
  • Use Snowflake Cortex LLM functions16%

How to Use This Practice Exam

  1. Browse — Read each question, select your answer, and reveal the explanation.
  2. Exam Mode — Simulate real exam conditions with a timed session and score report.
  3. Learn Mode — Spaced repetition schedules questions you struggle with for long-term retention.

Download the Full Exam PDF

Get every question and answer in a clean, printable PDF built for offline study. Purchase once, keep permanent access, and re-download the latest version anytime.

Last updated May 24, 2026 at 8:12 PM

Topic filter
Retired questions
Question sort
Questions per page

QuestionQ1

Set up and navigate the Snowflake user interface and Snowflake Notebooks

Which coding languages are available for use with Snowflake notebooks?

Choose three
Explanation

Snowflake Notebooks provide three supported cell types: SQL, Python, and Markdown. Therefore, the available choices are Markdown, Python, and SQL.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ2

Set up and navigate the Snowflake user interface and Snowflake Notebooks

Which programming-language considerations apply when using Snowflake interfaces?

Choose two
Explanation

Snowflake Notebooks support SQL, Python, and Markdown cells. Therefore, a notebook can contain both SQL cells and Python cells. Snowflake worksheets also support Python, so they are not restricted to SQL. Develop and run code in Snowflake Notebooks

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ3

Load and leverage structured, semi-structured, and unstructured data

Which semi-structured data formats does Snowflake support?

Choose two
Explanation

Snowflake natively supports JSON and Parquet as semi-structured data formats. NDJSON is handled as newline-delimited JSON, not as a distinct file-format type.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ4

Load and leverage structured, semi-structured, and unstructured data

Which characteristics describe schemas in Snowflake?

Choose two
Explanation

A schema belongs to one database and serves as a logical grouping for database objects such as tables and views. Virtual warehouses are account-level compute resources, not objects contained in schemas.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ5

Understand Snowflake roles, and data access management

How can a user transfer ownership of a database to a different role?

Explanation

Snowflake transfers an object's ownership by granting the OWNERSHIP privilege to the receiving role. For a database, the command form is GRANT OWNERSHIP ON DATABASE db_name TO ROLE new_role;.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!
Know a question that should be here? Contribute to this exam
Back home