
Answer-first summary for fast verification
Answer: It provides a graphic representation of the main components of the query processing.
The correct answer is B because the Snowflake query profiler's primary characteristic is providing a graphical representation of the main components of query processing. This is clearly documented in Snowflake's official documentation and confirmed by the community discussion with multiple upvoted comments referencing the documentation. Option A is incorrect as there is no 100-query weekly limit. Option C is incorrect because while the profiler shows query statistics, it doesn't specifically identify which queries use the most compute resources - that's more the function of query history or resource monitors. Option D is incorrect because the query profiler is a UI feature in Snowflake's web interface, not an API for third-party software.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a characteristic of the Snowflake query profiler?
A
It can provide statistics on a maximum number of 100 queries per week.
B
It provides a graphic representation of the main components of the query processing.
C
It provides detailed statistics about which queries are using the greatest number of compute resources.
D
It can be used by third-party software using the query profiler API.
No comments yet.