How can a data analyst identify if a query's results were served from the cache?

Exam-Like

Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.

80.9%

Go to the Alerts tab and check the Cache Status alert.

2.1%

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.

10.6%

Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.

4.3%

Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.

2.1%

Databricks Certified Data Analyst - Associate