COF-C02 Free Practice Test

- (Topic 6)
Which command is used to remove files from either external cloud storage or an internal staged

1. A. DELETE
2. B. REMOVE
3. C. TRUNCATE
4. D. DROP

Correct Answer: B
The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage costs.
References:
✑ Snowflake Documentation: REMOVE Command

- (Topic 5)
Which use case does the search optimization service support?

1. A. Disjuncts (OR) in join predicates
2. B. LIKE/ILIKE/RLIKE join predicates
3. C. Join predicates on VARIANT columns
4. D. Conjunctions (AND) of multiple equality predicates

Correct Answer: D
The search optimization service in Snowflake supports use cases involving conjunctions (AND) of multiple equality predicates. This service enhances the performance of queries that include multiple equality conditions by utilizing search indexes to quickly filter data without scanning entire tables or partitions. It's particularly beneficial for improving the response times of complex queries that rely on specific data matching across multiple conditions.
References:
✑ Snowflake Documentation: Search Optimization Service

- (Topic 1)
Which statement about billing applies to Snowflake credits?

1. A. Credits are billed per-minute with a 60-minute minimum
2. B. Credits are used to pay for cloud data storage usage
3. C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
4. D. Credits are consumed based on the warehouse size and the time the warehouse is running

Correct Answer: D
Snowflake credits are the unit of measure for the compute resources used in Snowflake. The number of credits consumed depends on the size of the virtual warehouse and the time it is running. Larger warehouses consume more credits per hour than smaller ones, and credits are billed for the time the warehouse is active, regardless of the actual usage within that time.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 5)
Which Snowflake layer is associated with virtual warehouses?

1. A. Cloud services
2. B. Query processing
3. C. Elastic memory
4. D. Database storage

Correct Answer: B
The layer of Snowflake's architecture associated with virtual warehouses is the Query Processing layer. Virtual warehouses in Snowflake are dedicated compute clusters that execute SQL queries against the stored data. This layer is responsible for the entire query execution process, including parsing, optimization, and the actual computation. It operates independently of the storage layer, enabling Snowflake to scale compute and storage resources separately for efficiency and cost-effectiveness.
References:
✑ Snowflake Documentation: Snowflake Architecture

- (Topic 2)
In the Snowflake access control model, which entity owns an object by default?

1. A. The user who created the object
2. B. The SYSADMIN role
3. C. Ownership depends on the type of object
4. D. The role used to create the object

Correct Answer: D
In Snowflake??s access control model, the default owner of an object is the role that was used to create the object. This role has the OWNERSHIP privilege on the object and can grant access to other roles1