Snowflake SnowPro Core Certification COF-C02 Exam Practice Test

Answer : A, C

Snowflake supports storing unstructured data and provides native support for semi-structured file formats such as JSON, Avro, Parquet, ORC, and XML1. GeoJSON, being a type of JSON, and XML are among the formats that can be stored in Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide

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 highlights the '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.

Answer : C

Automatic Clustering is a feature that allows users to control the organization of data within micro-partitions in Snowflake.By defining clustering keys, Snowflake can automatically reorganize the data in micro-partitions to optimize query performance1.

Answer : A

A directory table in Snowflake is an implicit object layered on a stage, whether internal or external. It allows users to query the contents of a stage as if it were a table, providing metadata about the files stored in the stage, such as filenames, file sizes, and last modified timestamps.

References:

Snowflake Documentation: Directory Tables

Answer : B

In Snowflake, stored procedures and User-Defined Functions (UDFs) have different invocation patterns within SQL:

Option B is correct: A single executable statement can call only one stored procedure due to the procedural and potentially transactional nature of stored procedures. In contrast, a single SQL statement can call multiple UDFs because UDFs are designed to operate more like functions in traditional programming, where they return a value and can be embedded within SQL queries. References: Snowflake documentation comparing the operational differences between stored procedures and UDFs.

Answer : D, E

Answer : B

The maximum Time Travel retention period for a temporary Snowflake table is 1 day.This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window