Valid dbt-Analytics-Engineering Dumps shared by EduDump.com for Helping Passing dbt-Analytics-Engineering Exam! EduDump.com now offer the newest dbt-Analytics-Engineering exam dumps, the EduDump.com dbt-Analytics-Engineering exam questions have been updated and answers have been corrected get the newest EduDump.com dbt-Analytics-Engineering dumps with Test Engine here:
13. An analyst on your team has informed you that the business logic creating the is_active column of your stg_users model is incorrect. You update the column logic to: case when state = 'Active' then true else false end as is_active Which test can you add on the state column to support your expectations of the source data? Choose 1 option.
Correct Answer: A
The purpose of this question is to determine how to validate that the input values in the state column support the business logic that determines the is_active field. Since the logic checks whether state = 'Active', it is critical that the state column only contains values that the business process expects. In the example shown, acceptable states appear to be: 'active', 'churned', and 'trial'. The correct way to enforce this expectation is to apply an accepted_values test on the state column. This ensures that any unexpected state (e.g., 'inactive', 'pending', 'deleted', or NULL) will cause the test to fail, alerting the team that the upstream system is producing unexpected or invalid values. Additionally, adding not_null ensures every user record contains a valid state. Option A is the only configuration that applies the accepted values test to the correct column (state) and reflects the expected domain of values. Options B and D incorrectly apply tests to the derived column is_active, not the source column that needs validation. Option C only checks nullability and uniqueness, which does not validate the range of allowed values and thus does not protect the business logic. Therefore, Option A is the only correct answer.
