SnowPro Core Certification — Question 359

What is a characteristic of the Snowflake query profiler?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer, B, highlights the query profiler's ability to visually represent key components of query processing, which aids in understanding performance. Option A is incorrect as it misstates the capabilities regarding query statistics. Option C, while accurate about resource usage, does not describe the graphic representation aspect, and option D focuses on API access rather than the profiler's primary function.