Google Professional Cloud Database Engineer Question 66
Single answerGoogle Cloud PlatformYour company is planning to migrate its on-premises relational database to Google Cloud. The database handles complex queries, supports multiple JOIN operations, and requires strong ACID compliance. Additionally, the database load fluctuates significantly throughout the day, and the solution must scale automatically based on demand. Which Google Cloud database solution would best meet these requirements?
- A
Cloud SQL
- B
BigQuery
- C
Firestore
- D
Cloud Spanner
Show answer and explanation
Correct answer: D
Explanation
The scenario involves migrating a relational database with requirements for strong ACID compliance, support for complex queries and JOIN operations, and the ability to handle fluctuating workloads with automatic scaling. Cloud Spanner is the only database solution on Google Cloud that meets all of these requirements, making it the best choice in this case.
- A. Incorrect.
Cloud SQL is a managed relational database service that supports ACID compliance and would work for many relational workloads. However, it is not designed for global scaling or extensive automatic scalability, which is required in this scenario.
- B. Incorrect.
BigQuery is primarily a data warehouse optimized for analytical queries and does not support transactional workloads or strong ACID compliance, making it unsuitable for this use case.
- C. Incorrect.
Firestore is a NoSQL document database designed for hierarchical data structures and does not support complex queries, JOIN operations, or strong ACID compliance, which are required in this scenario.
- D. Correct.
Cloud Spanner is a globally distributed, horizontally scalable relational database service that supports complex queries, multiple JOIN operations, strong ACID compliance, and automatic scaling. This makes it the most appropriate choice for the given requirements.