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: Mar 05, 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

Which of the following is true about restricting the usage of models in dbt? Choose 1 option.

A : Restrictions are set by defining the models and Git user groups approved for usage.

B : You must map your data platform roles to groups by specifying the role name in the configurations.

C : Model groups can limit references by other models which aren’t in the same group.

D : Data platform user emails can be used to determine who can reference a model.

Answer: C

Question 4

A developer imports a package from a private repository called timeformat for use within their project. Which statement is correct? Choose 1 option.

A : “The package can be added with this configuration in the packages.yml file:”packages:- local: /opt/dbt/timeformat

B : “The package can be installed by running the command dbt build.”

C : “The package default schema can be overridden in the dbt_project.yml file as:”models:timeformat:+schema: timeseries

D : “Including the package version/revision in the packages.yml file, for private git packages will result in an error.”

Answer: C

Question 5

Which of the following is true about restricting the usage of models in dbt? Choose 1 option.

A : Restrictions are set by defining the models and Git user groups approved for usage.

B : You must map your data platform roles to groups by specifying the role name in the configurations.

C : Model groups can limit references by other models which aren’t in the same group.

D : Data platform user emails can be used to determine who can reference a model.

Answer: C

Page: 1 / 58

Total 289 Questions | Updated On: Mar 05, 2026

Add To Cart