What is the key difference between a standard view and a materialized view in Databricks SQL?

AA standard view stores data, but a materialized view stores only SQL text

BA materialized view physically stores query results, while a standard view stores query text only

CA standard view requires serverless pipelines, but a materialized view does not

DA materialized view can never refresh incrementally

Related Questions

Which Structured Streaming source does Auto Loader provide for incremental file ingestion from cloud...

easy

How does Auto Loader track which files have already been ingested?...

easy

A pipeline repeatedly runs COPY INTO against the same source folder. What happens to files that were...

easy

Which change data feed metadata column identifies whether a row is an insert, update preimage, updat...

easy

A team uses Auto Loader inside Lakeflow Spark Declarative Pipelines for production ingestion. Which ...

medium

View all Prepare and process data questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.