DBT DBT Macros & Jinja

Question 1

Which delimiter is used in Jinja to output a value in dbt SQL files?

Accepted Answer

Answer

`{{ }}` is the Jinja expression delimiter that evaluates and renders a value into the SQL output.

Question 2

What Jinja delimiter is used for control flow statements like `if`, `for`, and `set` in dbt?

Accepted Answer

{% ... %}

Answer

`{% %}` is used for Jinja statements such as `{% if %}`, `{% for %}`, and `{% set %}` which control logic without producing direct output.

Question 3

How do you define a reusable macro in dbt?

Accepted Answer

Define it with {% macro name(args) %} ... {% endmacro %} in the macros/ folder

Answer

Macros are defined with `{% macro macro_name(arg1) %}...{% endmacro %}` blocks stored in any `.sql` file inside the `macros/` directory.

Question 4

What built-in dbt variable returns the current target name (e.g., 'dev' or 'prod')?

Accepted Answer

Answer

`{{ target.name }}` returns the name of the active target as defined in profiles.yml, commonly used to branch logic between environments.

Question 5

Which dbt Jinja function safely reads an environment variable and supports a default value?

Accepted Answer

Answer

`env_var('NAME', 'default')` reads a process environment variable and returns the default if the variable is not set.

DBT - Certified Data Build Tool Developer Practice Test