Answer-first summary for fast verification
Answer: Cloud SQL
Cloud SQL emerges as the optimal choice for the retailer's requirements due to its fully managed relational database service supporting MySQL, PostgreSQL, and SQL Server. It excels in handling transactional workloads, crucial for online retail transactions, and can also accommodate the data analysis needs of business intelligence tools. While BigQuery is tailored for analyzing large datasets and Cloud BigTable for high-throughput, non-relational data, Cloud SQL uniquely balances transactional processing with analytical capabilities, making it the most suitable option for this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
An online retailer operates a Google App Engine-based application aimed at facilitating customer transactions, managing shopping transactions, and analyzing data from multiple datasets through a business intelligence tool. They prefer using a single database for all these purposes. Which Google Cloud database would best meet their needs?
A
Cloud BigTable
B
BigQuery
C
Cloud SQL
D
Cloud Datastore
No comments yet.