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: Aug 20, 2026

Add To Cart

Question 1

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 2

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

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 5

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

Page: 1 / 58

Total 289 Questions | Updated On: Aug 20, 2026

Add To Cart