DBT DBT Sources & Seeds 3

Question 1

What does the `quoting` config on a source control?

Accepted Answer

Whether column names are enclosed in quotes in generated SQL

Answer

The `quoting:` config specifies whether the database, schema, or identifier portions of a source reference are wrapped in quotes.

Question 2

How can you add a description to a source table in dbt?

Accepted Answer

Use the description: key in the source YAML block

Answer

The `description:` field in the source YAML becomes part of the dbt documentation site and catalog.

Question 3

Which dbt feature allows you to apply a test to all columns of a source table at once using a meta tag?

Accepted Answer

Column-level tests defined in schema.yml

Answer

Defining tests under each column in the sources YAML lets you attach generic tests like `not_null` or `unique` to individual source columns.

Question 4

What node selector prefix lets you run `dbt test` on only source tests?

Accepted Answer

sources:*

Answer

The `sources:` selector prefix targets source nodes, so `dbt test --select sources:` runs only source-defined tests.

Question 5

Which dbt command generates a freshness report for all sources that have a freshness block defined?

Accepted Answer

dbt source freshness

Answer

`dbt source freshness` scans each source table's `loaded_at_field` and writes results to `sources.json` in the target/ directory.

DBT - Certified Data Build Tool Developer Practice Test