DBT DBT Core Concepts & Architecture

Question 1

What is the primary purpose of the `ref()` function in dbt?

Accepted Answer

To reference another dbt model and build the DAG dependency graph

Answer

The `ref()` function references another dbt model and allows dbt to infer dependencies, building the correct DAG execution order automatically.

Question 2

Which file defines top-level project configuration such as model paths, project name, and version in dbt?

Accepted Answer

dbt_project.yml

Answer

`dbt_project.yml` is the required project-level configuration file that defines project name, version, model directories, and global configurations.

Question 3

What does the `dbt compile` command do?

Accepted Answer

Generates compiled SQL files without executing them against the database

Answer

`dbt compile` resolves Jinja templating and `ref()` calls to produce compiled SQL in the `target/compiled/` directory without running any queries.

Question 4

In dbt, what does a DAG (Directed Acyclic Graph) represent?

Accepted Answer

The dependency relationships and execution order between models

Answer

The DAG in dbt represents the dependency graph between models, ensuring each model is built only after all its upstream dependencies are complete.

Question 5

Which command executes all dbt models in a project?

Accepted Answer

dbt run

Answer

`dbt run` executes all models in the project, materializing them in the target data warehouse according to their configured materialization type.

DBT - Certified Data Build Tool Developer Practice Test