Topic 1 Question 59
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?
BigQuery
Cloud SQL
Cloud BigTable
Cloud Datastore
解説
Reference: https://cloud.google.com/sql/

ユーザの投票
コメント(17)
- 正解だと思う選択肢: B
It needs support for transaction so cloud sql is the choice of database and with Bigquery we can still analyze cloud sql data via federated queries https://cloud.google.com/bigquery/docs/reference/legacy-sql
👍 4DipT2022/12/16 - 正解だと思う選択肢: B
B. 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 allows for easy management and analysis of data using SQL. It is well-suited for applications built on Google App Engine and can handle the transactional workload of an e-commerce application, as well as the analytical workload of a BI tool.
👍 4PolyMoe2023/01/26 - 正解だと思う選択肢: B
B is the answer.
https://cloud.google.com/bigquery/docs/cloud-sql-federated-queries BigQuery Cloud SQL federation enables BigQuery to query data residing in Cloud SQL in real time, without copying or moving data. Query federation supports both MySQL (2nd generation) and PostgreSQL instances in Cloud SQL.
👍 3zellck2022/12/07
シャッフルモード