Câu 17: DEA-C02: SnowPro Advanced Data Engineer DEA-C02
A Data Engineer ran this command:ALTER WAREHOUSE my_wh SET -ENABLE_QUERY_ACCELERATION = trueQUERY_ACCELERATION_MAX_SCALE_FACTORThe warehouse is now consuming more credits than expected. What could be causing this to occur, and what action will reduce the credit consumption?
Nội dung câu hỏi
A Data Engineer ran this command:ALTER WAREHOUSE my_wh SET -ENABLE_QUERY_ACCELERATION = trueQUERY_ACCELERATION_MAX_SCALE_FACTORThe warehouse is now consuming more credits than expected. What could be causing this to occur, and what action will reduce the credit consumption?
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. The scale factor is switched off (set to 0). A value must be set to initiate the query acceleration service.
- B. The query acceleration service is being applied to all queries in my_wh. Configure load sharing with a virtual warehouse that is not using the query acceleration service.
- C. The queries running against my_wh are consuming as many resources as necessary. Set a scale factor to reduce credit consumption. — đáp án hiện tại
- D. The query acceleration service costs are based on the entire time the warehouse is active. Identify additional queries to run against my_wh to reduce credit consumption.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.
Chưa có bình luận. Mở giao diện tương tác để bắt đầu thảo luận.