Câu 28: SnowPro Core COF-C03
A dashboard query is running much slower than expected. The Query Profile shows a join operator consuming 70% of the total execution time and producing 1,000 times more rows than its input tables. What is causing this issue?
Nội dung câu hỏi
A dashboard query is running much slower than expected. The Query Profile shows a join operator consuming 70% of the total execution time and producing 1,000 times more rows than its input tables. What is causing this issue?
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 query is queuing because the warehouse has too many concurrent queries.
- B. The joined tables are not benefiting from efficient micro-partition pruning.
- C. The query is generating a cartesian product due to a missing or incorrect ON clause condition. — đáp án hiện tại
- D. The query is spilling data to remote storage because the warehouse is too small.
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.