Home
Practice Questions
SNOWFLAKE
SOL-C01

SNOWFLAKE certification preparation

SOL-C01 Practice Questions

Practice exam-style questions, check your answers, and review explanations and source references where they are available.

Exam: SOL-C01
Provider: SNOWFLAKE
Full set: 214 questions
Last Update Check: September 26, 2026

Browse SNOWFLAKE exams View exam questions

View Mode

Get Full Access

Question number

Which Snowflake object is a logical container for schemas and other database objects?

Answer options

Question 1 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

Explanation

In Snowflake's object hierarchy, a database serves as a primary organizational unit. It acts as a logical container for schemas. Each schema, in turn, contains other database objects such as tables, views, stored procedures, and user-defined functions. This hierarchical structure allows for the logical grouping and management of related data and objects within a single, overarching container. All objects within a database share a common access control framework.

Why Incorrect

A. Schema: A schema is a container for objects like tables and views, but it is contained within a database, not the other way around.

B. View: A view is a database object that represents a saved query; it does not contain other objects.

C. Table: A table is a fundamental database object that stores data in rows and columns; it does not contain other objects.

References

1. Snowflake Documentation. (n.d.). Databases, Tables & Views - An Overview. In Databases. Retrieved from https://docs.snowflake.com/en/sql-reference/ddl-database. "Databases are the logical containers for all of the schemas, tables, views, and other objects you create."

2. Snowflake Documentation. (n.d.). Understanding Snowflake's Object Hierarchy. In Introduction to Snowflake. Retrieved from https://docs.snowflake.com/en/user-guide/intro-key-concepts#object-hierarchy. "A database is a logical grouping of schemas. Each schema is a logical grouping of database objects, such as tables and views."

How can Python variable substitution be performed in Snowflake notebooks?

Answer options

Question 2 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

Explanation

Snowflake Notebooks allow for seamless integration between Python and SQL cells. To use a Python variable within a SQL query, you can use a placeholder syntax. This is done by prefixing the Python variable name with a colon (e.g., SELECT FROM mytable WHERE id = :mypythonvariable;). Snowflake automatically substitutes the placeholder with the variable's value at runtime.

Why Incorrect

A: Manually editing data files is a data manipulation task and is not a method for programmatic variable substitution in code.

B: Network settings are related to connectivity and security, not the logic of variable substitution within a notebook.

D: HTML is a markup language for structuring web pages and has no role in passing variables to SQL queries.

References

1. Snowflake Documentation. (n.d.). Developing code in Snowflake Notebooks - Use Python variables in a SQL cell. Retrieved from https://docs.snowflake.com/en/user-guide/notebooks-develop#use-python-variables-in-a-sql-cell. (This section provides a direct example: "To use a Python variable in a SQL cell, use the variable name with a colon (:) as a prefix.").

Which SQL command is commonly used to load structured data from a stage into a Snowflake table?

Answer options

Question 3 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

Explanation

Snowflake’s recommended method for bulk-loading structured data from an internal or external stage into a table is the COPY INTO

SQL command. COPY INTO reads staged files, automatically applies file format options, and inserts the parsed rows into the target table.

Why Incorrect

A. INSERT INTO – Standard DML; cannot directly pull files from a stage.

C. LOAD DATA – Not a valid Snowflake SQL statement.

D. IMPORT DATA – Not a valid Snowflake SQL statement.

References

1. Snowflake Documentation, “COPY INTO

” – SQL Command Reference, section “Usage Notes”, 2024-03-12 edition.

2. Snowflake Documentation, “Loading Data Using the COPY Command”, Data Loading Guide, step 2.

Which command can be used to query the Information Schema in Snowflake to retrieve a list of tables?

Answer options

Question 4 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

Explanation

The Snowflake Information Schema is a read-only schema available in every database that provides metadata about the objects within it. To retrieve a list of tables and views accessible by the current user's role, the correct command is to query the TABLES view within the INFORMATIONSCHEMA. This view contains columns like TABLENAME, TABLESCHEMA, and TABLETYPE.

Why Incorrect

A. SELECT FROM PUBLIC.INFORMATIONSCHEMA;: This syntax is invalid. INFORMATIONSCHEMA is a schema containing views and cannot be queried directly as if it were a table.

B. SELECT FROM INFORMATIONSCHEMA.COLUMNS;: This command queries the COLUMNS view, which returns metadata about individual columns within tables, not a list of the tables themselves.

D. SELECT FROM PUBLIC.TABLES;: This would query a user-created table named TABLES in the PUBLIC schema, not the system-defined metadata view for listing all tables.

References

- Snowflake Documentation, "Information Schema". This document introduces the Information Schema as the source for object and account metadata.

- Snowflake Documentation, "TABLES View". This page explicitly describes the INFORMATIONSCHEMA.TABLES view and its purpose: "This Information Schema view displays a row for each table or view in the specified (or current) database."

Which command is synonymous with the LIST command in Snowflake?

Answer options

Question 5 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

Explanation

Snowflake defines LS as an exact synonym (alias) of the LIST command for enumerating staged files; both commands share identical syntax and behaviour.

Why Incorrect

B. SHOW is a family of metadata commands, not an alias for LIST.

C. DESC (or DESCRIBE) is used for describing objects, not listing stage contents.

D. LIS is not a recognised Snowflake command.

References

1. Snowflake Documentation – “LIST Command”, note: “Synonym: LS” (docs.snowflake.com, §Syntax, accessed 2024-04-24).

2. Snowflake Documentation – “Commands Not Covered by the SQL Parser” (docs.snowflake.com, confirms command aliases).

Which of the following data format supported to unload semi-structured data from Snowflake? (Choose any 2 options)

