Which of the following scenarios would typically warrant the use of production data in a development environment?

• A.Testing changes to a critical business reporting model for accuracy before deployment.
• B.Training new members of your team on writing SQL and basic dbt models.
• C.Debugging a logic error that only manifests itself under the exact conditions of real-world production data.
• D.Development environments should generally avoid using real production data to minimize risks.

Comment: *

Name: *

Email: *

Verification: *

While working on a pull request, you realize a much better approach exists. Which actions could you take?

• A.Make the changes on your branch and use git push -force to overwrite the existing remote branch.
• B.Close the original pull request, create a new branch, and open a new pull request.
• C.Add new commits to the existing branch, explaining the change of direction in the comments on the pull request.
• D.Avoid introducing major changes during a pull request, as it hinders effective code review.

Comment: *

Name: *

Email: *

Verification: *

Which command materializes my_model and only its first-degree parent model(s) in the data platform?
Choose 1 option.

• A.dbt run --select +my_model
• B.dbt compile --select +my_model
• C.dbt run --select 1+my_model
• D.dbt run --select +1 my_model
• E.dbt compile --select +1 my_model

Comment: *

Name: *

Email: *

Verification: *

Your baseline comparison tests start failing intermittently. Data distributions change slightly from day to day, sometimes triggering the thresholds. Which strategy could make your tests more robust?

• A.Rewriting your SQL to compare averages or medians instead of exact value counts-
• B.Introducing configurable tolerances into your test definitions.
• C.Scheduling the tests to run less frequently (e.g., weekly rather than daily).
• D.Removing the baseline comparison tests entirely, as they provide unreliable signals.

Comment: *

Name: *

Email: *

Verification: *

You identify the need to refactor several models with similar transformations. Which of the following is the first step to increase modularity and promote the DRY philosophy?

• A.Create CTEs to segment logical steps within the existing model SQL.
• B.Use a text editor's "find and replace" function to update repetitive code blocks.
• C.Analyze commonalities and differences in the transformations to determine refactoring potential.
• D.Test individual models thoroughly to establish a baseline before making changes.

Comment: *

Name: *

Email: *

Verification: *