COF-C02 Free Practice Test

- (Topic 6)
A user wants to access stored in a stage without authenticating into Snowflake. Which type of URL should be used?

1. A. File URL
2. B. Staged URL
3. C. Scoped URL
4. D. Pre-signed URL

Correct Answer: D
A pre-signed URL provides a way to access objects stored in a stage without requiring authentication to Snowflake. This URL contains all the necessary information for access control, including an expiration time, and it??s signed by the service's credentials. This mechanism allows users or applications to access specific files stored in a cloud storage location (stage) directly, bypassing the need to authenticate into Snowflake, ensuring secure and temporary access to the data.References:Snowflake Documentation on Stages and Data Loading

- (Topic 2)
Which file formats are supported for unloading data from Snowflake? (Choose two.)

1. A. Avro
2. B. JSON
3. C. ORC
4. D. XML
5. E. Delimited (CSV, TSV, etc.)

Correct Answer: BE
Snowflake supports unloading data in JSON and delimited file formats such as CSV and TSV. These formats are commonly used for data interchange and are supported by Snowflake for unloading operations

- (Topic 4)
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

1. A. USERADMIN
2. B. ORGADMIN
3. C. SYSADMIN
4. D. SECURITYADMIN

Correct Answer: D
The SECURITYADMIN role in Snowflake can manage any object grant globally, including modifying and revoking grants. This role has the necessary privileges to oversee and control access to all securable objects within the Snowflake environment4.

- (Topic 5)
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

1. A. Temporary table
2. B. External table
3. C. Secure view
4. D. Materialized view

Correct Answer: D
A materialized view in Snowflake is a database object derived from a query specification, stored for later use, and can significantly speed up expensive aggregations on large data sets. Materialized views store the result of their underlying query, reducing the need to recompute the result each time the view is accessed. This makes them ideal for improving the performance of read-heavy, aggregate-intensive queries.
References:
✑ Snowflake Documentation: Using Materialized Views

- (Topic 4)
What factors impact storage costs in Snowflake? (Select TWO).

1. A. The account type
2. B. The storage file format
3. C. The cloud region used by the account
4. D. The type of data being stored
5. E. The cloud platform being used

Correct Answer: AC
The factors that impact storage costs in Snowflake include the account type (Capacity or On Demand) and the cloud region used by the account. These factors determine the rate at which storage is billed, with different regions potentially having different rates3.