Choose the most appropriate managed database for an internal transactional orders app requiring strong consistency, fast queries, and ACID multi-table transactions with minimal PostgreSQL code changes.
Choose an answer
Tap an option to check your answer.
Correct answer: Cloud SQL.
Why this is the answer
Cloud SQL is the most appropriate choice because it is a fully managed relational database service that supports PostgreSQL. This ensures strong consistency, fast queries, and ACID (Atomicity, Consistency, Isolation, Durability) multi-table transactions, which are critical for a transactional orders application. The PostgreSQL compatibility also minimizes code changes. Bigtable is a NoSQL wide-column database, not suitable for ACID multi-table transactions. BigQuery is a data warehouse for analytics, not operational transactional processing. Firestore is a NoSQL document database, which, while offering some transactional capabilities, is not designed for complex multi-table ACID transactions as efficiently as a relational database like Cloud SQL.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed