COF-C02 Free Practice Test

- (Topic 4)
Which object can be used with Secure Data Sharing?

1. A. View
2. B. Materialized view
3. C. External table
4. D. User-Defined Function (UDF)

Correct Answer: A
Views can be used with Secure Data Sharing in Snowflake. Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.

- (Topic 1)
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

1. A. STATEMENT_TIMEOUT IN SECONDS
2. B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
3. C. MAX_CONCURRENCY LEVEL
4. D. QUERY_TIMEOUT_IN_SECONDS

Correct Answer: B
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 https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement- Timeout- Parameters#:~:text=The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECO NDS sets the,indefinitely in the waiting queue.

- (Topic 6)
What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

1. A. The ACCCUKTMKIN role should be set as tie user's default role.
2. B. The user should use federated authentication instead of a password
3. C. The user should be required to use Multi-Factor Authentication (MFA).
4. D. There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

Correct Answer: C
For users assigned theACCOUNTADMINrole, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. TheACCOUNTADMIN role has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise.References:Snowflake Security Best Practices

- (Topic 1)
Which cache type is used to cache data output from SQL queries?

1. A. Metadata cache
2. B. Result cache
3. C. Remote cache
4. D. Local file cache

Correct Answer: B
TheResult cache is used in Snowflake to cache the data output from SQL queries. This feature is designed to improve performance by storing the results of queries for a period of time. When the same or similar query is executed again, Snowflake can retrieve the result from this cache instead of re-computing the result, which saves time and computational resources.
References:
✑ Snowflake Documentation on Query Results Cache
✑ SnowPro® Core Certification Study Guide

- (Topic 2)
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

1. A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
2. B. Scaling out adds clusters of varying sizes to a virtual warehouse.
3. C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
4. D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
5. E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
6. F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Correct Answer: AE
Scaling out in Snowflake involves adding clusters of the same size to a virtual warehouse, which allows for handling more concurrent queries without affecting the performance of individual queries. Scaling up refers to resizing a virtual warehouse to increase its compute resources, enabling it to handle more complex workloads and larger queries more efficiently.