Size Warehouses and Use Query Pruning DEA-C02 Practice Questions (Page 4)

Questions 16–17

1. 16foundation · easy

   Which warehouse sizing strategy is most appropriate for a workload with predictable, steady concurrency and a need for consistent query performance?

   • AUse a multi-cluster warehouse with a wide range between MIN and MAX clusters.
   • BUse a multi-cluster warehouse with MIN set to 1 and MAX set to 10.
   • CUse the smallest warehouse size possible and rely on query pruning to improve performance.
   • DUse a single, fixed-size warehouse sized to handle the peak concurrency.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which metric from the Query Profile indicates how well query pruning is working?

   • ANumber of credits consumed by the query
   • BElapsed time of the query
   • CPercentage of data scanned from the table
   • DTotal number of rows returned by the query
   Reveal Solution Discussion Select an answer first