Bird
0
0

If you run dbt run --target dev but your profiles.yml does not have a dev target defined, what will happen?

medium📝 Predict Output Q5 of 15
dbt - Production Deployment
If you run dbt run --target dev but your profiles.yml does not have a dev target defined, what will happen?
Adbt will run using the default target
Bdbt will throw an error and stop
Cdbt will connect to production database
Ddbt will create a new dev target automatically
Step-by-Step Solution
Solution:

  1. Step 1: Understand target requirement

    dbt requires the target to be defined in profiles.yml.

  2. Step 2: Behavior on missing target

    If target is missing, dbt throws an error and stops.

  3. Final Answer:

    dbt will throw an error and stop -> Option B

  4. Quick Check:

    Missing target = error A [OK]
Quick Trick: Missing target in profiles.yml causes error [OK]
Common Mistakes:
MISTAKES
  • Assuming dbt uses default target silently
  • Thinking dbt auto-creates targets
  • Believing it connects to prod by default

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes
Advanced Patterns - Why advanced patterns solve complex analytics - Quiz 13medium Advanced Patterns - Why advanced patterns solve complex analytics - Quiz 7medium Advanced Patterns - Snapshot tables for historical tracking - Quiz 14medium Governance and Collaboration - PR review workflows for dbt changes - Quiz 12easy Governance and Collaboration - Group-based ownership - Quiz 3easy Performance Optimization - Clustering and partitioning - Quiz 14medium Production Deployment - Why production dbt needs automation - Quiz 13medium Production Deployment - Orchestrating dbt with Airflow - Quiz 6medium Production Deployment - Why production dbt needs automation - Quiz 11easy Production Deployment - dbt Cloud deployment - Quiz 11easy