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

Which two code snippets result in a lineage line being shown in the DAG? Choose 2 options.

A : {{ source('source', 'table') }}

B : {{ ref('stg_jaffle_shop__customers') }}

C : dbt_jsmith.stg_jaffle_shop__customers

D : {{ target.schema }}

E : {{ source('jaffle_shop.customers') }}

Answer: A,B

Question 2

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 3

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 4

Which is NOT a step of a typical automated dbt workflow 1. models and analysis are downloaded from multiple source control repositories, 2. code is configured for the given environment, 3. code is tested, and 4. code is deployed.

A : Only 1

B : All of them

C : None of them

D : 1 and 2

Answer: C

Question 5

Given following model codeSelect col_1, col_2 From {{ ref(‘model_a’) }} While running dbt run, following error occurred: table does not exist What is the most likely error (Choose 2)

A : Wrong Database or Schema

B : Not enough permission

C : Wrong Adapter

D : Wrong table name

Answer: A,B

Page: 1 / 58

Total 289 Questions | Updated On: Apr 27, 2026

Add To Cart