COF-C02 Free Practice Test

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

1. A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.
2. B. The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
3. C. The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
4. 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.

- (Topic 3)
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

1. A. Table definition
2. B. Stage definition
3. C. Session level
4. D. COPY INTO TABLE statement

Correct Answer: D
When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1

- (Topic 3)
Which of the following can be used when unloading data from Snowflake? (Choose two.)

1. A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
2. B. Use the ENCODING file format option to change the encoding from the default UTF-8.
3. C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi- structured data.
4. D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
5. E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Correct Answer: CD
The OBJECT_CONSTRUCT function is used in Snowflake to create a JSON object from relational data, which is useful when unloading semi-structured data. The SINGLE = TRUE parameter is used when unloading data to ensure that the data is exported as a single file, which can be up to 5 GB in size. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 4)
What tasks can an account administrator perform in the Data Exchange? (Select TWO).

1. A. Add and remove members.
2. B. Delete data categories.
3. C. Approve and deny listing approval requests.
4. D. Transfer listing ownership.
5. E. Transfer ownership of a provider profile.

Correct Answer: AC
An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests. These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.

- (Topic 1)
What is the default character set used when loading CSV files into Snowflake?

1. A. UTF-8
2. B. UTF-16
3. C. ISO S859-1
4. D. ANSI_X3.A

Correct Answer: A
https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For delimited files (CSV, TSV,encoding to use for loading.
For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).