Question 50
An administrator needs historical query patterns by user, warehouse, and error state over the last reporting period. The team proposes this action: Analyze supported QUERY_HISTORY account usage information and relevant query identifiers. Why should that action address the stated requirement?
Explanation
Correct Answer
Query-history telemetry associates statements with execution metadata useful for troubleshooting. This explains the proposed action: analyze supported QUERY_HISTORY account usage information and relevant query identifiers.
Incorrect Answers
VARIANT and path expressions support semi-structured navigation, while casts control resulting SQL types. That rationale explains parse supported JSON into VARIANT and extract fields with appropriate casts. It does not establish the mechanism needed here: query-history telemetry associates statements with execution metadata useful for troubleshooting.
Different optimizations target different query patterns and incur different maintenance costs. That rationale explains benchmark the representative SQL shapes and compare the optimization's compute and storage trade-offs. It does not establish the mechanism needed here: query-history telemetry associates statements with execution metadata useful for troubleshooting.
Snowflake does not promise reuse of a persisted result after the underlying result-relevant data changes. That rationale explains retest result cache eligibility after the source-data change instead of assuming reuse. It does not establish the mechanism needed here: query-history telemetry associates statements with execution metadata useful for troubleshooting.





SnowPro Core COF-C03 Practice Tests