Question 50
An analytics engineering team reports this behavior: A BI dashboard stops accepting new SQL statements during a control-plane incident even though existing table files remain stored and a previously running query completes. Which underlying issue should be investigated first?
Explanation
Correct Answer
The described symptoms indicate that query compilation and authentication depend on cloud services rather than on storage alone. The appropriate resolution is: Investigate the cloud services layer and account status before modifying persisted table data. Confirm with: Service health recovers and a newly authenticated query compiles while stored records remain intact.
Incorrect Answers
Related key ranges overlap broadly across micro-partitions and reduce pruning efficiency. “Inspect clustering information and consider a justified clustering key for the observed access pattern” would address that alternative cause, not the condition in this question: query compilation and authentication depend on cloud services rather than on storage alone.
“Let Snowflake manage micro-partition storage and evaluate natural clustering through workload queries” responds to this separate finding: snowflake automatically organizes supported native table data into micro-partitions. This question instead needs “Investigate the cloud services layer and account status before modifying persisted table data”, so the alternative does not meet the stated condition.
Snowflake managed table storage is separate from the lifecycle of a particular warehouse. “Keep the table in managed database storage and query it through another authorized running warehouse” applies to that separate problem. The observed case is a BI dashboard stops accepting new SQL statements during a control-plane incident even though existing table files remain stored and a previously running query completes; choosing this alternative would address the wrong failure mode.