DBT DBT Core Concepts & Architecture 2

Question 1

What is the purpose of the `target` key in a dbt profile?

Accepted Answer

Defines the default environment (e.g., dev or prod) to use when running dbt

Answer

Specifies the file path where compiled SQL is saved

Answer

Sets the maximum number of threads dbt can use

Answer

Points to the schema.yml file for validation

Question 2

What does the node selection syntax `dbt run --select +my_model` do?

Accepted Answer

Runs my_model and all its upstream parent models

Answer

Runs my_model and all models downstream of it

Answer

Runs only my_model, excluding any dependencies

Answer

Runs all models except my_model

Question 3

Which command is used to install dbt packages listed in `packages.yml`?

Accepted Answer

dbt deps

Answer

dbt install

Answer

dbt init

Answer

dbt update

Question 4

What does `dbt docs generate` produce?

Accepted Answer

A catalog.json and manifest.json used to serve the documentation site

Answer

A compiled SQL file for each model in the project

Answer

A YAML schema file based on existing database tables

Answer

A test results report in HTML format

Question 5

In dbt, what is an 'ephemeral' materialization?

Accepted Answer

A model that is never written to the database and exists only as a CTE in downstream models

Answer

A model that is deleted from the database after each run

Answer

A model stored in a temporary table and dropped after the session ends

Answer

A model that runs only once and is never refreshed

Question 6

What does `dbt debug` do?

Accepted Answer

Validates the project configuration and database connection

Answer

Shows detailed SQL output for each model as it runs

Answer

Tests all data quality constraints defined in schema.yml

Answer

Displays the full DAG for the current project

Question 7

Which dbt selector syntax runs a model and all models downstream of it?

Accepted Answer

my_model+

Answer

+my_model

Answer

my_model*

Answer

*my_model