Câu 20: SnowPro Core COF-C03
A reporting dashboard uses a dedicated warehouse that auto-suspends after five minutes of idle time. Similar queries run sporadically with gaps exceeding five minutes. Users notice the first query after suspension takes significantly longer than subsequent queries while the warehouse stays active. How should query per…
Nội dung câu hỏi
A reporting dashboard uses a dedicated warehouse that auto-suspends after five minutes of idle time. Similar queries run sporadically with gaps exceeding five minutes. Users notice the first query after suspension takes significantly longer than subsequent queries while the warehouse stays active. How should query performance be improved?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Set the MIN_CLUSTER_COUNT equal to the MAX_CLUSTER_COUNT.
- B. Increase the warehouse size to X-Large.
- C. Use ALTER WAREHOUSE to increase the STATEMENT_TIMEOUT_IN_SECONDS.
- D. Increase the AUTO_SUSPEND setting. — đáp án hiện tại
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.