Question 160
A performance owner wants to identify which expensive SQL statements consumed warehouse time last week. The proposed response is: Analyze query history and attributed workload details using available monitoring views. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
Elapsed query time is not always identical to a precise per-statement invoice amount. It qualifies the proposed action: analyze query history and attributed workload details using available monitoring views.
Incorrect Answers
A custom role name conveys no special privilege unless explicit grants and inheritance provide it. This is a trade-off for the separate proposal: adopt a least-privilege custom role hierarchy and keep sensitive account roles for appropriate administration. The proposed choice instead requires acknowledging this risk: elapsed query time is not always identical to a precise per-statement invoice amount.
Network restrictions do not replace user authentication or fine-grained table access control. This is a trade-off for the separate proposal: configure and test an appropriate Snowflake network policy at the required scope. The proposed choice instead requires acknowledging this risk: elapsed query time is not always identical to a precise per-statement invoice amount.
A monitoring alert does not itself enforce a credit budget or recover a failed pipeline. This is a trade-off for the separate proposal: create an appropriate Snowflake alert or notification mechanism for the measurable condition. The proposed choice instead requires acknowledging this risk: elapsed query time is not always identical to a precise per-statement invoice amount.





SnowPro Core COF-C03 Practice Tests