(Multiple Select)

• A.The level of detail needed in downstream reporting.
• B.The desired frequency for updating the data
• C.The number of users currently active on the data warehouse.
• D.Existing model patterns within the project for consistency.

Comment: *

Name: *

Email: *

Verification: *

You have a dbt model that performs complex aggregations. During development, you notice some models take excessively long to run, but they ultimately complete without errors. Which of the following might be true?

• A.The models are at risk of failing if the source data grows substantially.
• B.These models likely have issues with joins or CTE structure impacting performance.
• C.Downstream models will inherit the performance issues.
• D.This behavior automatically triggers an optimization feature within dbt.

Comment: *

Name: *

Email: *

Verification: *

A developer has updated multiple models in their dbt project, materialized as tables and views.
They want to run and test all models upstream and downstream from the modified models that are materialized as views.
What command will achieve this? Choose 1 option.

• A.dbt build --select +state:modified, config.materialized:view+
• B.dbt build --select +state:modified+
• C.dbt build --select @state:modified+, @config.materialized:view+
• D.dbt build --select +state:modified +materialized:view+
• E.dbt build --select +state:modified, +config.materialized:view+

Comment: *

Name: *

Email: *

Verification: *

You're working in a highly collaborative environment. How could you manage contributions and updates to complex lineage macros to ensure maintainability and prevent conflicts?

• A.Utilize a robust version control system (e.g., Git) for macro code.
• B.Establish coding style guides and peer-review processes specifically for macros.
• C.Limit the number of people authorized to make changes to sensitive lineage macros-
• D.All of the above-

Comment: *

Name: *

Email: *

Verification: *