Answer-first summary for fast verification
Answer: Cloud SQL
Cloud SQL would be the most appropriate choice for the online retailer in this scenario. Cloud SQL is a fully-managed relational database service that supports ACID transactions, which are essential for managing shopping transactions in an e-commerce application. Additionally, Cloud SQL can handle analytical workloads when connected with a BI tool, providing a single solution for managing and analyzing data. While BigQuery is excellent for analytics, it is not well-suited for transactional workloads, making Cloud SQL the better option.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
An online retailer, currently utilizing Google App Engine for their application, is embarking on a new initiative that requires extending their application to enable direct transactions for their customers. As part of this initiative, there is a need to manage shopping transactions and perform combined data analysis from multiple datasets using a business intelligence (BI) tool. Given the requirement to utilize only a single database for the entirety of this purpose, which Google Cloud database would be the most suitable choice?
A
BigQuery
B
Cloud SQL
C
Cloud BigTable
D
Cloud Datastore