DBT Analytics Engineering
Certification June 2025 Test With
Accurate Updated Answers.
dbt source freshness produces which artifact? - Answer sources.json
Dbt source freshness - Answer Freshness:
Warn_after: {count: 12, period: hour}
Error_after: {count: 1, period: day}
Dbt build and source freshness - Answer Dbt build DOES NOT include freshness tests - run dbt
source freshness && dbt build
Which statement accurately describes the purpose and functionality of the 'grants'
configuration in dbt Core? - Answer Permission management via a structured permission
definition using a dictionary format
- no manual intervention for permission maintenance needed
-
Grant input for no one to access? - Answer Within the config block,
Grants = {'select':[]} — no one has access to query the model
Grants = {} — dbt is not managing grants (or if it's missing completely, everyone will have
access)
Most precise command to run a specific model: models/finance/data_analysis.sql - Answer
Dbt build -s data_analysis
- always use the FILE NAME, don't need the file location
When is the @ symbol used in dbt commands? - Answer For tag selection (not model
selection)
When debugging a recurring data transformation issue in a dbt project, which LOG_LEVEL
, Staging recommendations - Answer Staging models perform light transformations while
maintaining a one-to-one relationship with source tables
Best dbt feature for ensuring null values do not exist in a field in a table? - Answer Not_null
test in the schema.yml file
What are control structures in jinja? - Answer If//else statement for implementing conditional
logic
Example:
{% if target.name == 'prod' %}
— prod logic
{% else $}
— dev logic
{% endif %}
When to use the from: selector in a dbt command? - Answer never. from: is not valid dbt
syntax for source selection
Best practice for model layers? (Staging, int, and mart) - Answer Staging - cleaned raw data,
minimal transformations
Intermediate - business logic
Mart - final business logic ready for consumption
In a dbt project, which yml file should be created to configure source definitions, including table
names, freshness checks, and descriptions for upstream data sources? - Answer Sources.yml
What kind of configurations is the schema.yml file used for? - Answer Model configurations
When is the manifest.yml file configured? - Answer Internal dbt artifact generated during
compilation
Certification June 2025 Test With
Accurate Updated Answers.
dbt source freshness produces which artifact? - Answer sources.json
Dbt source freshness - Answer Freshness:
Warn_after: {count: 12, period: hour}
Error_after: {count: 1, period: day}
Dbt build and source freshness - Answer Dbt build DOES NOT include freshness tests - run dbt
source freshness && dbt build
Which statement accurately describes the purpose and functionality of the 'grants'
configuration in dbt Core? - Answer Permission management via a structured permission
definition using a dictionary format
- no manual intervention for permission maintenance needed
-
Grant input for no one to access? - Answer Within the config block,
Grants = {'select':[]} — no one has access to query the model
Grants = {} — dbt is not managing grants (or if it's missing completely, everyone will have
access)
Most precise command to run a specific model: models/finance/data_analysis.sql - Answer
Dbt build -s data_analysis
- always use the FILE NAME, don't need the file location
When is the @ symbol used in dbt commands? - Answer For tag selection (not model
selection)
When debugging a recurring data transformation issue in a dbt project, which LOG_LEVEL
, Staging recommendations - Answer Staging models perform light transformations while
maintaining a one-to-one relationship with source tables
Best dbt feature for ensuring null values do not exist in a field in a table? - Answer Not_null
test in the schema.yml file
What are control structures in jinja? - Answer If//else statement for implementing conditional
logic
Example:
{% if target.name == 'prod' %}
— prod logic
{% else $}
— dev logic
{% endif %}
When to use the from: selector in a dbt command? - Answer never. from: is not valid dbt
syntax for source selection
Best practice for model layers? (Staging, int, and mart) - Answer Staging - cleaned raw data,
minimal transformations
Intermediate - business logic
Mart - final business logic ready for consumption
In a dbt project, which yml file should be created to configure source definitions, including table
names, freshness checks, and descriptions for upstream data sources? - Answer Sources.yml
What kind of configurations is the schema.yml file used for? - Answer Model configurations
When is the manifest.yml file configured? - Answer Internal dbt artifact generated during
compilation
