Noos
PT EN
RAN-DBDEA-00214
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: hard

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?

Options (Reading Mode) Click to filter discussion →
  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
  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
  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
  4. D. Materialized views and Delta tables are the same storage object — the two names only reflect whether a pipeline created them
Reveal answer

Correct answer: 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

Reference: https://docs.databricks.com/aws/en/ldp/concepts/materialized-views

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (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

Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.