YAML cares about spelling and indentation. The others are valid parts of source definition syntax.
Question 127
What must happen before you can build models in dbt? Choose 1 option.
Correct Answer: C
The correct answer is C: Underlying data must be accessible on your data platform. dbt does not perform data ingestion or data loading. Instead, dbt operates after raw data is already available in your warehouse. This means that before dbt can build any models-whether staging, intermediate, or mart- layer models-the underlying source data must already exist and be accessible in the connected data platform (Snowflake, BigQuery, Redshift, Databricks, etc.). dbt uses SQL to transform existing relations; therefore, if the data platform cannot access the underlying tables or external sources, model execution will fail. Option A is incorrect because sources do not need to be defined before building models. Models can be built without using sources at all. Source definitions are optional metadata and lineage declarations, not prerequisites. Option B is incorrect because service accounts are not required; dbt can connect through any credential mechanism supported by the warehouse (OAuth, user accounts, tokens, etc.). Option D is incorrect because dbt itself performs transformations on raw data-cleaning raw data beforehand is not required; in fact, that is one of dbt's main responsibilities. Thus, the only true prerequisite is that the warehouse must contain accessible underlying data.
Question 128
A model fails with an error similar to:Numeric overflow converting to data type numeric(18,2)
Correct Answer: B
This error indicates data type limitations, causing computed values to fall outside the allowed range.
Question 129
You want to compare the current version of a file in your working directory to the most recently committed version. Which Git command would be most helpful?
Correct Answer: C
git diff shows line-by-line differences between versions, letting you compare your working version to the committed one (HEAD).
Question 130
(Multiple Select)
Correct Answer: A,C
Renaming or introducing nulls can directly break downstream SQL that references that column. B (adding data) is generally less disruptive. Column order (D) is usually irrelevant for analytics.
