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?

Question

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

BETTE SLETTER · Accepted Answer

Query against the metadata excite

BETTE SLETTER · Answer

Query against the result set cache

BETTE SLETTER · Answer

Query against a virtual warehouse cache

BETTE SLETTER · Answer

Query against the most-recently created micro-partition

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 93 - COF-R02 discussion

Suggested answer: D

0 comments