Snowflake SOL-C01 Exam Questions

When auto-suspend is enabled on a virtual warehouse, Snowflake automatically suspends (stops) the warehouse after it has been idle for the configured period of time. Once suspended, the warehouse stops consuming compute credits, thereby reducing costs, since Snowflake bills only for active compute usage. When new queries arrive, auto-resume (if enabled) restarts the warehouse automatically.

Auto-suspend does not change the warehouse size; scaling up or down is a separate configuration. The warehouse is not dropped---its metadata and settings remain intact. Costs may be reduced and made more efficient but are not guaranteed to ''stabilize month-to-month,'' as the bill still depends on actual usage and workload patterns.

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

Semi-structured data refers to formats that do not follow a rigid relational schema but still contain structural tags or hierarchies, allowing flexible representation of nested or irregular data. In Snowflake,JSON,Parquet, andXMLare all considered semi-structured because they incorporate metadata, hierarchical fields, or tagged data that can vary across records. JSON offers key--value pairs and nested arrays, making it ideal for logs and API responses. Parquet, being a columnar file format containing both schema definitions and metadata, is optimized for analytics while still supporting semi-structured capabilities such as variable field nesting. XML uses tags and attributes to represent hierarchical content, making it semi-structured as well. On the other hand, CSV represents strictly structured, row/column-based data without inherent metadata or hierarchy, so it is not considered semi-structured. Snowflake treats semi-structured formats by loading them into the VARIANT data type, enabling powerful SQL-based exploration using path notation.

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

Unstructured data such as PDF files, images, and other binary documents is stored in stages in Snowflake. These stages may be internal stages, which Snowflake manages directly, or external stages, which reference external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. Stages are the designed mechanism for storing and accessing unstructured files so that they can be processed with functions like PARSE_DOCUMENT or accessed via directory tables.

External tables are used to query structured or semi-structured data (for example, Parquet or JSON) stored in external locations, not to store raw unstructured binary content. The Cloud Services layer coordinates metadata, security, and query services; it does not store user data. Tables with a single VARCHAR column might be used as an improvised approach for small text blobs, but this is not the native or recommended method for managing unstructured data at scale.

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

Snowsight supports two worksheet types:SQL worksheetsandPython worksheets. SQL worksheets allow users to execute queries, create objects, and perform data analysis using ANSI SQL and Snowflake-specific extensions. Python worksheets, powered by Snowpark, allow users to write Python code that interacts directly with Snowflake tables, data frames, and machine learning workflows.

Java, Scala, and JavaScript are supported via Snowpark APIs or UDF development, but they cannot be used as worksheet languages. Worksheets are designed for interactive analysis, visualization, and iterative development, with native runtimes only for SQL and Python.

Thus, only SQL and Python worksheets can be created within Snowsight.

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

The default Time Travel retention period for most objects in Snowflake is1 day(24 hours). Time Travel enables access to historical versions of data after updates, deletes, or drops. It also allows cloning databases, schemas, and tables at previous points in time, and recovering dropped objects.

While Snowflake Enterprise Edition and higher tiers allow retention periods up to 90 days, this extended window is not the default---administrators must explicitly configure it for each table, schema, or database.

Retention periods of 7, 45, or 90 days are possible only with higher service editions; the default for all accounts and objects remains 1 day unless explicitly overridden.

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