Last Attempt SOL-C01 Questions

TheCOPY INTOcommand is Snowflake’s primary bulk-loading mechanism for ingesting data from stages (internal or external) into tables. It can read from Amazon S3, Azure Blob Storage, Google Cloud Storage, or internal Snowflake stages. COPY INTO supports file formats (CSV, JSON, Parquet), pattern matching, error handling, transformations, and validation modes.

PUT uploads filesfrom a local machineto an internal stage—not from stage to table.

GET downloads files from an internal stage to a local system.

INSERT INTO is for row-by-row inserts and is not designed for large file ingestion.

Therefore, COPY INTO is the correct and recommended method for loading stage files into Snowflake tables.

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

Snowflake Cortex AI provides built-in AI functions and tools designed to work natively with unstructured and structured data. Two key capabilities are:

• Extract and classify text using functions like PARSE_DOCUMENT, EXTRACT_TEXT, and classification models. Cortex can process documents, identify relevant fields, and convert unstructured content into usable structured formats.

• Simplify unstructured data workflows by combining document extraction, vector search, summarization, and AI reasoning tools (e.g., Cortex Analyst, Cortex Search) directly inside Snowflake without external services.

It does not provide Marketplace data sharing features, which belong to Snowflake’s Data Sharing platform. Loading semi-structured data is a core Snowflake capability using VARIANT and COPY INTO—not Cortex-specific. Enhancing data security is a platform-wide feature, not a Cortex function.

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

Aprivate listingis shared only with explicitly selected Snowflake accounts, giving providers fine-grained control over who can access their data. This is ideal for partner organizations, internal business units, or customers requiring restricted access. Apublic listing, on the other hand, is accessible to all Snowflake users via the Marketplace, making it available for broad distribution. Pricing models for both types can be free or paid; neither category inherently requires payment. Both listing types share data, not code. Public listings are not restricted to Snowflake employees—they are open to the entire Snowflake ecosystem. The distinction lies entirely in access scope: targeted (private) vs. universal (public).

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

In Snowflake Notebooks, agreen checkmarkis a visual indicator that the cell hassuccessfully executed, meaning the computation completed without errors and results are available. This helps users verify execution state quickly across multi-step workflows.

Other visual states include:

A spinning icon for cells that are currently executing

A red error symbol for failed executions

Plain, unmarked cells that have not yet run

Snowflake Notebooks support SQL and Python cells with integrated compute, output visualization, and cell-level execution state tracking. There is no “paused” state for notebook cells.

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