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: Jun 17, 2026

Add To Cart

Question 1

Examine how freshness is defined at the database level:- name: rawdatabase: rawfreshness: # default freshnesswarn_after: {count: 12, period: hour}error_after: {count: 24, period: hour}loaded_at_field: _etl_loaded_atHow can one table from the source raw be excluded from source freshness?

A : Add freshness: null to the table configuration.

B : Since freshness is defined at the source level, all tables in the source must adhere to the freshness parameters.

C : Add loaded_at_field: null to the table configuration.

D : Add error_after: null to the table configuration.

Answer: A

Question 2

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 3

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 4

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 5

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

Page: 1 / 58

Total 289 Questions | Updated On: Jun 17, 2026

Add To Cart