You want to configure your dbt project so that all models in the sales folder are materialized as incremental and use the schema sales_data. Which dbt_project.yml snippet correctly achieves this?

hard📝 Application Q15 of 15

dbt - Project Organization

You want to configure your dbt project so that all models in the sales folder are materialized as incremental and use the schema sales_data. Which dbt_project.yml snippet correctly achieves this?

Amodels: sales: +materialized: incremental +schema: sales_data

Bmodels: sales: materialized: incremental schema: sales_data

Cmodels: sales: materialized: incremental +schema: sales_data

Dmodels: sales: +materialized: incremental schema: sales_data

Step-by-Step Solution

Solution:

Step 1: Understand dbt config syntax for folder-level overrides
To set configs for all models in a folder, use the '+' prefix before keys.
Step 2: Check which options use '+' for both keys
Both materialized and schema need '+' prefix to apply to all models in sales folder.
Final Answer:
models: sales: +materialized: incremental +schema: sales_data -> Option A
Quick Check:
Folder configs use '+' prefix [OK]

Quick Trick: Use '+' before keys to apply configs to all models in a folder [OK]

Common Mistakes:

MISTAKES

Missing '+' prefix for folder-level configs
Using '+' on only one key instead of both
Confusing folder name with project name

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More dbt Quizzes

You want to configure your dbt project so that all models in the sales folder are materialized as incremental and use the schema sales_data. Which dbt_project.yml snippet correctly achieves this?

Step 1: Understand dbt config syntax for folder-level overrides

Step 2: Check which options use '+' for both keys

Final Answer:

Quick Check:

Want More Practice?