Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with CertsForce

The warehouse size does not change until all queries currently running in the warehouse have completed.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

The warehouse size does not change until the warehouse is suspended and restarted.

It does not return from the command until the warehouse has finished changing its size.

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

UPDATE TABLE FROM STREAM

SELECT FROM STREAM

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

BEGIN COMMIT

SHOW STORAGE BY TABLE;

SHOW TABLES;

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

Custom Edition

Virtual Private Snowflake

Business Critical Edition

Standard Edition

Enterprise Edition

VARIANT

VARRAY

STRUCT

ARRAY

QUEUE

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

Caching query results

Running EXPLAIN and SHOW commands

Cloning a database

Running a custom query

Running COPY commands

Standard

Enterprise

Business Critical

Virtual Private Snowflake

VIEWS_HISTORY

OBJECT_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY