Level 5 - SeniorOutput Prediction Questions
Output: Composite Index Usability
Interviewer prompt: Given index (tenant_id, created_at DESC), which query can best use it for ordered top-N results? Answer with A or B. A) WHERE tenant_id = 8 ORDER BY created_at DESC LIMIT 20 B) WHERE created_at >= '2026-01-01' ORDER BY tenant_id LIMIT 20