SnowPro Advanced Certification SOL-C01 Reddit Questions

Snowflake Notebooks currently support three primary cell types: SQL, Python, and Markdown. SQL cells allow users to execute SQL queries directly against Snowflake data. Python cells enable computation, data transformation, machine learning, and visualization using Snowpark, pandas-like APIs, and Python libraries. Markdown cells provide rich text formatting to document workflows, add explanations, and create readable narratives within the notebook.

Languages such as Java, Scala, and R are supported by Snowflake outside notebooks—for example, through Snowpark APIs or external integrations—but they cannot be used directly as Notebook cell types. Notebooks are designed to integrate SQL and Python seamlessly while providing a documentation layer, making SQL, Python, and Markdown the correct and only supported options.

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

A red checkmark in Snowflake Notebooks indicates that the cell encountered anerrorduring execution. This visual indicator helps users quickly identify issues so they can inspect the error message and adjust code accordingly. Successful execution shows a green checkmark, while running cells show a spinner. Snowflake notebooks do not include a “paused” state for notebook cells.

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

The correct SQL command for removing a schema in Snowflake is:

DROP SCHEMA temp_schema;

This command deletes the schema and all objects contained within it, including tables, views, stages, file formats, and sequences. Snowflake performs this operation atomically, ensuring metadata consistency during the drop process. Users can also includeIF EXISTSor theCASCADEkeyword to handle dependencies more explicitly:

DROP SCHEMA IF EXISTS temp_schema CASCADE;

This safely handles scenarios where the schema may not exist or contains objects that would normally block deletion.

Incorrect options:

DROP DATABASE temp_schemaremoves an entire database, not a schema.

DELETE SCHEMAis not valid SQL; SQL uses DROP for schema removal.

DROP VIEW temp_schemaapplies only to removing a view object.

Dropping a schema requires USAGE and OWNERSHIP privileges, typically granted to roles such as SYSADMIN or ACCOUNTADMIN.

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

Snowsight’s file-loading interface:

•Automatically detects data typesby inspecting column values.

•Loads (inserts) file contents directly into a table, either a new table or an existing one.

Snowsight does not automatically create permanent file formats, does not merge rows, and does not optimize warehouse-level performance.

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