COF-C03 Exam Questions & Answers

The CLONE command creates a zero-copy clone of an existing table, schema, or database. At the time the clone is created, the source object and clone reference the same existing micro-partitions.

The clone initially requires no separate physical copy of the underlying table data. As either object changes, new or modified micro-partitions are associated with the object that was changed. Changes to the clone do not modify the source table, and changes to the source table do not modify the clone.

A view stores a query definition rather than a snapshot of table data. COPY INTO unloads data to a stage, and GRANT provides access to an object.

Snowflake Documentation --- Cloning considerations:

https://docs.snowflake.com/en/user-guide/object-clone

Snowflake SQL Reference --- CREATE TABLE ... CLONE:

https://docs.snowflake.com/en/sql-reference/sql/create-clone

==

The correct answer is A. The table data does not require Fail-safe.

Transient tables are designed for data that does not need the same level of data recovery protection as permanent tables. Unlike permanent tables, transient tables do not have a Fail-safe period.

Why A is correct:

Fail-safe storage can add cost because Snowflake retains historical data for recovery by Snowflake support after the Time Travel retention period ends. Since transient tables do not have Fail-safe, they can reduce storage costs for data that does not require this additional protection.

Common use cases include:

Temporary ETL data

Staging data

Intermediate transformation data

Reproducible data

Non-critical working data

Why the other options are incorrect:

B . Long-term critical storage is usually better suited for permanent tables because they support Fail-safe.

C . Frequent access and modification alone does not make a transient table the best cost choice. The key factor is whether Fail-safe is needed.

D . Sharing data with external accounts is not the primary cost-effective use case for transient tables.

Official Snowflake documentation reference:

Snowflake documentation explains that transient tables persist until explicitly dropped, support Time Travel with limited retention, and do not have a Fail-safe period.

==

Granting a user the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses in Snowflake is equivalent to granting the global MANAGE WAREHOUSES privilege. These privileges collectively provide comprehensive control over virtual warehouses.

MODIFY Privilege:

Allows users to change the configuration of the virtual warehouse.

Includes resizing, suspending, and resuming the warehouse.

MONITOR Privilege:

Allows users to view the status and usage metrics of the virtual warehouse.

Enables monitoring of performance and workload.

OPERATE Privilege:

Grants the ability to start and stop the virtual warehouse.

Includes pausing and resuming operations as needed.

:

Snowflake Documentation: Warehouse Privileges