QUESTION: 93

A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT SALES;
How did Snowflake fulfill this query?

Query against the result set cache
Query against a virtual warehouse cache
Query against the most-recently created micro-partition
Query against the metadata excite

Answer(s): D

Reveal Solution Next Question

QUESTION: 94

Which cache type is used to cache data output from SQL queries?

Metadata cache
Result cache
Remote cache
Local file cache

Answer(s): B

Reference:

https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Reveal Solution Next Question

QUESTION: 95

What is a key feature of Snowflake architecture?

Zero-copy cloning creates a mirror copy of a database that updates with the original
Software updates are automatically applied on a quarterly basis
Snowflake eliminates resource contention with its virtual warehouse implementation
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Answer(s): D

Reveal Solution Next Question

QUESTION: 96

What is a limitation of a Materialized View?

A Materialized View cannot support any aggregate functions
A Materialized View can only reference up to two tables
A Materialized View cannot be joined with other tables
A Materialized View cannot be defined with a JOIN

Answer(s): D

Explanation:

There are several limitations to using materialized views: A materialized view can query only a single table. Joins, including self-joins, are not supported.

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 25)

QUESTION: 93

QUESTION: 94

Reference:

QUESTION: 95

QUESTION: 96

Explanation:

COF-R02 Discussions & Posts