COF-C02 Free Practice Test

- (Topic 6)
Which role must be used to create resource monitors?

1. A. SECURITYADMIN
2. B. ACCOUNTADMIN
3. C. SYSADMIN
4. D. ORGADMIN

Correct Answer: B
In Snowflake, the ACCOUNTADMIN role is required to create resource monitors. Resource monitors are used to manage and monitor the consumption of compute resources. The ACCOUNTADMIN role has the necessary privileges to create, configure, and manage resource monitors across the account.
References:
✑ Snowflake Documentation: Resource Monitors

- (Topic 5)
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi- Factor Authentication (MFA) token valid for?

1. A. 1 hour
2. B. 2 hours
3. C. 4 hours
4. D. 8 hours

Correct Answer: C
A cached MFA token is valid for up to four hours.https://docs.snowflake.com/en/user-guide/security-mfa#using-mfa-token-caching-to-minimize-the-number-of-prompts-during-authentication-optional

- (Topic 4)
How should clustering be used to optimize the performance of queries that run on a very large table?

1. A. Manually re-cluster the table regularly.
2. B. Choose one high cardinality column as the clustering key.
3. C. Use the column that is most-frequently used in query select clauses as the clustering key.
4. D. Assess the average table depth to identify how clustering is impacting the query.

Correct Answer: B
For optimizing the performance of queries that run on a very large table, it is recommended to choose one high cardinality column as the clustering key. This helps to co-locate similar rows in thesame micro-partitions, improving scan efficiency in queries by skipping data that does not match filtering predicates4.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 1)
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

1. A. Informatica
2. B. Power Bl
3. C. Adobe
4. D. Data Robot

Correct Answer: D
Data Robot is recognized as a machine learning and data science partner within the Snowflake Partner Ecosystem. It provides an enterprise AI platform that enables users to build and deploy accurate predictive models quickly. As a partner, Data Robot integrates with Snowflake to enhance data science capabilities2.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Machine Learning & Data Science Partners
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

- (Topic 3)
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

1. A. 60
2. B. 91
3. C. 120
4. D. 121

Correct Answer: D
Snowflake??s billing for virtual warehouses is per-second, with a minimum of 60 seconds for each time the warehouse is started or resumed. Therefore, if a warehouse runs for 61 seconds, it is billed for 61 seconds. If it is then shut down and restarted, running for an additional 30 seconds, it is billed for another 60 seconds (the minimum charge for a restart), totaling 121 seconds2