Dbt certification Exam Questions AND Correct Answers

Dbt certification Exam Questions AND Correct Answers
4 types of materializations? - ✔✔view, table, incremental,
ephemeral


command the runs models, tests, snapshots, and seeds -
✔✔dbt build


command to call an environment variable in a yml file? -
✔✔'{{ env_var("var_name") }}'


dbt command to execute all compiled sql models - ✔✔dbt run


dbt command to execute all snapshots - ✔✔dbt snapshot


dbt command to generate documentation - ✔✔dbt docs
generate


dbt command to generate the sql for models - ✔✔dbt compile


dbt command to just run the model model_a - ✔✔dbt run --
select model_a

, dbt command to load csv files - ✔✔dbt seed


dbt command to run a macro called grant_select() which takes
no arguments - ✔✔dbt run-operation grant_select


dbt command to run a macro called grant_select(role) with
the value for role being analyst - ✔✔dbt run-operation
grant_select --args '{'role': 'analyst'}'


dbt command to run all incremental models - ✔✔dbt run --
select config.materialized:incremental


dbt command to run all models that exposure
"weekly_jaffle_shop_metrics" depends on - ✔✔dbt run --
select +exposure:weekly_jaffle_shop_metrics


dbt command to run all models that had an error on the prior
run - ✔✔dbt run --select result:error


dbt command to run all models that have been modified -
✔✔dbt run --select state:modified