Exam Questions and Answers |
Already Graded A+
pre-hook - ANSWER ✔✔executed before a model, seed or snapshot
is built.
post-hook - ANSWER ✔✔executed after a model, seed or snapshot
is built
on-run-start - ANSWER ✔✔executed at the start of dbt run, dbt seed
or dbt snapshot
on-run-end - ANSWER ✔✔executed at the end of dbt run, dbt seed
or dbt snapshot
,T|F Operations are a separate resource in a dbt project. - ANSWER
✔✔False. Operations are macros that you can run using the run-
operation command command.
What are the required properties in defining an exposure? - ANSWER
✔✔Name, Type & Owner (email)
What are the different values of 'type' property of an exposure? -
ANSWER ✔✔dashboard, notebook, analysis, ml, application
T|F Exposures appear as orange-y nodes in the DAG - ANSWER
✔✔True.
What will command "dbt run -s +exposure:weekly_jaffle_metrics"
execute? - ANSWER ✔✔This will execute all models upstream of the
exposure.
On the first run of the "dbt snapshot" command, what is the value of
dbt_valid_to for all records? - ANSWER ✔✔Null
What are the different strategies used in creating a snapshot? -
ANSWER ✔✔Timestamp & Check
What is the required config when a 'check' strategy is used in creating a
snapshot? - ANSWER ✔✔check_cols
, When should a check strategy be used when creating a snapshot? -
ANSWER ✔✔The check strategy is useful for tables which do not
have a reliable updated_at column.
What is the required config when a 'timestamp' strategy is used in
creating a snapshot? - ANSWER ✔✔updated_at
What are the different snapshot meta fields? - ANSWER
✔✔dbt_valid_from, dbt_valid_to, dbt_scd_id, dbt_updated_at
What happens when the 'invalidate_hard_deletes' config is set to 'true'
while defining a snapshot? - ANSWER ✔✔Finds hard deleted records
in source, and set dbt_valid_to current time if no longer exists
T|F Seeds can be configured in the .csv file - ANSWER ✔✔False.
Seeds are configured in your dbt_project.yml
T|F Sources are declared in the dbt_project.yml file. - ANSWER
✔✔False. Sources are defined in .yml files nested under a sources: key.
How can the landing page of the generated documentation website be
customized? - ANSWER ✔✔By supplying your own docs block called
__overview__. i.e. {{ % docs _overview_ % }} ....... {{ % enddocs % }}
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2026. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED