An analyst is designing a data model in Databricks SQL and wants to create a reusable query layer that executes the underlying SQL every time it is queried, without storing any physical data. Which object type should they create?

Question

Accepted Answer

B. Standard view. A standard view is a saved query definition that is executed against the underlying tables each time the view is queried. It does not store data physically. A managed Delta table stores physical data. A materialized view stores pre-computed results. A streaming table is used for continuous data ingestion from streaming sources.

An analyst is designing a data model in Databricks SQL and wants to create a reusable query layer that executes the underlying SQL every time it is queried, without storing any physical data. Which object type should they create?

Related Questions

Discussion