COF-C02 Free Practice Test

- (Topic 3)
By definition, a secure view is exposed only to users with what privilege?

1. A. IMPORT SHARE
2. B. OWNERSHIP
3. C. REFERENCES
4. D. USAGE

Correct Answer: B
A secure view in Snowflake is exposed only to users with the OWNERSHIP privilege. This privilege ensures that only authorized users who own the view, or roles that include ownership, can access the secure view

- (Topic 3)
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

1. A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
2. B. A Data Exchange allows groups of accounts to share data privately among the accounts.
3. C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
4. D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
5. E. The sharing of data in a Data Exchange is bidirectiona
6. F. An account can be a provider for some datasets and a consumer for others.

Correct Answer: BE
A Snowflake Data Exchange allows groups of accounts to share data privately among the accounts (B), and it supports bidirectional sharing, meaning an account can be both a provider and a consumer of data (E). This facilitates secure and governed data collaboration within a selected group3.

- (Topic 6)
If a virtual warehouse is suspended, what happens to the warehouse cache?

1. A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.
2. B. The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
3. C. The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
4. D. The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Correct Answer: A
When a virtual warehouse in Snowflake is suspended,the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.

- (Topic 4)
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

1. A. A user with an USERADMIN or higher role
2. B. A user with a SECURITYADMIN or higher role
3. C. A role that has been granted the ATTACH POLICY privilege
4. D. A role that has the NETWORK_POLlCY account parameter set
5. E. A role that has the ownership of the network policy

Correct Answer: BE
In Snowflake, a user with the SECURITYADMIN role or higher can activate and enforce a network policy for all users in an account. Additionally, a role that has ownership of the network policy can also activate and enforce it

- (Topic 3)
What does Snowflake recommend regarding database object ownership? (Select TWO).

1. A. Create objects with ACCOUNTADMIN and do not reassign ownership.
2. B. Create objects with SYSADMIN.
3. C. Create objects with SECURITYADMIN to ease granting of privileges later.
4. D. Create objects with a custom role and grant this role to SYSADMIN.
5. E. Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Correct Answer: BD
Snowflake recommends creating objects with a role that has the necessary privileges and is not overly permissive. SYSADMIN is typically used for managing system- level objects and operations. Creating objects with a custom role and granting this role to SYSADMIN allows for more granular control and adherence to the principle of least privilege. References: Based on best practices for database object ownership and role management.