Which of the following is the correct YAML syntax to set the materialized property to view for all models in a project named sales_project?

easy📝 Syntax Q3 of 15

dbt - Project Organization

Which of the following is the correct YAML syntax to set the materialized property to view for all models in a project named sales_project?

Amodels: sales_project: materialized = view

Bmodels: sales_project: materialized: view

Cmodels: sales_project: materialized: - view

Dmodels: sales_project: +materialized: view

Step-by-Step Solution

Solution:

Step 1: Recall dbt YAML syntax for configurations
In dbt_project.yml, configuration keys like materialized must be prefixed with + (e.g., +materialized: view) to distinguish them from directory names.
Step 2: Check each option
models: sales_project: +materialized: view uses correct +materialized: view. models: sales_project: materialized: view lacks +, treating materialized as directory. models: sales_project: materialized: - view uses list incorrectly. models: sales_project: materialized = view uses = invalid in YAML.
Final Answer:
models: sales_project: +materialized: view -> Option D
Quick Check:
dbt configs require + prefix [OK]

Quick Trick: YAML uses colon and indentation, no equal signs [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes