DBT Documentation & Version Control 5

Question 1

After a merge conflict appears in a model's .sql file, what is the correct next step?

Accepted Answer

Edit the file to remove conflict markers, then commit the resolution

Answer

Conflicts must be resolved manually by editing the markers and committing the result.

Question 2

To undo a bad commit already pushed to a shared branch, which is safest?

Accepted Answer

git revert to create an inverse commit

Answer

git revert preserves history, so collaborators are not left with divergent histories.

Question 3

Where does a dbt Cloud CI job build models for a pull request?

Accepted Answer

A temporary schema unique to that PR

Answer

CI jobs create a temporary schema named for the PR so production is untouched.

Question 4

How do you pin a hub package to a compatible range in packages.yml?

Accepted Answer

version: [">=1.0.0", "<2.0.0"]

Answer

Hub packages accept a version key that can be a string or a list defining a range.

Question 5

Which property declares multiple versions of a model in YAML?

Accepted Answer

versions:

Answer

The versions property, with latest_version and optional defined_in, supports model versioning.

DBT - Certified Data Build Tool Developer Practice Test