You want to store JSON data and frequently query nested keys with fast performance. Which approach is best?

hard📝 Application Q15 of 15

PostgreSQL - JSON and JSONB

AStore data as <code>json</code> and create expression indexes on keys

BStore data as <code>jsonb</code> and create a GIN index on the column

CStore data as text and parse JSON in application code

DStore data as <code>jsonb</code> but avoid indexes for faster inserts

Step-by-Step Solution

Solution:

Step 1: Choose data type for fast queries
jsonb is optimized for querying and indexing nested JSON data.
Step 2: Use appropriate indexing
Creating a GIN index on the jsonb column enables fast key and path lookups.
Final Answer:
Store data as jsonb and create a GIN index on the column -> Option B
Quick Check:
jsonb + GIN index = best for fast nested queries [OK]

Quick Trick: Use jsonb with GIN index for fast nested JSON queries [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