Free Data Build Tool dbt-Analytics-Engineering Practice Exam Questions and Answers 2026

Start Learning with the Newest and 100% Free dbt-Analytics-Engineering Exam Dumps Questions

Page: 1 / 58

Total 289 Questions | Updated On: Apr 02, 2026

Add To Cart

Question 1

Given following .yml config, how dbt behaves if the environment variables are not set when dbt run is invokedprofile: target: prod outputs: prod: type: postgres host: 127.0.0.1 # IMPORTANT: Make sure to quote the entire Jinja string here user: "{{ env_var('DBT_USER') }}" password: "{{ env_var('DBT_PASSWORD') }}" ....

A : dbt throws compilation error

B : dbt produces an warning and continue

C : dbt throws an warning and stops execution

D : dbt throws run time error

Answer: A

Question 2

Which is a mandatory property of an metrics resource

A : config

B : timestamp

C : label

D : meta

Answer: C

Question 3

You want to add new columns to an existing model with a new version. What will trigger warnings for removal of older model versions? Choose 1 option.

A : Create a new version of the model

B : Provide a configuration for deprecation_date

C : Configure the old model as enabled: false

D : Include “deprecated” in the description of the model

Answer: B

Question 4

Consider these SQL and YAML files for the model model_a: models/staging/model_a.sql {{ config( materialized = "view" ) }} with customers as ( ... ) dbt_project.yml models: my_new_project: +materialized: table staging: +materialized: ephemeral Which is true about model_a? Choose 1 option.

A : Select statements made from the database on top of model_a and transformation processing within model_a will be quicker, but the data will only be as up to date as the last dbt run.

B : Select statements made from the database on top of model_a will result in an error.

C : Select statements made from the database on top of model_a will be slower, but the data will always be up to date.

D : Select statements made from the database on top of model_a will be quicker, but the data will only be as up to date as the last dbt run.

Answer: C

Question 5

Match dbt commands with scenarios 1. parse 2. run 3. seed 4. snapshot A. loads CSV files into the database B. runs the models in a project C. parses a project and writes detailed timing info D. executes "snapshot" jobs defined in a project

A : 1 --> C, 2 --> B, 3 ---> A, 4 ---> D

B : 1 --> D, 2 --> B, 3 ---> C, 4 ---> A

C : 1 --> C, 2 --> B, 3 ---> D, 4 ---> A

D : 1 --> B, 2 --> C, 3 ---> D, 4 ---> A

Answer: A

Page: 1 / 58

Total 289 Questions | Updated On: Apr 02, 2026

Add To Cart