Câu 26: SnowPro Advanced Data Engineer

A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following: What step should the Engineer take to increase the query performance?

1. A. Add additional virtual warehouses.
2. B. Increase the size of the virtual warehouse. — đáp án hiện tại
3. C. Rewrite the query using Common Table Expressions (CTEs).
4. D. Change the order of the joins and start with smaller tables first.