DBT DBT Deployment & CI/CD 2

Question 1

Which file defines the target warehouse connection details for a dbt Core project?

Accepted Answer

profiles.yml

Answer

dbt_project.yml

Answer

sources.yml

Answer

connections.yml

Question 2

What does `dbt run --target prod` do?

Accepted Answer

Switches to the `prod` target defined in profiles.yml

Answer

Deploys models to a production server

Answer

Tags all models with 'prod'

Answer

Enables production-only materializations

Question 3

Which dbt Cloud concept separates the environment where CI tests run from where production runs land?

Accepted Answer

Environments

Answer

Workspaces

Answer

Namespaces

Answer

Tenants

Question 4

What does the `+schema` config in dbt_project.yml do when set for a model folder?

Accepted Answer

Appends a custom suffix to the target schema for that folder's models

Answer

Sets the source schema to read from

Answer

Renames the model

Answer

Locks the schema from future changes

Question 5

In GitHub Actions, which `dbt run` flag would you add to run only models changed in a PR versus the production manifest?

Accepted Answer

--select state:modified+ --defer --state ./prod-manifest

Answer

--select changed:true

Answer

--modified-only

Answer

--select pr:changed

Question 6

What dbt Cloud feature lets a CI job use prod table results for unmodified models instead of rebuilding them?

Accepted Answer

Deferral

Answer

State comparison

Answer

Model caching

Answer

Run bypass