DATABRICKS-DAA Question 29

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 — A materialized view persists and caches its query results for reuse, while a plain view is evaluated on demand and recomputed on every query. A . A materialized view caches its computed output so downstream reads reuse precomputed data, whereas a plain view has no persisted state and recomputes its query logic every time it is read. B . This reverses the actual behavior: a materialized view is the one that caches and persists results, while a plain view is the one recomputed on demand for each query. C . A plain view does not persist any results to storage at all, so claiming both object types persist their output misstates how plain views work. D . Standalone materialized views can be queried broadly through Unity Catalog like other tables, and pipeline scoping applies to plain views defined inside a Lakeflow pipeline, not to materialized views generally.