You're reviewing a pull request and notice a subtle logic error that wasn't caught in automated tests. How do you best approach this within the code review?

• A.Simply fix the error directly in the pull request without leaving a comment.
• B.Leave a comment explaining the error and provide a suggestion for how to fix it.
• C.Create a separate issue in the issue tracker, detail the bug, and reference it in the pull request.
• D.Reject the pull request outright and ask the author to fix the error and resubmit.

Comment: *

Name: *

Email: *

Verification: *

You're merging changes from a feature branch into your main branch. Which of the following Git commands or strategies help keep a clean and easy-to-follow project history?

• A.Using git merge to create a merge commit.
• B.Utilizing git rebase main before merging to linearize the history.
• C.Employing git squash merge for condensing feature branch commits.
• D.All of the above can be valid strategies, each with different trade-offs.

Comment: *

Name: *

Email: *

Verification: *

You're onboarding new developers to your dbt project. To simplify their setup, you want to provide a standard profiles.yml template. What should you consider when doing this?

• A.Prepopulating common credentials to make the initial setup hassle-free.
• B.Referencing environment variables to allow for easy customization by developers.
• C.Including different target configurations to illustrate switching between development and production.
• D.Providing example dbt commands as comments directly within the file to guide new users.

Comment: *

Name: *

Email: *

Verification: *

You're setting up a new dbt project on a recently provisioned data warehouse. What actions are essential before your initial development begins?

• A.Defining and implementing a schema and naming conventions for your dbt models within the data warehouse.
• B.Establishing access controls and user roles specific to the dbt project's requirements.
• C.Configuring monitoring and alerting to track data warehouse usage and events related to dbt jobs
• D.All of the above

Comment: *

Name: *

Email: *

Verification: *

Given this dbt_project.yml:
name: "jaffle_shop"
version: "1.0.0"
config-version: 2
profile: "snowflake"
model-paths: ["models"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]
target-path: "target"
clean-targets:
- "logs"
- "target"
- "dbt_modules"
- "dbt_packages"
models:
jaffle-shop:
+materialized: table
...and this warning when compiling your project:
[WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
There are 1 unused configuration paths:
- models.jaffle-shop
What is the root cause?
A run hook in the jaffle_shop project was defined with an incorrect regular expression.

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *