COF-C02 Free Practice Test

- (Topic 1)
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X- Small Warehouse.

1. A. True
2. B. False

Correct Answer: A
Provisioning time can vary based on the size of the warehouse. A 4X-Large Warehouse typically has more resources and may take longer to provision compared to a X-Small Warehouse, which has fewer resources and can generally be provisioned more quickly.References: Understanding and viewing Fail-safe | Snowflake Documentation

- (Topic 3)
Which statement MOST accurately describes clustering in Snowflake?

1. A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
2. B. Clustering is the way data is grouped together and stored within Snowflake micro- partitions.
3. C. The clustering key must be included in the COPY command when loading data into Snowflake.
4. D. Clustering can be disabled within a Snowflake account.

Correct Answer: B
Clustering in Snowflake refers to the organization of data within micro- partitions, which are contiguous units of storage within Snowflake tables. Clustering keys can be defined to co-locate similar rows in the same micro-partitions, improving scan efficiency and query performance12.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
How does Snowflake utilize clustering information to improve query performance?

1. A. It prunes unnecessary micro-partitions based on clustering metadata.
2. B. It compresses the data within micro-partitions for faster querying.
3. C. It automatically allocates additional resources to improve query execution.
4. D. It organizes clustering information to speed-up data retrieval from storage

Correct Answer: A
Snowflake utilizes clustering information to enhance query performance by pruning unnecessary micro-partitions.
✑ Clustering Metadata: Snowflake stores clustering information for each micro- partition, which includes data range and distribution.
✑ Pruning Micro-partitions: When a query is executed, Snowflake uses this clustering metadata to identify and eliminate micro-partitions that do not match the query criteria, thereby reducing the amount of data scanned and improving query performance.
References:
✑ Snowflake Documentation on Clustering
✑ Snowflake Documentation on Micro-partition Pruning

- (Topic 2)
Users are responsible for data storage costs until what occurs?

1. A. Data expires from Time Travel
2. B. Data expires from Fail-safe
3. C. Data is deleted from a table
4. D. Data is truncated from a table

Correct Answer: B
Users are responsible for data storage costs in Snowflake until the data expires from the Fail-safe period. Fail-safe is the final stage in the data lifecycle, following Time Travel, and provides additional protection against accidental data loss. Once data exits the Fail-safe state, users are no longer billed for its storage

- (Topic 3)
Which REST API can be used with unstructured data?

1. A. inscrtFilcs
2. B. insertReport
3. C. GET /api/tiles/
4. D. loadHistoryScan

Correct Answer: C
The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves (downloads) a data file from an internal or external stage4.