COF-C02 Free Practice Test

- (Topic 6)
Which Snowflake object contains all the information required to share a database?

1. A. Private listing
2. B. Secure view
3. C. Sequence
4. D. Share

Correct Answer: D
In Snowflake, aShareis the object that contains all the information required to share a database with other Snowflake accounts. Shares are used to securely share data stored in Snowflake tables and views, enabling data providers to grant data consumers access to their datasets without duplicating data. When a database is shared, it can include one or more schemas, and each schema can contain tables, views, or both.
References:
✑ Snowflake Documentation on Shares: Shares

- (Topic 5)
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

1. A. GET_STATE_LOCATION
2. B. GET_PRESENT_URL
3. C. BUILD_SCOPED_FILE_URL
4. D. BUILD_STAGE_FILE_URL

Correct Answer: D
✑ Purpose:TheBUILD_STAGE_FILE_URLfunction generates a temporary, pre- signed URL that allows you to access a file within a Snowflake stage (internal or external). This URL requires authentication to use.
✑ Key Points:
✑ Snowflake Documentation
(BUILD_STAGE_FILE_URL): https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url.html

- (Topic 1)
How long is Snowpipe data load history retained?

1. A. As configured in the create pipe settings
2. B. Until the pipe is dropped
3. C. 64 days
4. D. 14 days

Correct Answer: C
Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the data load operations performed by Snowpipe over a significant period of time, which can be crucial for troubleshooting and ensuring data integrity.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Snowpipe1

- (Topic 3)
What is a responsibility of Snowflake??s virtual warehouses?

1. A. Infrastructure management
2. B. Metadata management
3. C. Query execution
4. D. Query parsing and optimization
5. E. Permanent storage of micro-partitions

Correct Answer: C
Snowflake??s virtual warehouses are responsible for query execution. They are clusters of compute resources that execute SQL statements, perform DML operations, and load data into tables

- (Topic 1)
Which services does the Snowflake Cloud Services layer manage? (Select TWO).

1. A. Compute resources
2. B. Query execution
3. C. Authentication
4. D. Data storage
5. E. Metadata

Correct Answer: CE
The Snowflake Cloud Services layer manages a variety of services that are crucial for the operation of the Snowflake platform. Among these services, Authentication and Metadata management are key components. Authentication is essential for controlling access to the Snowflake environment, ensuring that only authorized users can perform actions within the platform. Metadata management involves handling all the metadata related to objects within Snowflake, such as tables, views, and databases, which is vital for the organization and retrieval of data.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation12 https://docs.snowflake.com/en/user-guide/intro-key-concepts.html