Snowpro Core · Free Practice Question Easy
Question 69
What is the primary purpose of the query profile in Snowflake?
-
A
To automate the optimization of queries without user intervention
-
B
To provide additional execution details for query analysis and performance improvement
-
C
To manage user permissions and query access control
-
D
To visualize the storage allocation of virtual warehouses
Reveal correct answer
Correct answer: B
A.
The query profile provides information but does not automate query optimization; manual intervention based on the profile's insights is required.
B.
The query profile is a graphical tool that provides detailed execution information about a query. It helps identify bottlenecks, shows how much time was spent on various components, and provides insights that help improve query performance.
C.
Managing permissions and access control is not the function of the query profile; it’s the role of account and security administration tools.
D.
The query profile does not provide details about storage allocation for virtual warehouses; it focuses on query execution.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
