A gold aggregate — weekly revenue by region — is currently a plain Delta table that a nightly Lakeflow Job fully rewrites with INSERT OVERWRITE. The team is evaluating replacing it with a materialized view defined in a Lakeflow Declarative Pipeline, and the lead must explain the operational difference between the two approaches. Which comparison is correct?

1. A. A materialized view still requires the team to write, schedule, and maintain the refresh job that keeps its cached results up to date 💬 A
2. B. A plain Delta table refreshes itself on a schedule it owns, so wrapping it in a nightly Lakeflow Job rewrites the same data twice 💬 B
3. C. A materialized view is declarative — the platform refreshes it on its configured schedule, incrementally processing source changes; a table plus job keeps refresh control with the team ✓ C
4. D. Materialized views and Delta tables are the same storage object — the two names only reflect whether a pipeline created them 💬 D

Revelar gabarito

Resposta correta: A materialized view is declarative — the platform refreshes it on its configured schedule, incrementally processing source changes; a table plus job keeps refresh control with the team

Referência: https://docs.databricks.com/aws/en/ldp/concepts/materialized-views