You need to run a dbt job that performs a long-running data cleansing operation. The job occasionally times out. Which of the following are potential solutions?

• A. Increase the timeout setting in your CI/CD tool or dbt job configuration.
• B. Use a dbt macro to retry the cleansing operation with a backoff strategy within the model itself-
• C. Schedule the job to run concurrently with other dbt models to maximize resource usage-
• D. Break the cleansing logic into multiple models, chaining them with dependencies-

You've added new tests to a dbt model but are unsure how to determine the test coverage. What's a practical first step?

• A. Review the compiled SQL files generated by dbt.
• B. Execute dbt test -select failing to identify any currently failing tests.
• C. Employ a code coverage tool specifically designed for SQL.
• D. Examine the output of dbt docs generate and dbt docs serve.

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

You want to implement a macro that displays a warning icon next to models in the DAG that haven't been tested. Which of the following would be necessary to make this work?

• A. All of the above.
• B. The ability for the macro to query the results of test executions from the dbt run-
• C. A custom CSS class for the warning icon and a way to apply it dynamically using the macro.
• D. Configuration in your dbt_projectyml file to associate models with the relevant tests.