COF-R02 Exam Dumps - Snowflake SnowPro Core Certification Questions and Answers

8-16 MB

16-24 MB

10-99 MB

100-250 MB

No virtual warehouse will be used, data will be read from the result cache.

No virtual warehouse will be used, data will be read from the local disk cache.

The default virtual warehouse will be used to read all data.

The virtual warehouse that is defined at the session level will be used to read all data.

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

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Metadata

Data Storage

Compute

Cloud Services

view @my_stage

list @my_stage

show @my_stage

display @my_stage

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

Named Stage

User Stage

Table Stage

Schema Stage