SnowPro Advanced: Architect Practice Questions

SnowPro Advanced: Architect (ARA-C01) exam preparation

SnowPro Advanced: Architect practice questions in English: 171 questions with explanations. The mock exam has 65 questions and 115 minutes.

SnowPro Advanced: Architect free question 10 / 10 · Domain 4: Performance Optimization

Query acceleration is enabled on the multi-cluster warehouse WH_BI (size LARGE, 8 credits per hour per cluster, MAX_CLUSTER_COUNT = 3), with QUERY_ACCELERATION_MAX_SCALE_FACTOR set to 4. According to the official documentation, what is the upper limit, in additional credits per hour, on the cost of the compute resources this warehouse can borrow for query acceleration?

  1. 32 credits
  2. 96 credits
  3. 40 credits
  4. 12 credits
Show the answer and explanation

Answer: A

Why this is correct
The scale factor is a cost limit that sets the maximum compute resources a warehouse can lease for query acceleration, and it works as a multiplier applied to the warehouse size and cost. The documentation's example says that with a MEDIUM warehouse (4 credits per hour) and a scale factor of 5, the cost of the resources leased is at most 20 additional credits per hour. The scale factor applies to the entire warehouse, whether it is single-cluster or multi-cluster. For a LARGE warehouse of 8 credits, 8 times 4 gives 32 credits as the limit, regardless of the number of clusters.

Why the other options are wrong
"12 credits" … This is the scale factor of 4 multiplied by the number of clusters, 3. The scale factor is a multiplier on the warehouse size and cost, not on the number of clusters.
"40 credits" … In the documentation's example, a scale factor of 5 gives 4 x 5 = 20 additional credits; the original warehouse cost is not added on to make six times. Here, too, it is 8 x 4, not the 8 x 5 that gives 40.
"96 credits" … The documentation says the scale factor applies to the entire warehouse. Counting 8 x 4 for each cluster and tripling it would stack the limit that applies to the whole warehouse once per cluster.

Key point
For a multi-cluster warehouse, the documentation suggests considering raising the scale factor so that all clusters can benefit. Query acceleration is billed by the second, only while it is used, and separately from warehouse usage. The cost is the same regardless of how many queries use it at the same time.

Go to the SnowPro Advanced: Architect practice app (10 free questions; purchase unlocks all questions)

See the full practice set