Free COF-R02 Exam Braindumps (page: 23)

Page 22 of 83

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

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

Answer(s): D



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

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

Answer(s): A


Reference:

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



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

  1. SCIM
  2. Federated authentication
  3. TLS 1.2
  4. Key-pair authentication
  5. OAuth
  6. OCSP authentication

Answer(s): B,D,E



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

  1. STATEMENT_TIMEOUT IN SECONDS
  2. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  3. MAX_CONCURRENCY LEVEL
  4. 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.






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts