COF-C03 Practice Questions

In the Snowflake Data Exchange, the ability to get or request data from listings is generally controlled by specific roles and privileges:

A.  

D.  

A directory table is a special Snowflake-managed table that stores metadata about unstructured data files (such as images, videos) in a stage.

It supports automatic metadata refresh .

It enables listing and querying file-level details .

Snowflake supports a variety of subquery types, including both correlated and uncorrelated subqueries. The correct answers are B and E, which highlight Snowflake ' s flexibility in handling subqueries within SQL queries.

Uncorrelated Scalar Subqueries:These are subqueries that can execute independently of the outer query. They return a single value and can be used anywhere a value expression is allowed, offering great flexibility in SQL queries.

EXISTS, ANY/ALL, and IN Subqueries:These subqueries are used inWHEREclauses to filter the results of the main query based on the presence or absence of matching rows in a subquery. Snowflake supports both correlated and uncorrelated versions of these subqueries, providing powerful tools for complex data analysis scenarios.

Examples and Usage:

Uncorrelated Scalar Subquery:

SELECT*FROMemployeesWHEREsalary > (SELECTAVG(salary)FROMemployees);

Correlated EXISTS Subquery:

SELECT*FROMorders oWHEREEXISTS(SELECT1FROMcustomer cWHEREc.id = o.customer_idANDc.region = ' North America ' );

The correct answers are

A.  

Snowflake automatically gathers and maintains metadata about micro-partitions. This metadata includes information such as the range of values in columns, distinct value counts, and other statistics. Snowflake uses this metadata to optimize query execution and table operations.

Why A is correct:

Query pruning is one of the most important uses of micro-partition metadata. Snowflake can skip micro-partitions that do not contain values needed by a query predicate.

Example:

SELECT *

FROM sales

WHERE sale_date = ' 2026-01-01 ' ;

If Snowflake knows from micro-partition metadata that certain micro-partitions do not contain sale_date = ' 2026-01-01 ' , those micro-partitions can be skipped.

Why E is correct:

DML operations such as UPDATE, DELETE, and MERGE can also benefit from micro-partition metadata. Snowflake can use metadata to identify which micro-partitions are affected by the operation instead of scanning unnecessary partitions.

Why the other options are incorrect:

B.  

C.  

D.  

Official Snowflake documentation reference:

Snowflake documentation explains that micro-partition metadata is used for efficient query pruning and optimization. It also supports efficient table maintenance and DML operations by helping Snowflake identify relevant micro-partitions.

Snowflake warehouses can use different warehouse types and resource constraints. Snowpark-optimized warehouses use warehouse properties such as WAREHOUSE_TYPE and RESOURCE_CONSTRAINT to define the compute configuration.

Snowflake ' s access control framework utilizes a combination of Discretionary Access Control (DAC) and Role-based Access Control (RBAC). DAC in Snowflake allows the object owner to grant access privileges to other roles. RBAC involves assigning roles to users and then granting privileges to those roles. Through roles, Snowflake manages which users have access to specific objects and what actions they can perform, which is central to security and governance in the Snowflake environment.