DBT Documentation & Version Control 2

Question 1

Which artifact produced by `dbt docs generate` holds column data types and table statistics gathered from the warehouse?

Accepted Answer

catalog.json

Answer

catalog.json is built by introspecting the warehouse, while manifest.json describes the project's parsed resources.

Question 2

What is the default port used by `dbt docs serve`?

Accepted Answer

8080

Answer

dbt docs serve hosts the documentation site on port 8080 unless --port is specified.

Question 3

Which syntax correctly defines a reusable doc block in a .md file?

Accepted Answer

{% docs order_status %} ... {% enddocs %}

Answer

Doc blocks are wrapped in {% docs name %} and {% enddocs %} and later referenced with the doc() function.

Question 4

How do you reference a doc block named order_status inside a YAML description?

Accepted Answer

description: '{{ doc("order_status") }}'

Answer

The doc() Jinja function pulls in the content of a named doc block.

Question 5

Which config pushes model and column descriptions into the warehouse as comments?

Accepted Answer

persist_docs

Answer

persist_docs with relation and/or columns set to true writes descriptions to the database objects.

DBT - Certified Data Build Tool Developer Practice Test