DEA-C02 Performance Optimization Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Queuing will decrease because the Economy policy optimizes cluster distribution.

  Why it's wrong here

  This statement is incorrect because the Economy policy is designed to be more conservative, not more aggressive. It actually increases the likelihood of queuing by delaying the start of new clusters until it is certain they will be fully utilized, prioritizing financial efficiency over the immediate reduction of wait times.

• ✓

  Queuing will increase because the warehouse waits longer to start a new cluster.

  Why this is correct

  The Economy policy only starts a new cluster if it estimates there is enough work to keep it busy for at least six minutes. This delay is intended to prevent the frequent starting and stopping of clusters to save credits, but it directly results in longer queue times for users.

• ✗

  Performance will remain identical but the total credit consumption will decrease.

  Why it's wrong here

  Performance cannot remain identical if the scaling policy changes. The Economy policy inherently affects performance by making different decisions about when to add compute capacity. While it does aim to reduce credit consumption, it does so at the direct expense of increased query latency and potentially longer queuing.

• ✗

  The warehouse will automatically scale up to a larger T-shirt size.

  Why it's wrong here

  Scaling policies in Multi-cluster Warehouses only control the number of clusters (scaling out), not the size of the individual nodes (scaling up). Changing from Standard to Economy has no impact on the T-shirt size of the warehouse, which must be adjusted manually or via a different automation script.