DBT Advanced Quiz

Which of these is the main focus of dbt?

• Data Extraction
• Data Transformation
• Data Storage
• Data Analysis

Fill in the blank: By default, dbt materializes models as (a)   .

Which folder typically contains the most complex transformations?

• Mart
• Staging
• Intermediate
• Raw

What are benefits of materializing models as tables in dbt? (Select all that apply)

• Faster performance
• Always uses less storage
• Avoids recomputing queries
• Ensures freshest data

Fill in the blank: A dbt (a)   is used to organize logic and store models by transformation type.

In dbt, what is the purpose of staging models?

• Final reporting
• Joining 10+ tables
• Cleaning raw data
• Creating dashboards

Fill in the blank: In dbt Cloud, version control is managed using (a)   .

What is the role of the production environment in dbt?

• For testing experiments
• For cleaning raw data
• To serve data to end users
• To store backups

Which steps are part of the Git workflow in dbt Cloud? (Select all that apply)

• Create a branch
• Commit changes
• Create a pull request
• Upload to FTP

How can dbt jobs be scheduled in production?

• Only manually
• Using dbt Cloud or Airflow
• With Excel Macros
• On a timer app