Data Build Tool DBT-Analytics-Engineering Exam Dumps

dbt Analytics Engineering Certification Exam

750 Reviews

Exam Code	DBT-Analytics-Engineering
Exam Name	dbt Analytics Engineering Certification Exam
Questions	65 Questions Answers With Explanation
Update Date	04, 30, 2026
Price	Was : $142.2 Today : $79 Was : $160.2 Today : $89 Was : $178.2 Today : $99

Add To Cart

Demo Questions

Question # 1

A developer has updated multiple models in their dbt project, materialized as tablesand views.They want to run and test all models upstream and downstream from the modifiedmodels that are materialized as views.What command will achieve this? Choose 1 option.

A. dbt build --select +state:modified, config.materialized:view+  
B. dbt build --select +state:modified+  
C. dbt build --select @state:modified+, @config.materialized:view+  
D. dbt build --select +state:modified +materialized:view+  
E. dbt build --select +state:modified, +config.materialized:view+  

Show Answer

Question # 2

Given this dbt_project.yml:name: "jaffle_shop"version: "1.0.0"config-version: 2profile: "snowflake"model-paths: ["models"]macro-paths: ["macros"]snapshot-paths: ["snapshots"]target-path: "target"clean-targets:- "logs"- "target"- "dbt_modules"- "dbt_packages"models:jaffle-shop:+materialized: table…and this warning when compiling your project:[WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to anyresources.There are 1 unused configuration paths:- models.jaffle-shopWhat is the root cause?A run hook in the jaffle_shop project was defined with an incorrect regular expression.

A. Yes  
B. No  

Show Answer

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  

Show Answer

Question # 4

Which two are true about dbt tests?Choose 2 options.

A. Tests for unique and not_null are automatically applied on the primary key of the table.  
B. The full list of tests that can be applied natively can be found on dbt’s package hub.  
C. Tests can be built as .sql files within the /tests/ folder.  
D. dbt ships natively with unique, not_null, relationships, and accepted_values tests.  
E. You can apply dbt’s native tests using the constraints configuration in the model’s YAML. 

Show Answer

Question # 5

Examine model stg_customers_sales that exists in the main branch:selectid as customer_id,name as customer_namefrom {{ source('my_data','my_source') }}A developer creates a branch feature_a from main and modifies the model as:selectid as customer_id,name as customer_name,country as customer_countryfrom {{ source('my_data','my_source') }}A second developer also creates a branch feature_b from main and modifies the model as:selectid as customer_id,name as customer_name,address as customer_addressfrom {{ source('my_data','my_source') }}The first developer creates a PR and merges feature_a into main.Then the second developer creates a PR and attempts to merge feature_b into main.How will git combine the code from feature_b and the code from main, which nowcontains the changes from feature_a as well?Statement:"As feature_a is already approved and merged to main, the code for the modelstg_customers_sales will stay as-is and the changes from feature_b won’t be added."

A. Yes  
B. No  

Show Answer

Question # 6

Which statement is true regarding source freshness checks?Choose 1 option.

A. The freshness check can be disabled with freshness: null.  
B. A source freshness check will always exit immediately after the first failure.  
C. dbt source freshness should always be the final command in a run.  
D. dbt build will automatically run source freshness checks.  

Show Answer

Question # 7

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 tothe freshness parameters.
C. Add loaded_at_field: null to the table configuration.  
D. Add error_after: null to the table configuration.  

Show Answer

Question # 8

In development, you want to avoid having to re-run all upstream models whenrefactoring part of your project.What could you do to save time rebuilding models without spending warehousecredits in your next command?

A. Replace your {{ ref() }} functions with hard-coded references.  
B. Refer to a manifest and utilize the --defer and --state flags.  
C. Clone your upstream models from the production schema to the development schema.  
D. Leverage artifacts from a prior invocation by passing only the --state flag.  

Show Answer

Question # 9

You have created a model called stg_tasks and now you need to implement tests.You provide this in schema.yml:version: 2models:- name: stg_taskscolumns:- name: completed_attests:- not_null:- config:where: "state = 'completed'"You receive this compilation error:[WARNING]: Did not find matching node for patch with name 'stg_tasks' in the 'models'section of file 'models/example/schema.yml'How can you change the configuration on the not_null test to fix this compiler error?

A.tests:- not_null:- config:where: "state = 'completed'" 
B.tests:- not_null:config: where: "state = 'completed'" 
C.tests:- not_null:config:where: "state = 'completed'" 
D.tests:- not_null:- config:where: "state = 'completed'"Choose 1 option. 

Show Answer

Question # 10

You wrote this test against your fct_orders model to confirm status filters were properlyapplied by a parent model:{{config(enabled=true,severity='error')}}select *from {{ ref('fct_orders') }}where status_code = 13Which statement about this test is true?

A. You must attach the test to the model in orders.yml for it to run.  
B. This test will warn instead of erroring when you use the --warn-error flag.  
C. The file must be saved in the tests/generic directory.  
D. Records with status_code = 13 will cause this test to fail.  

Show Answer

Question # 11

The dbt_project.yml file contains this configuration:models:+grants:select: ['reporter']How can you grant access to the object in the data warehouse to both reporter and bi?

A.{{ config(grants = { '+select': ['bi'] }) }}
B.{{ config(grants = { 'select': ['+bi'] }) }} 
C.{{ config(grants = { 'select': ['bi'], 'inherits': true }) }}
D.{{ config(grants = { 'select': ['bi'], 'include': ['dbt_project.yml'] }) }} 

Show Answer

Question # 12

Examine the configuration for the source:sources:- name: jaffle_shopschema: jaffle_shop_raw_currenttables:- name: ordersidentifier: customer_ordersWhich reference to the source is correct?

A. {{ source('jaffle_shop_raw_current', 'customer_orders') }} 
B. {{ source('jaffle_shop_raw_current', 'orders') }}  
C. {{ source('jaffle_shop', 'orders') }}  
D. {{ source('jaffle_shop', 'customer_orders') }}  

Show Answer

Question # 13

How can you overwrite configurations for models within a package?Choose 1 option.

A. By specifying the configurations within the packages.yml file under the relevant package entry. 
B. By adding the configurations in dbt_project.yml within the package's namespace.  
C. After installing the package, you can apply configurations on the models in the ./target folder.
D. By navigating into the /dbt_packages folder and adding the configurations directly to the models. 

Show Answer

Question # 14

16. Your tests folder looks like:tests generic furniture_customers_test.sqlmacro_stg_tpch_orders_assert_pos_price.sqlmacro_stg_tpch_suppliers_assert_pos_acct_bal.sqlstg_tpch_orders_assert_positive_price.sqlYou run the command:dbt test --select 'test_type:singular'What will the command run?Options from screenshot:

A.furniture_customers_test
B.furniture_customers_testmacro_stg_tpch_orders_assert_pos_pricemacro_stg_tpch_suppliers_assert_pos_acct_balstg_tpch_orders_assert_positive_price
C.macro_stg_tpch_orders_assert_pos_pricemacro_stg_tpch_suppliers_assert_pos_acct_balstg_tpch_orders_assert_positive_price

Show Answer

Question # 15

You define a new generic test on model customers in a YAML file:version: 2models:- name: customerscolumns:- name: customer_idtests:- unique- not_nullThe next time your project compiles you get this error:Raw Error:mapping values are not allowed in this contextin "<unicode string>", line 7, column 21What is the cause of this error?

A. tests should be a dictionary key, not a list  
B. tests should be wrapped in double quotes (")  
C. unique and not_null should not be elements in a list  
D. unique and not_null should be indented at the same level as tests  

Show Answer

Question # 16

Which two configurations can be applied to a dbt test?Choose 2 options.

A. on_schema_change  
B. tags  
C. enabled  
D. materialized  
E. persist_docs  

Show Answer

Question # 17

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.  

Show Answer

Question # 18

You run this command:dbt build --select "source_status:fresher+" --state path/to/prod/artifactsWhich two need to happen before it can be executed successfully?Choose 2 options.

A. Invoke the command: dbt source freshness.  
B. Invoke either dbt run or dbt build.  
C. Add generic tests to your sources.  
D. Define a freshness block on your source(s).  
E. Test your sources with dbt test.  

Show Answer