SnowPro Core Certification — Question 914

What is the purpose of a Query Profile?

Answer options

• A. To profile how many times a particular query was executed and analyze its usage statistics over time.
• B. To profile a particular query to understand the mechanics of the query, its behavior, and performance.
• C. To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
• D. To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Correct answer: B

Explanation

The correct answer is B because a Query Profile is designed to analyze the mechanics and performance of a specific query. Options A, C, and D focus on different aspects of query execution and user interaction, which do not align with the primary intent of a Query Profile.