
Answer-first summary for fast verification
Answer: Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries., Scaling up resizes a virtual warehouse so it can handle more complex workloads.
The question asks to select two correct definitions of 'scale up' and 'scale out' in Snowflake. Option A correctly defines scaling out as adding clusters of the same size to a virtual warehouse to handle more concurrent queries, which aligns with Snowflake's multi-cluster warehouse feature. Option E correctly defines scaling up as resizing a virtual warehouse to handle more complex workloads, which refers to increasing the warehouse size (e.g., from X-Small to Large). Option B is incorrect because scaling out uses clusters of the same size, not varying sizes. Option C is incorrect as it misrepresents scaling out; Snowflake adds clusters, not database servers to an existing cluster. Option D is misleading; while both strategies can be used, Snowflake does not universally recommend using both—it depends on the workload. Option F is incorrect because scaling up resizes the warehouse, not adds servers to a cluster. The community discussion unanimously supports A and E with 100% consensus and upvotes, confirming these as the accurate definitions based on Snowflake documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What do the terms "scale up" and "scale out" refer to in Snowflake? (Choose two.)
A
Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
B
Scaling out adds clusters of varying sizes to a virtual warehouse.
C
Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
D
Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
E
Scaling up resizes a virtual warehouse so it can handle more complex workloads.
F
Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
No comments yet.