COF-C02 Free Practice Test

- (Topic 2)
When cloning a database, what is cloned with the database? (Choose two.)

1. A. Privileges on the database
2. B. Existing child objects within the database
3. C. Future child objects within the database
4. D. Privileges on the schemas within the database
5. E. Only schemas and tables within the database

Correct Answer: AB
When cloning a database in Snowflake, the clone includes all privileges on the database as well as existing child objects within the database, such as schemas, tables, views, etc. However, it does not include future child objects or privileges on schemas within the database2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 5)
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake (VPS)

Correct Answer: D
The Virtual Private Snowflake (VPS) edition offers the highest level of security for organizations with the strictest security requirements. This edition provides a dedicated and isolated instance of Snowflake, including enhanced security features and compliance certifications to meet the needs of highly regulated industries or any organization requiring the utmost in data protection and privacy.
References:
✑ Snowflake Documentation: Snowflake Editions

- (Topic 6)
Who can activate a network policy for users in a Snowflake account? (Select TWO)

1. A. ACCOUNTADMIN
2. B. USERADMIN
3. C. PUBLIC
4. D. SYSADMIN
5. E. Any role that has the global ATTACH POLICY privilege

Correct Answer: AE
Network policies in Snowflake are used to control access to Snowflake accounts based on IP address ranges. These policies can be activated by specific roles that have the necessary privileges.
✑ Role: ACCOUNTADMIN:
✑ Role with Global ATTACH POLICY Privilege:
References:
✑ Snowflake Documentation: Network Policies

- (Topic 6)
Which views are included in the data_sharing_usage schema? (Select TWO).

1. A. ACCESS_HISTORY
2. B. DATA_TRANSFER_HISTORY
3. C. WAREHOUSE_METERING_HISTORY
4. D. MONETIZED_USAGE_DAILY
5. E. LISTING TELEMETRY DAILY

Correct Answer: DE
https://docs.snowflake.com/en/sql-reference/data-sharing-usage

- (Topic 2)
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

1. A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
2. B. The transient table version cannot be retrieved after 24 hours.
3. C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
4. D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Correct Answer: A
To go back to the first version of a transient table created three days prior,
one can use Time Travel if the DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days. This allows the user to access historical data within the specified retention period. References: [COF-C02] SnowPro Core Certification Exam Study Guide