What happens if you try to run a Firestore query with multiple inequality filters on different fields without a composite index?

easy📝 Conceptual Q1 of 15

GCP - Cloud Firestore and Bigtable

AThe query will fail and Firestore will prompt to create a composite index.

BThe query will succeed but return incomplete results.

CThe query will ignore all inequality filters except the first.

DThe query will automatically create the needed index.

Step-by-Step Solution

Solution:

Step 1: Understand Firestore's index requirements for inequality filters
Firestore requires composite indexes for queries with inequality filters on multiple fields.
Step 2: Behavior when missing composite index
If the index is missing, Firestore returns an error with a link to create the index.
Final Answer:
The query will fail and Firestore will prompt to create a composite index. -> Option A
Quick Check:
Missing composite index = query fails with prompt [OK]

Quick Trick: Multiple inequality filters need composite indexes [OK]

Common Mistakes:

Master "Cloud Firestore and Bigtable" in GCP

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More GCP Quizzes