COF-C02 Free Practice Test

- (Topic 6)
Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

1. A. GET_RELATIVE_PATH
2. B. GET_PRESIGNED_URL
3. C. BUILD_STAGE_FILE_URL
4. D. BUILD_SCOPED_FILE_URL

Correct Answer: B
TheGET_PRESIGNED_URLfile function in Snowflake provides a URL with access to a file on a stage without requiring authentication and authorization. This is particularly useful for sharing data files stored in Snowflake stages with external parties securely and conveniently. The presigned URL generated by this function gives temporary access to the file, which expires after a specified duration.
Example usage ofGET_PRESIGNED_URL: SELECTGET_PRESIGNED_URL('','');
This function generates a URL that can be used to directly access a file in the stage, making it easier to share data without compromising security.
Reference: Snowflake Documentation on File and Table Functions, specifically the section
on GET_PRESIGNED_URL: https://docs.snowflake.com/en/sql- reference/functions/get_presigned_url.html
Top of Form

- (Topic 4)
What is the purpose of a Query Profile?

1. A. To profile how many times a particular query was executed and analyze its u^age statistics over time.
2. B. To profile a particular query to understand the mechanics of the query, its behavior, and performance.
3. C. To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
4. D. To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Correct Answer: B
The purpose of a Query Profile is to provide a detailed analysis of a particular query??s execution plan, including the mechanics, behavior, and performance. It helps in identifying potential performance bottlenecks and areas for optimization

- (Topic 6)
What are characteristics of Snowflake network policies? (Select TWO).

1. A. They can be set for any Snowflake Edition.
2. B. They can be applied to roles.
3. C. They restrict or enable access to specific IP addresses.
4. D. They are activated using ALTER DATABASE SQL commands.
5. E. They can only be managed using the ORGADMIN role.

Correct Answer: AC
Snowflake network policies are a security feature that allows administrators to control access to Snowflake by specifying allowed and blocked IP address ranges. These policies apply to all editions of Snowflake, making them widely applicable across different Snowflake environments. They are specifically designed to restrict or enable accessbased on the originating IP addresses of client requests, adding an extra layer of security. Network policies are not applied to roles but are set at the account or user level. They are not activated usingALTER DATABASESQL commands but are managed throughALTER ACCOUNTorALTER NETWORK POLICYcommands. The management of network policies does not exclusively require theORGADMINrole; instead, they can be managed by users with the necessary privileges on the account.
Reference: Snowflake Documentation on Network Policies:
https://docs.snowflake.com/en/user-guide/network-policies.html

- (Topic 1)
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

1. A. Pipes
2. B. Streams
3. C. Tasks
4. D. Procedures

Correct Answer: B
In Snowflake, Streams are the objects that track Data Manipulation Language (DML) changes made to tables, such as inserts, updates, and deletes. Streams record these changes along with metadata about each change, enabling actions to be taken using the changed data. This process is known as change data capture (CDC)2.

- (Topic 3)
How can a user change which columns are referenced in a view?

1. A. Modify the columns in the underlying table
2. B. Use the ALTER VIEW command to update the view
3. C. Recreate the view with the required changes
4. D. Materialize the view to perform the changes

Correct Answer: C
In Snowflake, to change the columns referenced in a view, the view must be recreated with the required changes. The ALTER VIEW command does not allow changing the definition of a view; it can only be used to rename a view, convert it to or from a secure view, or add, overwrite, or remove a comment for a view. Therefore, the correct approach is to drop the existing view and create a new one with the desired column references.