
Answer-first summary for fast verification
Answer: Firestore in Native mode
The correct answer is Firestore in Native mode (A). The requirements include immediate queryability after submission (strong consistency), sorting on various fields (indexing support), and handling distinct record formats (schema flexibility). Firestore in Native mode offers strong consistency, allows creating indexes on multiple fields for sorting, and is a NoSQL database that supports flexible schemas. Cloud Storage (B) is for object storage, not structured querying. Cloud SQL (C) requires a fixed schema, which conflicts with storing distinct formats. Firestore in Datastore mode (D) uses eventual consistency for global queries, risking delayed visibility of new data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company requires a database solution to store customer purchase history with the following conditions:
Which storage option meets these requirements?
A
Firestore in Native mode
B
Cloud Storage using an object read
C
Cloud SQL using a SQL SELECT statement
D
Firestore in Datastore mode using a global query