COF-C02 Free Practice Test

- (Topic 2)
What are common issues found by using the Query Profile? (Choose two.)

1. A. Identifying queries that will likely run very slowly before executing them
2. B. Locating queries that consume a high amount of credits
3. C. Identifying logical issues with the queries
4. D. Identifying inefficient micro-partition pruning
5. E. Data spilling to a local or remote disk

Correct Answer: DE
The Query Profile in Snowflake is used to identify performance issues with queries. Common issues that can be found using the Query Profile include identifying inefficient micro-partition pruning (D) and data spilling to a local or remote disk (E). Micro- partition pruning is related to the efficiency of query execution, and data spilling occurs when the memory is insufficient, causing the query to write data to disk, which can slow down the query performance1.

- (Topic 2)
Which of the following describes a Snowflake stored procedure?

1. A. They can be created as secure and hide the underlying metadata from the user.
2. B. They can only access tables from a single database.
3. C. They can contain only a single SQL statement.
4. D. They can be created to run with a caller's rights or an owner's rights.

Correct Answer: D
Snowflake stored procedures can be created to execute with the privileges of the role that owns the procedure (owner??s rights) or with the privileges of the role that calls the procedure (caller??s rights). This allows for flexibility in managing security and access control within Snowflake1.

- (Topic 3)
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

1. A. READ
2. B. OWNERSHIP
3. C. USAGK
4. D. WRTTF

Correct Answer: A
The minimum privilege required on an external stage for any role to access unstructured data files using a file URL in the GET REST API is READ. This allows the role to retrieve or download data files from the stage.

- (Topic 4)
For which use cases is running a virtual warehouse required? (Select TWO).

1. A. When creating a table
2. B. When loading data into a table
3. C. When unloading data from a table
4. D. When executing a show command
5. E. When executing a list command

Correct Answer: BC
Running a virtual warehouse is required when loading data into a table and when unloading data from a table because these operations require compute resources that are provided by the virtual warehouse23.

- (Topic 3)
Which kind of Snowflake table stores file-level metadata for each file in a stage?

1. A. Directory
2. B. External
3. C. Temporary
4. D. Transient

Correct Answer: A
The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table. A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.