DBT Analytics Engineering
Q: 1
In a dbt project, what is the best way to handle changes to raw object names?
Options
Q: 2
You want to run only the models that have a specific source table in your dbt project. Which command
should you use to achieve this?
Options
Q: 3
The UNIQUE constraint in SQL ensures that all values in a column are distinct.
Options
Q: 4
What is the purpose of the dbt test command?
Options
Q: 5
True or False: The 'view' materialization in dbt stores the result of the query in the database.
Options
Q: 6
True or False: In dbt, using a UNION ALL instead of a UNION when combining multiple SELECT
statements with similar data can improve query performance.
Options
Q: 7
Select the valid methods for configuring incremental models in dbt. (Select all that apply)
Options
Q: 8
When running dbt debug, the compiled code is not saved to disk.
Options
Q: 9
In SQL, a subquery is a query that is embedded within another query, and it can be used to return
intermediate results for use by the outer query.
Options
Q: 10
If a SQL error in a dbt model is caused by an incorrect reference to another model, it is most likely a dbt
issue.
Options
Question 1 of 10
