You run a dbt job that heavily utilizes CT Es (Common Table Expressions). In your development environment, it works flawlessly. However, in production (a different database technology), it throws errors. Which potential causes should you investigate?
Correct Answer: A,B
Acan lead to different behavior under load. B different dialects have nuances about CTE support C is unlikely, D less probable than a dialect-specific issue.
Question 57
Which of the following is NOT a direct benefit of thorough source, table, and column descriptions in dbt?
Correct Answer: C
Explanation: While good descriptions have numerous benefits, they don't inherently speed up model compilation and execution within dbt-
Question 58
You encounter a runtime error: "Column 'order_date' not found in the target relation". You examine your model and see:SQL
Correct Answer: A
Start with the basics! This error typically indicates a schema mismatch between your assumption and the actual data structure.
Question 59
Which two statements about Exposures are true? Choose 2 options.
Correct Answer: C,E
The correct answers are C: Exposures describe a downstream use of your dbt project and E: You can run, test, and list resources that feed into your Exposure. Exposures in dbt are documentation constructs that describe how the outputs of your dbt project are used downstream-such as dashboards, machine learning models, applications, reporting layers, or external tools. They exist to provide visibility into the final layer of the analytics workflow, making it easier to track lineage from raw data # models # downstream consumers. Option C is correct because the official dbt documentation explicitly states that exposures define the downstream use cases of dbt models. They create transparency about dependencies outside the dbt DAG itself. Option E is also correct. Using commands like dbt ls --select +exposure:<name> or dbt run --select +exposure: <name>, dbt enables users to run, test, and inspect the upstream resources feeding into the exposure. This is extremely valuable for impact analysis and CI workflows. Option A is incorrect because exposures are downstream, not upstream-meaning models feed into exposures, not the other way around. Option B is incorrect because exposures are not materialized in the warehouse; they are metadata stored in YAML. Option D is incorrect because exposures are defined in YAML files, not SQL files. Thus, C and E are the correct statements.
Question 60
(Multiple Select)
Correct Answer: A,C
A and C are correct. A missing dependency will cause SQL errors, and nulls would likely occur where the dropped table's data was used. B is incorrect. Downstream models will often fail if an upstream model fails. D is incorrect. dbt's strict dependency handling is likely to stop the process and throw errors.
