COF-C02 Free Practice Test

- (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

- (Topic 3)
Which user object property requires contacting Snowflake Support in order to set a value for it?

1. A. DISABLED
2. B. MINS TO BYPASS MFA
3. C. MINS TO BYPASS NETWORK POLICY
4. D. MINS TO UNLOCK

Correct Answer: B
The user property ??MINS TO BYPASS MFA?? in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.

- (Topic 2)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a
Large warehouse?

1. A. 4
2. B. 8
3. C. 16
4. D. 32

Correct Answer: B
In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2.
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

- (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 statements describe benefits of Snowflake's separation of compute and storage?
(Select TWO).

1. A. The separation allows independent scaling of computing resources.
2. B. The separation ensures consistent data encryption across all virtual data warehouses.
3. C. The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
4. D. Storage volume growth and compute usage growth can be tightly coupled.
5. E. Compute can be scaled up or down without the requirement to add more storage.

Correct Answer: AE
Snowflake??s architecture allows for the independent scaling of compute resources, meaning you can increase or decrease the computational power as needed without affecting storage. This separation also means that storage can grow independently of compute usage, allowing for more flexible and cost-effective data management.