COF-C02 Snowflake Exam Questions and Free Practice Test

Question 31

- (Topic 3)
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

E. grant SELECT on all tables in database DB1 to role MYROLE;

F. grant SELECT on future tables in database DB1 to role MYROLE;

Correct Answer:CD
To grant a role the privilege to select data from all current and future tables in a schema, two separate commands are needed. The first command grants the SELECT privilege on all existing tables within the schema, and the second command grants the SELECT privilege on all tables that will be created in the future within the same schema.

Question 32

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

A. When creating a table

B. When loading data into a table

C. When unloading data from a table

D. When executing a show command

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.

Question 33

- (Topic 6)
Snowflake users can create a resource monitor at which levels? (Select TWO).

A. User level

B. Pipe level

C. Account level

D. Cloud services level

E. Virtual warehouse level

Correct Answer:CE
Resource monitors in Snowflake are tools used to track and control the consumption of compute resources, ensuring that usage stays within defined limits. These monitors can be created at the account level, allowing administrators to set overall resource consumption limits for the entire Snowflake account. Additionally, resource monitors can be set at the virtual warehouse level, enabling more granular control over the resources consumed by individual warehouses. This dual-level capability allows organizations to manage their Snowflake usage efficiently, preventing unexpected costs and optimizing performance.References:Snowflake Documentation on Resource Monitors Top of Form

Question 34

- (Topic 3)
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A. A directory table is a separate database object.

B. Directory tables store data file metadata.

C. A directory table will be automatically added to a stage.

D. Directory tables do not have their own grantable privileges.

E. Directory table data can not be refreshed manually.

Correct Answer:BD
Directory tables in Snowflake are used to store metadata about data files in a stage. They are not separate database objects but are conceptually similar to external tables. Directory tables do not have grantable privileges of their own

Question 35

- (Topic 6)
Which function determines the kind of value stored in a VARIANT column?

A. CHECK_JSON

B. IS_ARRAY

C. IS_JSON

D. TYPEOF

Correct Answer:D
The function used to determine the kind of value stored in a VARIANT column in Snowflake is TYPEOF.
✑ Understanding VARIANT Data Type:
✑ Using TYPEOF Function:
✑ Example Usage:
SELECT TYPEOF(variant_column) FROM my_table;
✑ uk.co.certification.simulator.questionpool.PList@4255ce8d
✑ Benefits:
References:
✑ Snowflake Documentation: TYPEOF
✑ Snowflake Documentation: VARIANT Data Type

Question 36

- (Topic 2)
What happens to historical data when the retention period for an object ends?

A. The data is cloned into a historical object.

B. The data moves to Fail-safe

C. Time Travel on the historical data is dropped.

D. The object containing the historical data is dropped.

Correct Answer:C
When the retention period for an object ends in Snowflake, Time Travel on the historical data is dropped ©. This means that the ability to access historical data via Time Travel is no longer available once the retention period has expired2.

START COF-C02 EXAM