COF-C03 Exam Dumps - SnowPro Core Certification 2026 Exam

The correct answer is D. ACCOUNT_USAGE.TABLE_STORAGE_METRICS .

ACCOUNT_USAGE.TABLE_STORAGE_METRICS provides detailed storage metrics for tables, including active bytes, Time Travel bytes, Fail-safe bytes, and retained-for-clone bytes. This view is more detailed for table-level storage than SHOW TABLES or DESC TABLE.

Why D is correct:

TABLE_STORAGE_METRICS is designed specifically to report table-level storage usage.

Why the other options are incorrect:

A. SHOW TABLES provides table metadata, but not the most detailed storage breakdown.

B. DESC TABLE describes the table structure, such as columns and data types, not detailed storage consumption.

C. ACCOUNT_USAGE.STORAGE_USAGE provides account-level storage usage, not the most detailed table-level storage metrics.

Official Snowflake documentation reference:

Snowflake documentation describes ACCOUNT_USAGE.TABLE_STORAGE_METRICS as a view that provides storage information for tables, including active, Time Travel, Fail-safe, and retained-for-clone storage.

The correct answer is B. RETURN_ROWS .

Corrected typo:

Option D contains a typing error. RETURN_ALL_ERRORSs should be RETURN_ALL_ERRORS .

When using COPY INTO < location > to unload data, VALIDATION_MODE = RETURN_ROWS returns the query results instead of unloading them to files. This is useful for validating the result set that would be unloaded.

Why B is correct:

RETURN_ROWS is the validation mode used with unload operations to return rows generated by the query.

Example:

COPY INTO @my_stage/output/

FROM (

SELECT *

FROM customers

)

VALIDATION_MODE = RETURN_ROWS;

Why the other options are incorrect:

A. RETURN_ < n > _ROWS is associated with validation behavior for loading data, not the unload query result validation mode.

C. RETURN_ERRORS returns errors and is used for validating data load errors. It does not return query results.

D. RETURN_ALL_ERRORS returns all errors in validation mode for loading scenarios. It does not return the unload query result set.

Official Snowflake documentation reference:

Snowflake documentation for COPY INTO < location > describes VALIDATION_MODE = RETURN_ROWS as returning the rows that would be unloaded.

System tags help enable data classification for governance, privacy, and compliance. For example, Snowflake uses system-defined tags like SNOWFLAKE.CORE.DATA_CLASSIFICATION to detect and label sensitive data (e.g., PII, financial info).

The correct answer is C. A new cluster will be started.

A multi-cluster warehouse in Auto-scale mode can automatically start additional clusters when query concurrency increases. This allows Snowflake to handle more concurrent users and queries without forcing all queries to wait on a single cluster.

Why C is correct:

When the current cluster does not have enough capacity to handle the number of concurrent queries, Snowflake can start another cluster, up to the configured maximum cluster count. This helps reduce queuing and improves concurrency.

Why the other options are incorrect:

A. Queued queries are not dropped simply because concurrency exceeds the current cluster’s capacity.

B. The warehouse does not shut down because of high concurrency.

D. Queries are not automatically redirected to another warehouse. Multi-cluster scaling occurs within the same virtual warehouse.

Official Snowflake documentation reference:

Snowflake documentation explains that multi-cluster warehouses can automatically start and stop additional clusters to manage query concurrency. In Auto-scale mode, Snowflake starts additional clusters as needed, up to the maximum number configured for the warehouse.

The correct answer is C. HEADER = TRUE .

When unloading data with the COPY INTO < location > command, the HEADER option specifies whether column names should be included in the output file.

Why C is correct:

HEADER = TRUE includes column headings in the unloaded file output.

Example:

COPY INTO @my_stage/output/

FROM my_table

FILE_FORMAT = (TYPE = PARQUET)

HEADER = TRUE;

Important note for exam review:

For CSV unloads, HEADER = TRUE includes column names in the first row. For Parquet unloads, Snowflake can use column names in the Parquet output metadata/schema when the header option is enabled.

Why the other options are incorrect:

A. PARSE_HEADER is a file format option used when loading CSV data with inferred column names. It is not the unload option for including headers.

B. SKIP_HEADER is used when loading files to skip header rows. It does not include headers during unloading.

D. This syntax is not the correct Snowflake unload option for column headers.

Official Snowflake documentation reference:

Snowflake documentation for COPY INTO < location > describes the HEADER option as specifying whether to include table column headings in the output files.