How can you combine JSON support with relational data to store user profiles that have both fixed and flexible attributes?

hard📝 Application Q9 of 15

PostgreSQL - JSON and JSONB

AUse relational columns for fixed attributes and a JSONB column for flexible attributes.

BStore all data as JSON and ignore relational columns.

CUse only relational columns with NULLs for missing flexible data.

DStore flexible data in separate text columns.

Step-by-Step Solution

Solution:

Step 1: Understand data types
Fixed attributes fit well in relational columns; flexible data fits JSONB.
Step 2: Combine both for best design
Using relational columns plus JSONB column allows structured queries and flexibility.
Final Answer:
Use relational columns for fixed attributes and a JSONB column for flexible attributes. -> Option A
Quick Check:
Combine relational + JSONB for mixed data needs [OK]

Quick Trick: Mix relational columns with JSONB for flexible profiles [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free