What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?
What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?
A . Run homogenous queries on the same warehouse
B. Run heterogenous queries on the same warehouse
Answer: A
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#how-does-query-compositio n-impact-warehouse-processing
To achieve the best results, try to execute relatively homogeneous queries (size, complexity, data sets, etc.) on the same warehouse; executing queries of widely-varying size and/or complexity on the same warehouse makes it more difficult to analyze warehouse load, which can make it more difficult to select the best size to match the size, composition, and number of queries in your workload.
Latest ARA-C01 Dumps Valid Version with 156 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund