Snowpro Core · Free Practice Question Medium

Question 90

The Query Processing Layer can run multiple compute clusters (virtual warehouses) simultaneously. Which statement is true regarding how the compute clusters access data?
  • A Each virtual warehouse gets a complete copy of all data.
  • B Each virtual warehouse gets a portion of the data.
  • C Each virtual warehouse accesses the same shared data.
Reveal correct answer

Correct answer: C

Explanation

Snowflake stores data similarly to a shared-disk architecture, i.e., the data is shared. But it also allows for using several compute engines on the same shared data, each with its own memory and processing capabilities. https://docs.snowflake.com/en/user-guide/intro-key-concepts#snowflake-architecture

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need