Explanation:
In Databricks Delta Live Tables (and Lakeflow), a Materialized View (MV) incrementally computes and maintains the exact result of a query, correctly handling updates, deletes, and aggregations. A Streaming Table is designed for append-only streaming data, processing each new input record exactly once.
Ultimate access to all questions.
A
MV is only stored in the Silver layer.
B
Streaming Tables do not support Unity Catalog governance.
C
MV ensures data consistency by re-calculating results; Streaming Tables only append new data.
D
Only Streaming Tables can be scheduled.
No comments yet.