Answer: Query Profile

The Query Profile is Snowflake's primary tool for troubleshooting SQL query performance bottlenecks. It provides detailed execution plans, statistics, and performance metrics that help identify issues like inefficient joins, data skew, or resource-intensive operations. The community discussion shows 100% consensus on answer D, with upvoted comments emphasizing that Query Profile allows users to analyze execution plans and identify performance characteristics. While other options have different purposes: Persisted query results (A) caches results for reuse but doesn't help troubleshoot bottlenecks; QUERY_HISTORY view (B) shows historical query metadata but lacks detailed execution analysis; Query acceleration service (C) improves performance automatically but doesn't provide troubleshooting insights.

Author: LeetQuiz Editorial Team