Google Cloud Professional Data Engineer — Question 334

An online retailer has built their current application on Google App Engine. A new initiative at the company mandates that they extend their application to allow their customers to transact directly via the application. They need to manage their shopping transactions and analyze combined data from multiple datasets using a business intelligence (BI) tool. They want to use only a single database for this purpose. Which Google Cloud database should they choose?

Answer options

Correct answer: B

Explanation

Cloud SQL is the best option because it provides a relational database that supports transactions and can be integrated well with BI tools for data analysis. BigQuery is more suited for large-scale analytics rather than transactional processing, while Cloud BigTable is designed for high throughput and low latency but is not ideal for transactional workloads. Cloud Datastore is a NoSQL database, which may not effectively handle the relational data needs for shopping transactions.