QUESTION: 85

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values
Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
Smaller micro-partitions are created for common data values to allow for more parallelism
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Answer(s): D

Reveal Solution Next Question

QUESTION: 86

Which feature is only available in the Enterprise or higher editions of Snowflake?

Column-level security
SOC 2 type II certification
Multi-factor Authentication (MFA)
Object-level access control

Answer(s): A

Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html

Reveal Solution Next Question

QUESTION: 87

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

SCIM
Federated authentication
TLS 1.2
Key-pair authentication
OAuth
OCSP authentication

Answer(s): B,D,E

Reveal Solution Next Question

QUESTION: 88

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_TIMEOUT IN SECONDS
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
MAX_CONCURRENCY LEVEL
QUERY_TIMEOUT_IN_SECONDS

Answer(s): B

Explanation:

The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue

Reference:

https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout- Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets% 20the,indefinitely%20in%20the%20waiting%20queue.

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 22)

QUESTION: 85

QUESTION: 86

Reference:

QUESTION: 87

QUESTION: 88

Explanation:

Reference: