63 real dbt Advanced questions from the Data Engineering bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.
1. What is dbt Fusion?
Junior
A.A dbt layer where metrics are defined once centrally and queried consistently, so every tool computes the same numbers.
B.A dbt config that enforces a model's declared column names, data types, and constraints at build time, failing if the output does not match.
C.A dbt model property (private, protected, public) that controls which projects or groups may ref a model, enforcing API boundaries in dbt Mesh.
D.A 2025 ground-up rewrite of the dbt engine in Rust with native SQL comprehension, offering much faster parsing and compilation than dbt Core.
2. Which term means: "A 2025 ground-up rewrite of the dbt engine in Rust with native SQL comprehension, offering much faster parsing and compilation than dbt Core."?
A.dbt Fusion — An incremental-model config controlling how dbt reacts to source column changes, with options ignore, fail, append_new_columns, and sync_all_columns.
B.dbt Fusion — A 2025 ground-up rewrite of the dbt engine in Rust with native SQL comprehension, offering much faster parsing and compilation than dbt Core.
C.dbt Fusion — A dbt test that validates a model's SQL logic against small fixed mock inputs and expected output, run without touching warehouse data.
D.dbt Fusion — A dbt config that enforces a model's declared column names, data types, and constraints at build time, failing if the output does not match.
A.dbt Mesh — A pattern for splitting a monolithic dbt project into multiple governed projects that reference each other across boundaries.
B.dbt Mesh — A dbt model property (private, protected, public) that controls which projects or groups may ref a model, enforcing API boundaries in dbt Mesh.
C.dbt Mesh — An incremental strategy that deletes target rows matching the new batch's keys and then inserts the batch, used on Snowflake and Redshift.
D.dbt Mesh — An incremental strategy that replaces whole partitions of the target with new data rather than row-level merging, common on BigQuery and Spark.
8. Which term means: "A dbt model property (private, protected, public) that controls which projects or groups may ref a model, enforcing API boundaries in dbt Mesh."?
A.access modifier — A dbt layer where metrics are defined once centrally and queried consistently, so every tool computes the same numbers.
B.access modifier — A dbt model property (private, protected, public) that controls which projects or groups may ref a model, enforcing API boundaries in dbt Mesh.
C.access modifier — A dbt node that documents a downstream use of project data (a dashboard or app), making it a tracked dependency in lineage and freshness.
D.access modifier — A dbt test that validates a model's SQL logic against small fixed mock inputs and expected output, run without touching warehouse data.
A.Semantic Layer — A dbt config that enforces a model's declared column names, data types, and constraints at build time, failing if the output does not match.
B.Semantic Layer — A dbt layer where metrics are defined once centrally and queried consistently, so every tool computes the same numbers.
C.Semantic Layer — A pattern for splitting a monolithic dbt project into multiple governed projects that reference each other across boundaries.
D.Semantic Layer — A dbt check comparing the max loaded-at timestamp of a source table against warn_after and error_after thresholds to detect stale upstream data.
14. Which term means: "The dbt engine that compiles semantic metric definitions into correct warehouse SQL, handling joins, aggregations, and time grains."?
A.MetricFlow — A dbt model property (private, protected, public) that controls which projects or groups may ref a model, enforcing API boundaries in dbt Mesh.
B.MetricFlow — An incremental strategy that upserts using a unique_key, updating matched rows and inserting new ones in a single MERGE statement.
C.MetricFlow — Using a stored manifest with the state: selector and dbt build --select state:modified to run only changed models in CI (slim CI).
D.MetricFlow — The dbt engine that compiles semantic metric definitions into correct warehouse SQL, handling joins, aggregations, and time grains.
17. Which term means: "Using a stored manifest with the state: selector and dbt build --select state:modified to run only changed models in CI (slim CI)."?
A.dbt state comparison — Using a stored manifest with the state: selector and dbt build --select state:modified to run only changed models in CI (slim CI).
B.dbt state comparison — The dbt engine that compiles semantic metric definitions into correct warehouse SQL, handling joins, aggregations, and time grains.
C.dbt state comparison — A 2025 ground-up rewrite of the dbt engine in Rust with native SQL comprehension, offering much faster parsing and compilation than dbt Core.
D.dbt state comparison — A dbt model that captures slowly changing dimension history by recording row versions over time into a snapshot table.
20. Which term means: "A dbt check comparing the max loaded-at timestamp of a source table against warn_after and error_after thresholds to detect stale upstream data."?
A.source freshness — A dbt config that enforces a model's declared column names, data types, and constraints at build time, failing if the output does not match.
B.source freshness — SQL statements dbt runs immediately before or after building a model, used for grants, vacuuming, or auditing.
C.source freshness — Using a stored manifest with the state: selector and dbt build --select state:modified to run only changed models in CI (slim CI).
D.source freshness — A dbt check comparing the max loaded-at timestamp of a source table against warn_after and error_after thresholds to detect stale upstream data.
A.An incremental strategy that upserts using a unique_key, updating matched rows and inserting new ones in a single MERGE statement.
B.A dbt layer where metrics are defined once centrally and queried consistently, so every tool computes the same numbers.
C.An incremental-model config controlling how dbt reacts to source column changes, with options ignore, fail, append_new_columns, and sync_all_columns.
D.A dbt model that captures slowly changing dimension history by recording row versions over time into a snapshot table.
A.snapshot — A 2025 ground-up rewrite of the dbt engine in Rust with native SQL comprehension, offering much faster parsing and compilation than dbt Core.
B.snapshot — A dbt model that captures slowly changing dimension history by recording row versions over time into a snapshot table.
C.snapshot — The dbt engine that compiles semantic metric definitions into correct warehouse SQL, handling joins, aggregations, and time grains.
D.snapshot — A dbt layer where metrics are defined once centrally and queried consistently, so every tool computes the same numbers.
A.timestamp snapshot strategy — A dbt model that captures slowly changing dimension history by recording row versions over time into a snapshot table.
B.timestamp snapshot strategy — A dbt node that documents a downstream use of project data (a dashboard or app), making it a tracked dependency in lineage and freshness.
C.timestamp snapshot strategy — A 2025 ground-up rewrite of the dbt engine in Rust with native SQL comprehension, offering much faster parsing and compilation than dbt Core.
D.timestamp snapshot strategy — A snapshot strategy that detects changes by comparing an updated_at column, treating a newer timestamp as a changed row.
29. Which term means: "A snapshot strategy that detects changes by comparing a chosen set of columns for any difference, used when no reliable updated_at exists."?
A.check snapshot strategy — An incremental strategy that upserts using a unique_key, updating matched rows and inserting new ones in a single MERGE statement.
B.check snapshot strategy — A dbt model property (private, protected, public) that controls which projects or groups may ref a model, enforcing API boundaries in dbt Mesh.
C.check snapshot strategy — A snapshot strategy that detects changes by comparing a chosen set of columns for any difference, used when no reliable updated_at exists.
D.check snapshot strategy — A dbt layer where metrics are defined once centrally and queried consistently, so every tool computes the same numbers.
Showing 30 of 63 dbt Advanced questions — the full set, with answers, explanations and an AI tutor on every question, is inside.
Free to start
Answers, AI explanations, and a scored voice mock interview
Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.