Snowflake Updated SOL-C01 Exam Questions and Answers by ayrton

Snowflake supports bothTOPandLIMITas valid SQL mechanisms for restricting the number of rows returned by a query. They function similarly but are used in different syntactic positions.

LIMITappears at the end of the query:

SELECT * FROM my_table LIMIT 10;

This tells Snowflake to return only the specified number of rows.

TOPis used in the SELECT clause:

SELECT TOP 10 * FROM my_table;

Both approaches are equivalent in functionality and are supported to maintain compatibility with ANSI SQL and other SQL dialects.

The other options are not correct row-limiting mechanisms:

•SELECTis a required keyword but does not limit rows on its own.

•GETis not a SQL keyword for row restriction; GET is used for downloading files from internal stages.

•ROW_NUMBERis a window function used for ranking rows, not constraining row count.

Therefore, TOP and LIMIT are the only correct SQL keywords in Snowflake for controlling how many rows are returned by a query.

==================

The Public schema is created by default within every Snowflake database and serves primarily as a shared workspace that is accessible to all users who have the necessary privileges. One of its main roles is to act as adefault schemafor objects created without explicitly specifying a schema name. This ensures usability and prevents object creation errors when users forget to define a schema. Additionally, the Public schema is commonly used to storeshared or common resourcesthat multiple users or teams need to access. However, it should not be used for sensitive or user-specific data because access can be broad. It does not store account-level metadata; that information resides in INFORMATION_SCHEMA views or account-level metadata functions. Overall, the Public schema acts as both a convenient default location and a shared-access area within a Snowflake database.

=======================================

PARSE_DOCUMENT extracts text and, depending on mode, layout information from supported document formats. The function currently supportsPDF,PPTX, andDOCXfiles. For PDFs, it can perform OCR to extract scanned text or use LAYOUT mode to detect tables and structured regions. For PPTX files, it extracts slide text and content. For DOCX files, the function captures text and applies layout analysis. XLSX files are not supported—Excel content requires different extraction methods. PARSE_DOCUMENT enables automated document intelligence workflows entirely inside Snowflake, eliminating the need for external OCR or parsing services.

=======================================

Snowsight is the default web-based interface for Snowflake. It provides a graphical, browser-based environment to write and run SQL and Python, manage and explore database objects, create visualizations and dashboards, monitor query and warehouse activity, and collaborate via worksheets. It has replaced the Classic Console as the default UI for new Snowflake accounts.

SnowSQL is a command-line client used to connect to Snowflake from a terminal and execute SQL statements. Snowpark is a developer framework that supports writing data applications in languages like Python, Java, and Scala, but it is not a UI. “Snowflake CLI” refers to command-line tooling and automation utilities, again not a graphical web interface.

==================