Snowflake Updated COF-C02 Exam Questions and Answers by arlen

The TABLE_STORAGE_METRICS view in Snowflake provides details about table storage, including owned storage (storage exclusively used by the table) and referenced storage (shared storage due to cloning or Time Travel).

This view helps distinguish between data directly owned by the table and data shared with other tables through features like cloning.

Why Other Options Are Incorrect:

A. DATABASE_STORAGE_USAGE_HISTORY: Tracks storage usage at the database level, not specific to tables or cloning.

B. STAGE_STORAGE_USAGE_HISTORY: Tracks storage usage for stages, not tables.

D. STORAGE_USAGE: Provides high-level account storage details, not specific to cloning or tables.

References:

TABLE_STORAGE_METRICS Documentation

In Snowflake, the term "privilege" refers to a defined level of access to an object. Privileges are specific actions that roles can perform on securable objects in Snowflake, such as tables, views, warehouses, databases, and schemas. These privileges are granted to roles and can be further granted to users through their roles, forming the basis of Snowflake’s access control framework.References: Snowflake Documentation on Access Control Privileges

The minimum Snowflake edition that supports database replication is the Enterprise edition. Database replication allows data to be replicated between different Snowflake accounts or regions, providing high availability and disaster recovery capabilities.

References:

Snowflake Documentation: Database Replication

Snowpipe uses key-based authentication for its REST endpoints. This involves generating and using a key pair (public and private keys) to securely authenticate API requests.

Generate Key Pair: Generate a public and private key pair.

Register Public Key: Register the public key with the Snowflake user that will be making the API requests.

Authenticate Requests: Use the private key to sign API requests sent to Snowpipe REST endpoints.

References:

Snowflake Documentation: Key Pair Authentication & Key Rotation

Snowflake Documentation: Using Snowpipe REST API