dbt-Analytics-Engineering Exam Question 21
A colleague has introduced a new sensitive column into a source table. You need to update the dbt project documentation accordingly. Which of the following actions should you take?
dbt-Analytics-Engineering Exam Question 22
A user reports a critical security issue discovered in a third-party dbt package you use. Where could you most likely find updated information about potential vulnerabilities or fixes?
dbt-Analytics-Engineering Exam Question 23
You're onboarding a new dbt project to an existing production database. You find tables that might conflict with naming conventions used by dbt. What's a proactive way to handle this?
dbt-Analytics-Engineering Exam Question 24
You need to create a model that combines data from a large fact table with smaller dimension tables. Performance is paramount, and the data in the fact table updates incrementally but frequently. Which materialization strategy is likely to provide the optimal balance of efficiency and freshness?
dbt-Analytics-Engineering Exam Question 25
You're working with ephemeral models in your dbt project. Which scenarios could cause an ephemeral model to fail?
