ExamGecko
Question list
Search
Search

Question 106 - COF-C02 discussion

Report
Export

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.
Answers
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.
Answers
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.
Answers
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.
Answers
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.
Answers
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.
Answers
F.
Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
Suggested answer: A, E

Explanation:

Scaling out in Snowflake involves adding clusters of the same size to a virtual warehouse, which allows for handling more concurrent queries without affecting the performance of individual queries. Scaling up refers to resizing a virtual warehouse to increase its compute resources, enabling it to handle more complex workloads and larger queries more efficiently.

asked 23/09/2024
Novy Kingra
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first