Explanation:
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.
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