Câu 11: SnowPro Core COF-C03

A user is investigating a slow-running query using the Query Profile. The profile shows a join operator that consumes 10,000 records from the left table and 5,000 records from the right table but produces 50,000,000 records as output. The join operator is consuming 95% of the total query execution time. What is causing this performance issue and how should it be fixed?

1. A. The warehouse is too small to handle the join operation efficiently. To fix the warehouse should be increased to size X-Large or larger.
2. B. The join is causing data to spill to the disk. To fix add more filters before the join to reduce the input data volume.
3. C. The query is causing data to spill to the disk. To fix add more filters before the join to reduce the input data volume.
4. D. The query has an exploding join caused by a missing join condition. To fix verify the join conditions in the query are specified correctly and sufficiently restrictive. — đáp án hiện tại