Bird
0
0

If dbt_project.yml contains:

medium📝 Predict Output Q5 of 15
dbt - Project Organization
If dbt_project.yml contains:
models:
  my_project:
    +materialized: incremental
    staging:
      +materialized: view

What materialization will models in the staging folder have?
Aincremental
Bview
Ctable
Dephemeral
Step-by-Step Solution
Solution:
  1. Step 1: Understand the inheritance of materialization

    The parent folder my_project sets materialization to incremental by default.
  2. Step 2: Check the override in staging folder

    The staging folder overrides materialization to view.
  3. Final Answer:

    view -> Option B
  4. Quick Check:

    Child folder config overrides parent materialization [OK]
Quick Trick: Child folder settings override parent folder settings [OK]
Common Mistakes:
MISTAKES
  • Ignoring folder-level overrides
  • Assuming parent folder setting applies everywhere
  • Confusing incremental with view

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes