DBT DBT Deployment & CI/CD 3

Question 1

Which dbt artifact is essential for enabling Slim CI state comparison?

Accepted Answer

manifest.json

Answer

catalog.json

Answer

run_results.json

Answer

sources.json

Question 2

What is the best practice for the `profiles.yml` target schema in a developer environment?

Accepted Answer

Use a personal schema prefixed with the developer's name

Answer

Use the shared production schema

Answer

Create a separate database for each developer

Answer

Use an in-memory SQLite database

Question 3

Which command verifies that your dbt project YAML and SQL are syntactically valid without connecting to a warehouse?

Accepted Answer

dbt parse

Answer

dbt validate

Answer

dbt lint

Answer

dbt check

Question 4

What does the `on-run-start` hook in dbt_project.yml execute?

Accepted Answer

SQL run before any model or test in the job

Answer

A Python script triggered when the server starts

Answer

SQL run after every model completes

Answer

A validation check before dbt installs packages

Question 5

Which dbt command installs packages listed in packages.yml?

Accepted Answer

dbt deps

Answer

dbt install

Answer

dbt packages install

Answer

dbt get

Question 6

In a dbt Cloud job schedule, what format is used to define cron-based run timing?

Accepted Answer

Standard 5-field cron expressions

Answer

ISO 8601 duration strings

Answer

Unix epoch intervals

Answer

Natural language strings like 'every hour'