Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 7

How would a user run a multi-cluster warehouse in maximized mode?

In a Snowflake role hierarchy, what is the top-level role?

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Which SQL command can be used to see the CREATE definition of a masking policy?

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True or False: Pipes can be suspended and resumed.

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?