Answer options

Question 6 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

A, C

Explanation

When unloading semi-structured VARIANT data via COPY INTO , Snowflake supports JSON and PARQUET file formats, preserving the nested structure. CSV is strictly tabular text and XML is unsupported for unload operations.

Why Incorrect

B. CSV can be used to unload relational data but does not preserve semi-structured hierarchy.

D. XML is not listed among supported unload formats in Snowflake documentation.

References

1. Snowflake Documentation – “Unloading Data: Supported File Formats” lists JSON and PARQUET for semi-structured data (docs.snowflake.com, §Supported Formats, accessed 2024-04-24).

2. Snowflake Documentation – “COPY INTO … TYPE = JSON | PARQUET” examples (docs.snowflake.com, §Examples).

Which of the following file formats can be processed by the PARSE_DOCUMENT function?

Answer options

Question 7 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

A, B, D

Explanation

PARSEDOCUMENT currently supports the document types pdf, docx, and pptx. These formats can be supplied as BINARY input for automated text extraction; XLSX is not listed among supported types.

Why Incorrect

C. XLSX spreadsheets are not in the supported-types list for PARSEDOCUMENT; attempt returns error.

References

1. Snowflake Documentation, “PARSEDOCUMENT” – Argument ‘filetype’: allowed values = 'pdf', 'docx', 'pptx', ¶2 (docs.snowflake.com/en/sql-reference/functions/parsedocument).

2. Snowflake Documentation, “PARSEDOCUMENT” – Examples section, Example 1 (demonstrates PDF and DOCX parsing).

What is the typical syntax for using the LIMIT clause to retrieve the first 10 rows of a table named employees?

Answer options

Question 8 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

Explanation

The LIMIT clause in Snowflake SQL is used to restrict the number of rows returned by a query. The correct and standard syntax places the LIMIT clause at the end of the SELECT statement, after the FROM and any WHERE, GROUP BY, or ORDER BY clauses. The syntax SELECT FROM employees LIMIT 10; correctly requests all columns () from the employees table and returns only the first 10 rows encountered.

Why Incorrect

B. SELECT LIMIT 10 ... is syntactically incorrect; LIMIT is not part of the column selection list in the SELECT clause.

C. LIMIT 10 SELECT ... is syntactically incorrect; the SELECT statement must come first.

D. ... WHERE LIMIT 10; is syntactically incorrect; LIMIT is a clause that constrains the final result set, not a condition within the WHERE clause.

References

1. Snowflake Documentation. (n.d.). SELECT. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/sql/select. The syntax summary shows [ LIMIT ] as one of the final clauses of a SELECT statement.

2. Snowflake Documentation. (n.d.). LIMIT / FETCH. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/constructs/limit. The documentation provides examples such as SELECT FROM mytable LIMIT 10;, confirming this structure.

How can you search for listings on Snowflake Marketplace? (Choose any 2 options)

Answer options

Question 9 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

A, D

Explanation

The Snowflake Marketplace provides two primary search mechanisms for discovering data listings. First, users can browse through organized categories and tags that classify listings by industry, data type, or use case. Second, the marketplace interface includes a dedicated search bar at the top of the page where users can enter keywords to find specific listings. These are the standard, self-service methods built into the marketplace interface for discovering available data products and services.

Why Incorrect

B. Contact Snowflake Support - Support is for technical issues, not for searching marketplace listings.

C. User Universal Search - This searches within your Snowflake account objects, not marketplace listings.

References

1. Snowflake Documentation: "Using the Snowflake Marketplace" - Data Marketplace User Guide, Section: "Finding and Requesting Data", Pages 3-4

2. Snowflake Official Documentation: "Snowflake Marketplace Overview" - Platform Documentation, Section: "Browsing and Searching Listings"

3. Snowflake Documentation: "Universal Search" - Platform Features Guide, Section: "Search Scope and Limitations" (confirms Universal Search is for account objects only)

What can a schema in Snowflake contain? (Choose any 3 options)

Answer options

Question 10 discussion

No comments yet. Be the first to comment.

Your name Add a comment

Website

Be respectful. No spam.

Correct Answer:

A, B, C

Explanation

In Snowflake's object hierarchy, a schema is a logical grouping of database objects. A schema belongs to a single database. The objects that can be contained within a schema include tables, views, and named stages. Virtual warehouses are compute resources and are considered account-level objects, meaning they are not contained within specific schemas or databases but can be used to access objects within them.

Why Incorrect

D. Virtual warehouses are compute resources defined at the account level, not within a schema. They are used to execute queries on data contained in schema objects.

References

Snowflake Documentation. (n.d.). Schemas. In SQL Reference > Data Definition Language (DDL) > Schema DDL. Retrieved from https://docs.snowflake.com/en/sql-reference/ddl-schema

Snowflake Documentation. (n.d.). Overview of Databases, Tables and Views. In Introduction to Snowflake. Retrieved from https://docs.snowflake.com/en/user-guide/tables-databases-views-overview

Snowflake Documentation. (n.d.). Understanding Snowflake's Object Hierarchy. In Introduction to Snowflake > Key Concepts & Architecture. Retrieved from https://docs.snowflake.com/en/user-guide/intro-key-concepts#understanding-snowflake-s-object-hierarchy

Question 1 of 10

Source context

How this practice set is maintained

Maintained by the CertMage content team, this page loads questions from the exam dataset connected to its preparation resource. When an answer includes a supporting reference, it is shown with that answer so you can review the underlying vendor documentation.

Certification objectives, interfaces, and vendor services can change. Verify important details against the provider's current exam guide and documentation before your exam.

Continue practicing