Free Practice Data Build Tool dbt-Analytics-Engineering Exam Questions 2025

Identify 2 jinja macros available in generate_schema_name

Given following .yml, how the model events/mart/model_b.sql will be materialized 

name: dbt_labs

models:

dbt_labs:

   events:

     +enabled: true

     +materialized: view

    base:

      +materialized: table"

Given following .yml, how the model events/mart/model_b.sql will be materialized 

name: dbt_labs

models:

dbt_labs:

   events:

     +enabled: true

     +materialized: view

    base:

      +materialized: table"

Identify 3 snapshot meta fields

Given following .yml config, how dbt behaves if the environment variables are not set when dbt run is invoked

profile:

  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') }}"

      ....