Free Practice Questions for Snowflake SOL-C01 Exam

Answer : C

Data listings in the Snowflake Marketplace can be offered asfree or paiddepending on how the provider chooses to distribute the data. Providers can use usage-based pricing, subscription models, or make datasets available at no cost. Listings are not restricted to static data; Snowflake supportslive data sharing, enabling instant access to continuously updated datasets without copying or ETL. Listings are accessible to any Snowflake user with the appropriate marketplace access---not exclusively administrators. This flexibility makes the Marketplace a powerful ecosystem where organizations can seamlessly obtain external datasets for analytics, machine learning, and reporting needs. Providers define terms of use, pricing, and refresh schedules, while Snowflake manages the secure data-sharing infrastructure.

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

Answer : B

InSnowsight, the Query History user interface retains and displays executed query information for up to14 days. This includes query text, status, start/end timestamps, duration, warehouse usage, and result statistics. Snowsight also offers grouping by session, user, warehouse, and time windows for detailed analytics and troubleshooting.

It is important to distinguish Snowsight UI limits from SQL-based history functions. The table functionINFORMATION_SCHEMA.QUERY_HISTORY()returns only7 daysof history, whereas Snowsight visually retains 14 days. Snowflake's Account Usage views (e.g., QUERY_HISTORY) retain data for longer periods but are meant for programmatic auditing rather than UI display.

Incorrect options:

7 days refers only to Information Schema.

21 or 28 days are not supported by Snowsight's UI.

Thus, the correct visibility window in the Snowsight interface is14 days.

Answer : D

Snowflake uses the SQL command CREATE WAREHOUSE warehouse_name to create a new virtual warehouse. Warehouses provide the compute resources for executing SQL queries, loading data, and performing transformations. When creating a warehouse, additional parameters may be specified, such as warehouse size, auto-suspend timeout, auto-resume, scaling policy, or multi-cluster mode. The options involving ''CREATE VIRTUALWAREHOUSE'' are invalid syntax in Snowflake. CREATE DATABASE and CREATE SCHEMA create storage containers, not compute resources. Therefore, CREATE WAREHOUSE is the only correct command for provisioning compute.

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

Answer : D

Time Travel enables Snowflake users to query, clone, or restore historical versions of data. This includes retrieving previous states of tables, schemas, or databases---even after updates, deletes, or drops. Time Travel operates within a retention period (default: 1 day, up to 90 days on higher editions).

Users can query historical data using the AS OF or BEFORE clause, restore dropped objects, and clone databases at specific points in time for backup or analysis.

Time Travel doesnotautomatically manage timestamp data types. It does not guarantee indefinite recovery---after the retention window expires, data moves into Fail-safe. It also is not primarily designed for loading historical datasets; its purpose is to access past states of Snowflake-managed data.

Thus, the correct purpose is to enable access to historical data inside Snowflake.

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

Answer : A, D

Snowflake's multi-cluster shared data architecture enablesindependent scaling of compute and storage, meaning workloads can be sized differently without affecting stored data.

It also providesnear-unlimited concurrency, because Snowflake can automatically add compute clusters during peak loads.

Snowflake does not require manual infrastructure management and runs fully in the cloud---not on-premises. Multi-cloud support reduces vendor lock-in, not increases it.

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