- (Topic 4)
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

1. A. Warehouses that are multi-cluster can have nodes of different sizes.
2. B. Warehouses can be started and stopped at any time.
3. C. Warehouses can be resized at any time, even while running.
4. D. Warehouses are billed on a per-minute usage basis.
5. E. Warehouses can only be used for querying and cannot be used for data loading.

Correct Answer: BC
Virtual warehouses in Snowflake can be started and stopped at any time, providing flexibility in managing compute resources. They can also be resized at any time, even while running, toaccommodate varying workloads910. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (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 1)
Which account usage views are used to evaluate the details of dynamic data masking? (Select TWO)

1. A. ROLES
2. B. POLICY_REFERENCES
3. C. QUERY_HISTORY
4. D. RESOURCE_MONIT ORS
5. E. ACCESS_HISTORY

Correct Answer: BE
To evaluate the details of dynamic data masking,
the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used. The POLICY_REFERENCES view provides information about the objects to which a masking policy is applied, and the ACCESS_HISTORY view contains details about access to the masked data, which can be used to audit and verify the application of
dynamic data masking policies.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Dynamic Data Masking1

- (Topic 5)
If a virtual warehouse runs for 61 seconds, shut down, and then restart 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: C
Snowflake bills virtual warehouse usage in one-minute increments, rounding up to the nearest minute for any partial minute of compute time used. If a virtual warehouse runs for 61 seconds and then, after being shut down, restarts and runs for an additional 30 seconds, the total time billed would be 120 seconds or 2 minutes. The first 61 secondsare rounded up to 2 minutes, and the subsequent 30 seconds are within a new minute, which is also rounded up to the nearest minute.
References:
✑ Snowflake Documentation: Virtual Warehouses Billing

- (Topic 4)
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

1. A. Tags
2. B. Comments
3. C. Internal tokenization
4. D. Row access policies

Correct Answer: A
Tags in Snowflake allow users to track sensitive data for compliance, discovery, protection, and resource usage. They enable the categorization and tracking of data, supporting compliance with privacy regulations678. References: [COF-C02] SnowPro Core Certification Exam Study Guide