Bird
0
0

Which prefix is commonly used in dbt to indicate a model that prepares raw data for further transformations?

easy📝 Conceptual Q2 of 15
dbt - Project Organization
Which prefix is commonly used in dbt to indicate a model that prepares raw data for further transformations?
Astg_
Bdim_
Cfct_
Dagg_
Step-by-Step Solution
Solution:

  1. Step 1: Identify common dbt prefixes

    In dbt, stg_ is used for staging models that clean and prepare raw data.

  2. Step 2: Differentiate from other prefixes

    dim_ is for dimension tables, fct_ for fact tables, and agg_ for aggregated data.

  3. Final Answer:

    stg_ -> Option A

  4. Quick Check:

    stg_ prefix = staging models [OK]
Quick Trick: stg_ means staging, the first step in data prep [OK]
Common Mistakes:
MISTAKES
  • Confusing dim_ with staging
  • Using fct_ for raw data
  • Assuming agg_ is for staging

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes
Advanced Testing - Store test failures for analysis - Quiz 5medium Advanced Testing - Unit testing dbt models - Quiz 2easy Advanced Testing - Unit testing dbt models - Quiz 8hard Incremental Models - Unique key for merge behavior - Quiz 12easy Jinja in dbt - if/else logic in models - Quiz 14medium Jinja in dbt - if/else logic in models - Quiz 15hard Jinja in dbt - Why Jinja makes SQL dynamic - Quiz 11easy Jinja in dbt - Calling macros across projects - Quiz 12easy Packages and Reusability - Creating your own dbt package - Quiz 13easy Project Organization - dbt_project.yml configuration - Quiz 5medium