Answer-first summary for fast verification
Answer: To profile a particular query to understand the mechanics of the query, its behavior, and performance.
The Query Profile in Snowflake is specifically designed to analyze the execution details of a particular query, including its mechanics, behavior, and performance characteristics. Option B directly aligns with this purpose, as confirmed by the community discussion where all participants (100%) selected B, with explanations emphasizing that Query Profile helps understand query mechanics, performance, and behavior. Option A describes query usage statistics over time, which is more aligned with Query History. Option C describes user/role profiling and privilege analysis, which is handled by Access History and other security features. Option D describes warehouse utilization analysis, which is covered by Warehouse Metering History and other monitoring tools.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the purpose of a Query Profile in Snowflake?
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.