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 quote character used for string literals

Answer

How dbt formats YAML strings

Answer

The string delimiter for CSV seeds

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

Add a -- comment above the source SQL

Answer

Run dbt docs add-description

Answer

Edit the catalog.json artifact directly

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

Column-level configs

Answer

Model contracts

Answer

Tag-based test selection

Question 4

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

Accepted Answer

sources:*

Answer

source:*

Answer

src:*

Answer

raw:*

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 docs generate

Answer

dbt run --freshness

Answer

dbt test --freshness

Question 6

What is the default column delimiter used when dbt reads CSV seed files?

Accepted Answer

Comma (,)

Answer

Tab (	)

Answer

Pipe (|)

Answer

Semicolon (;)