COF-C02 Free Practice Test

- (Topic 4)
What information is found within the Statistic output in the Query Profile Overview?

1. A. Operator tree
2. B. Table pruning
3. C. Most expensive nodes
4. D. Nodes by execution time

Correct Answer: C
The Statistic output in the Query Profile Overview of Snowflake provides detailed insights into the performance of different parts of the query. Specifically, it highlightsthe "Most expensive nodes," which are the operations or steps within the query execution that consume the most resources, such as CPU and memory. Identifying these nodes helps in pinpointing performance bottlenecks and optimizing query execution by focusing efforts on the most resource-intensive parts of the query.
References:
✑ Snowflake Documentation on Query Profile Overview: It details the components of the profile overview, emphasizing how to interpret the statistics section to improve query performance by understanding which nodes are most resource-intensive.

- (Topic 2)
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

1. A. 10-50 MB
2. B. 100-250 MB
3. C. 300-500 MB
4. D. 1000-1500 MB

Correct Answer: B
For loading data into Snowflake via Snowpipe, the recommended compressed file size is between 100-250 MB. This size range is optimal for balancing the performance of parallel processing and minimizing the overhead associated with handling many small files2.

- (Topic 4)
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

1. A. Range of values
2. B. Distinct values
3. C. Index values
4. D. Sorted values
5. E. Null values

Correct Answer: AB
Snowflake stores metadata for rows in micro-partitions, including the range of values for each column and the number of distinct values1.

- (Topic 1)
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

1. A. Users
2. B. Tables
3. C. Databases
4. D. Internal Stages

Correct Answer: BCD
The Information Schema and Account Usage Share in Snowflake provide metadata and historical usage data for various objects within a Snowflake account. Specifically, they offer storage information for Tables, Databases, and Internal Stages. These schemas contain views and table functions that allow users to query object metadata and usage metrics, such as the amount of data stored and historical activity.
✑ Tables: The storage information includes data on the daily average amount of data in database tables.
✑ Databases: For databases, the storage usage is calculated based on all the data contained within the database, including tables and stages.
✑ Internal Stages: Internal stages are locations within Snowflake for temporarily storing data, and their storage usage is also tracked.
References: The information is verified according to the SnowPro Core Certification Study Guide and Snowflake documentation

- (Topic 5)
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

1. A. There are multiple SOL UDFs with the same names and the same number of arguments.
2. B. There are multiple SQL UDFs with the same names and the same number of argument types.
3. C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.
4. D. There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Correct Answer: C
In Snowflake, overloading refers to the creation of multiple User-Defined
Functions (UDFs) with the same name but differing in the number or types of their arguments. This feature allows for more flexible function usage, as Snowflake can differentiate between functions based on the context of their invocation, such as the types or the number of arguments passed. Overloading helps to create more adaptable and readable code, as the same function name can be used for similar operations on different types of data.
References:
✑ Snowflake Documentation: User-Defined Functions