DATABRICKS-DAA Question 51

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Correct answer : A — The remote result cache is stored outside the cluster and persists across a warehouse restart, so the identical query reuses the earlier computed result. A . The remote result cache is a workspace-level store separate from any single cluster, has a lifecycle of up to 24 hours, and survives a warehouse being stopped and restarted, so an unchanged identical query returns the cached result immediately. B . The disk cache lives on local SSD attached to compute nodes and is cleared when a cluster or warehouse restarts, so it could not have survived the overnight stop to serve this result. C . Running a query in the SQL editor does not create a materialized view of the result; no persistent view object is created just by executing a SELECT statement. D . A stopped serverless warehouse is not still running underneath the billing layer; the near-instant response comes from the persistent remote result cache, not from hidden active compute.