Free DBT Documentation & Version Control Questions and Answers

Question 1

Which command generates documentation for dbt models, tests, and sources?

Accepted Answer

dbt docs generate

Answer

The `dbt docs generate` command scans your dbt project, including models, sources, tests, and their descriptions, to create a comprehensive documentation website. This command produces static HTML files that provide a detailed overview of your data lineage, model definitions, and column descriptions. It's the first step in creating human-readable documentation for your data warehouse.

Question 2

Which file is commonly used to describe fields, columns, and tests in dbt models?

Accepted Answer

schema.yml

Answer

The `schema.yml` file (or any `.yml` file within your `models/` or `sources/` directories) is where you define metadata for your dbt resources. This includes descriptions for models, sources, and their individual columns, as well as defining tests to ensure data quality. It's crucial for documenting your data assets and enforcing data quality checks within your dbt project.

Question 3

Which dbt command is used to preview generated documentation in a local browser?

Accepted Answer

dbt docs serve

Answer

After generating the documentation files with `dbt docs generate`, the `dbt docs serve` command launches a local web server. This server hosts the generated documentation website, allowing you to view and interact with your project's documentation in a web browser. It provides an accessible way to explore your data models, lineage, and tests without needing to deploy the documentation externally.

Question 4

What is the purpose of writing descriptions in dbt models and columns?

Accepted Answer

To describe data models for users and developers

Answer

Writing clear descriptions for dbt models and columns is essential for data governance and collaboration. These descriptions provide context and meaning to the data, making it easier for both technical and non-technical users to understand what each model represents and what data each column contains. This significantly improves data discoverability, trust, and usability across the organization.

Question 5

Which version control system is most commonly used with dbt projects?

Accepted Answer

Git

Answer

Git is the most widely adopted version control system for software development, and it is also the standard for dbt projects. It allows teams to track changes to code, collaborate effectively, and manage different versions of their dbt models, tests, and configurations. Its distributed nature and robust branching/merging capabilities make it ideal for managing complex data transformation workflows.

DBT - Certified Data Build Tool Developer Practice Test

DBT - Certified Data Build Tool Developer Practice Test

Free DBT Documentation & Version Control Questions and Answers