Snowflake
COF-R02 · 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?
The correct answer is D. Query against the metadata excite. See the full explanation below for the reasoning.
Question
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?
Options
- AQuery against the result set cache
- BQuery against a virtual warehouse cache
- CQuery against the most-recently created micro-partition
- DQuery against the metadata excite
How the community answered
(64 responses)- A6% (4)
- B3% (2)
- C13% (8)
- D78% (50)
Community Discussion
No community discussion yet for this question.