[Solved] Given the following dbt model SQL snippet, what will be the value... SELECT score, CASE WHEN score >= 90 THEN 'Excellent' WHEN score >= 70 THEN 'Good' ELSE 'Average' END AS status FROM scores_table | dbt

dbt - Jinja in dbt

Given the following dbt model SQL snippet, what will be the value of status for a row where score = 75?

SELECT
  score,
  CASE
    WHEN score >= 90 THEN 'Excellent'
    WHEN score >= 70 THEN 'Good'
    ELSE 'Average'
  END AS status
FROM scores_table

A'Good'

BNULL

C'Average'

D'Excellent'

Step-by-Step Solution

Solution:

Step 1: Check conditions in order for score = 75
First condition: score >= 90? No (75 < 90). Second condition: score >= 70? Yes (75 >= 70).
Step 2: Determine which condition applies first
The first true condition is WHEN score >= 70 THEN 'Good', so status = 'Good'.
Final Answer:
'Good' -> Option A
Quick Check:
75 >= 70 = 'Good' [OK]

Quick Trick: Check CASE conditions top to bottom [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given the following dbt model SQL snippet, what will be the value of status for a row where score = 75?