Your application requires a managed database service that supports ACID transactions and offers seamless scalability. However, the application also has a read-heavy workload, and you are looking to balance cost with performance. Which database service should you choose?
Choose an answer
Tap an option to check your answer.
Correct answer: Cloud SQL with read replicas and automated backups..
Why this is the answer
*Explanation:* The ideal choice for a managed database service that supports ACID transactions, offers seamless scalability, and balances cost with performance for a read-heavy workload is Cloud SQL with read replicas and automated backups. Cloud Spanner with multi-region deployment is costly and may not be necessary for this scenario. Cloud Bigtable does not support ACID transactions. Firestore in Native mode may not provide the seamless scalability required for high loads. BigQuery is not a general-purpose transactional database and is designed for analytics rather than transactional workloads.
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