Answer-first summary for fast verification
Answer: Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.
Option A is correct because in Databricks SQL, the Query History tab provides detailed information about executed queries, including whether results were served from the cache. When you click on a query in Query History, a slideout panel appears showing execution details, and one of the metrics displayed is whether the results came from cache. Option B is incorrect because there is no 'Cache Status alert' in the Alerts tab - alerts are for monitoring query thresholds, not cache status. Option C is incorrect because the Queries tab doesn't have a 'Cache Status' button; cache information is found in Query History details. Option D is incorrect because the SQL Warehouse tab shows warehouse configuration and metrics, not individual query cache details. Option E is incorrect because the Data tab is for browsing data objects, not query execution details. The community discussion shows 100% consensus on option A with upvoted comments confirming this is the correct approach.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can a data analyst identify if a query's results were served from the cache?
A
Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.
B
Go to the Alerts tab and check the Cache Status alert.
C
Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.
D
Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.
E
Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.