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.

• A.- name: state
  tests:
  - accepted_values:
  values: ['active', 'churned', 'trial']
  - not_null
• B.- name: is_active
  tests:
  - accepted_values:
  values: ['active', 'churned', 'trial']
  - not_null
• C.- name: state
  tests:
  - not_null
  - unique
• D.- name: is_active
  tests:
  - not_null
  - unique

Comment: *

Name: *

Email: *

Verification: *

Your dbt project is part of a larger application where code for multiple components is merged into a shared main branch. Conflicts are becoming frequent. Which strategies could help mitigate merge conflicts?

• A.Establish clear ownership and responsibilities for different areas of the dbt project.
• B.Develop a communication process to notify teammates when changes are made to potentially shared models or sources.
• C.Encourage frequent merging of smaller feature branches into the main branch.
• D.All of the above.

Comment: *

Name: *

Email: *

Verification: *

Which two code snippets result in a lineage line being shown in the DAG? Choose 2 options.

• A.{{ source('source', 'table') }}
• B.{{ ref('stg_jaffle_shop__customers') }}
• C.dbt_jsmith.stg_jaffle_shop__customers
• D.{{ target.schema }}
• E.{{ source('jaffle_shop.customers') }}

Comment: *

Name: *

Email: *

Verification: *

Which explanation describes how dbt infers dependencies between models?
Choose 1 option.

• A.Information is gathered from the use of source and ref macros.
• B.All source and ref macros are resolved to database objects and dbt queries them for dependencies.
• C.The underlying SQL code is parsed and relationships are created from explicit table references.
• D..yml configurations for sources and refs are parsed for dependency information.

Comment: *

Name: *

Email: *

Verification: *

(Multiple Select)

• A.You suspect that filters in a source definition arent being applied correctly.
• B.You're trying to optimize the performance of a particularly complex transformation.
• C.You encounter an error message that references a specific line number in the compiled code.
• D.Data type conversions in your models consistently fail during execution.

Comment: *

Name: *

Email: *

Verification: *