A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the…

Question

Options

• ACreate a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the
• BCreate a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-
• CCreate a standard X-Large warehouse, which is equivalent to four small clusters. Set the
• DCreate four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-

• A
  9% (4)
• B
  73% (33)
• C
  4% (2)
• D
  13% (6)

Explanation

A multi-cluster warehouse is a virtual warehouse that consists of multiple clusters of compute resources that can scale up or down automatically to handle the concurrency and performance needs of the queries submitted to the warehouse. A multi-cluster warehouse has a minimum and maximum number of clusters that can be specified by the administrator. Option B is the most efficient way to support the group of users, as it allows the administrator to create a multi-cluster warehouse with MIN_CLUSTERS set to 2, which means that the warehouse will always have two clusters running to handle the standard workload. The warehouse can also auto-scale up to the maximum number of clusters (which can be set according to the peak workload) when there is a spike in demand, and then scale down when the demand decreases. The warehouse can also auto-resume and auto-suspend, which means that the warehouse will automatically start when a query is submitted and automatically stop after a period of inactivity. The administrator can also give USAGE privileges to the ANALYST role, which means that the users can use the warehouse to execute queries and load data, but not modify or operate the warehouse.

No community discussion yet for this question.