Snowflake Updated SOL-C01 Exam Questions and Answers by bruno

Semi-structured data like JSON stored in a VARIANT column can be queried directly usingpath notation, either dot notation or bracket notation.

Examples:

Dot notation:SELECT data:customer.name FROM table;

Bracket notation:SELECT data['customer']['name'] FROM table;

Snowflake automatically interprets the JSON structure, making relational extraction unnecessary. Complex fields can be accessed through functions such as FLATTEN, OBJECT_KEYS, ARRAY_SIZE, and TYPEOF.

Incorrect options:

Converting JSON to a relational table is optional, not required.

Stored procedures are not necessary for JSON querying.

WHERE on the full VARIANT cannot precisely extract fields.

Thus, path notation is the native, efficient method.

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

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.

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

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.

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