SnowPro Advanced: Architect — Question 99

An Architect is troubleshooting a query with poor performance using the QUERY_HISTORY function. The Architect observes that the COMPILATION_TIME is greater than the EXECUTION_TIME.

What is the reason for this?

Answer options

• A. The query is processing a very large dataset.
• B. The query has overly complex logic.
• C. The query is queued for execution.
• D. The query is reading from remote storage.

Correct answer: B

Explanation

The correct answer is B because overly complex logic in a query can lead to increased compilation time as the system works harder to optimize the execution plan. Options A, C, and D do not directly relate to the issue of compilation time being greater than execution time, as they address different aspects of query performance.