QUESTION: 145

What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer(s): B

QUESTION: 146

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Yes, because a table owner has full control and can unset masking policies.
Yes, because masking policies only apply to cloned tables.
No, because masking policies must always reference specific access roles.
No, because ownership of a table does not include the ability to change masking policies

Answer(s): A

Reveal Solution Next Question

QUESTION: 147

Which of the following describes how clustering keys work in Snowflake?

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
Clustering keys sort the designated columns over time, without blocking DML operations
Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Answer(s): B

Reveal Solution Next Question

QUESTION: 148

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica
Power Bl
Adobe
Data Robot

Answer(s): D

Reference:

https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 38)

QUESTION: 145

QUESTION: 146

QUESTION: 147

QUESTION: 148

Reference:

COF-R02 Discussions & Posts