Free Data Build Tool dbt-Analytics-Engineering Exam Questions

Become Data Build Tool Certified with updated dbt-Analytics-Engineering exam questions and correct answers

Page: 1 / 58

Total 289 Questions | Updated On: Apr 27, 2026

Add To Cart

Question 1

You work at an e-commerce company and a vendor provides their inventory data via CSV file uploads to an S3 bucket. How do you prep the data for dbt transformations? Choose 1 option.

A : Create a dbt model with a view querying the external table directly.

B : Run a pre-hook to create a temporary table and query from it in a staging model.

C : Use dbt seed to stage the data in your data platform.

D : Declare the external table as a source using the external configuration.

Answer: D

Question 2

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 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

Which two are true for a dbt clone command? Choose 2 options.

A : It requires the reference to a manifest from a previous dbt invocation.

B : It allows comparison between manifests of source and target dbt runs, but does not create any objects itself.

C : It allows testing your code changes on downstream dependencies outside of dbt (such as a BI tool).

D : It can be used to replicate data across different data warehouses.

E : It creates new versions of your dbt models suffixed with _v#.

Answer: A,C

Question 5

Which command materializes my_model and only its first-degree parent model(s) in the data platform? Choose 1 option.

A : dbt run --select +my_model

B : dbt compile --select +my_model

C : dbt run --select 1+my_model

D : dbt run --select +1 my_model

E : dbt compile --select +1 my_model

Answer: D

Page: 1 / 58

Total 289 Questions | Updated On: Apr 27, 2026

Add To Cart