Free Snowflake COF-C02 Exam Dumps

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.

TABLE_STORAGE_METRICS Documentation

Owner's Rights Stored Procedures:

When a stored procedure with owner's rights is called, it runs with the privileges of the owner, not the caller.

This ensures that the procedure executes with access to objects the owner has privileges for, regardless of the caller's permissions.

Why Other Options Are Incorrect:

B . The owner can set the caller's session variables: Stored procedures cannot modify session variables of the caller.

C . The owner will inherit the caller's current virtual warehouse: The procedure uses the session's current warehouse, not inherited settings.

D . The owner can view the caller's session variables: Session variables are private to the caller and not visible to the owner.

Stored Procedure Privileges Documentation