Free COF-C02 Exam Dumps

Question 86

- (Topic 2)
Which statement is true about running tasks in Snowflake?

A. A task can be called using a CALL statement to run a set of predefined SQL commands.
B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
C. A task allows a user to execute a set of SQL commands on a predefined schedule.
D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct Answer:B
In Snowflake, a task allows a user to execute a single SQL statement/command using a predefined schedule (B). Tasks are used to automate the execution of SQL statements at scheduled intervals.

Question 87

- (Topic 2)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
B. Allows a user to import the files in a sequential order
C. Increases the latency staging and accuracy when loading the data
D. Allows optimization of parallel operations

Correct Answer:D
Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing. Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process

Question 88

- (Topic 6)
Which function can be used with the copy into statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

A. FLATTEN
B. OBJECT_AS
C. OBJECT_CONSTRUCT
D. TO VARIANT

Correct Answer:D
The correct function to use with theCOPY INTO <location>statement to convert rows from a relational table into a single variant column and to unload rows into a JSON file isTO VARIANT. TheTO VARIANTfunction is used to explicitly convert a value of any supported data type into a VARIANT data type. This is particularly useful when needing to aggregate multiple columns or complex data structures into a single JSON-formatted string, which can then be unloaded into a file.
In the context of unloading data, theCOPY INTO statement combined withTO VARIANTenables the conversion of structured data from Snowflake tables into a semi- structured VARIANT format, typically JSON, which can then be efficiently exported and stored. This approach is often utilized for data integration scenarios, backups, or when data needs to be shared in a format that is easily consumed by various applications or services that support JSON.
References:
✑ Snowflake Documentation on Data Unloading: Unloading Data
✑ Snowflake Documentation on VARIANT Data Type: Working with JSON

Question 89

- (Topic 3)
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
* 1. Created a user called "CONSUMER"
* 2. Created a database to hold the share and an extra-small warehouse to query the data
* 3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?

A. The reader account will automatically use the Standard edition of Snowflake.
B. The reader account compute will be billed to the provider account.
C. The reader account can clone data the provider has shared, but cannot re-share it.
D. The reader account can create a copy of the shared data using CREATE TABLE AS...

Correct Answer:B
The reader account compute will be billed to the provider account.
Very Comprehensive Explanation
In Snowflake, when a provider creates a reader account for a consumer who does not have a Snowflake account, the compute resources used by the reader account are billed to the provider??s account. This allows the consumer to query the shared data without incurring any costs. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 90

- (Topic 6)
If a virtual warehouse is suspended, what happens to the warehouse cache?

A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.
B. The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
C. The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
D. The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Correct Answer:A
When a virtual warehouse in Snowflake is suspended,the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.