Databases Practice Questions

Relational, document and wide-column store selection. 8 original questions with full explanations.

Question 1 of 8

0 answered · 8 remaining

Databasesmedium

A mobile application must let users read and edit their data while offline, synchronising automatically when connectivity returns. Which database supports this natively?

aFirestorebCloud SQLcBigQuerydBigtable

Select an answer to see the explanation.

These questions are written by GCP Prep to test understanding of publicly documented concepts. They are not real exam questions.

One concept per question. If you can explain each of these without hesitating, you are in good shape on Databases.

Firestore's client libraries provide offline persistence and automatic synchronisation
Spanner is the option combining horizontal scale with strong global consistency
Sequential row keys create hotspots because Bigtable distributes contiguous key ranges
RPO is data loss tolerance; RTO is downtime tolerance
Connection pooling decouples application concurrency from database connection count
High availability provides automatic failover; read replicas do not
Continuous replication minimises the cutover window
Bigtable targets very high throughput key lookups over very large datasets