ExpertEasy1 markMultiple Choice
GCP PCA · Question 25 · Storage Systems
A development team is building a new application that requires a relational database. The database will be deployed in a single region, needs to support up to 10 TB of data, and requires automated backups and high availability. Which GCP service should you recommend?
A development team is building a new application that requires a relational database. The database will be deployed in a single region, needs to support up to 10 TB of data, and requires automated backups and high availability. Which GCP service should you recommend?
Answer options:
A.
Cloud Spanner
B.
Cloud SQL
C.
Cloud Bigtable
D.
Firestore
How to approach this question
Match the requirements (relational, single region, < 64TB) to the correct managed database.
Full Answer
B.Cloud SQL✓ Correct
Cloud SQL is the ideal choice for regional relational database workloads up to 64 TB. It provides fully managed MySQL, PostgreSQL, and SQL Server with built-in high availability (regional failover) and automated backups. Cloud Spanner would be used if the requirement was for global horizontal scaling or > 64 TB.
Common mistakes
Selecting Cloud Spanner for small, regional workloads, resulting in unnecessary costs.
Practice the full GCP Professional Cloud Architect Practice Exam 1
50 questions · hints · full answers · grading
More questions from this exam
Q01**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...HardQ02**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...MediumQ03**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...HardQ04**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...MediumQ05**CASE STUDY: TechStream Gaming**
**Company Overview:** TechStream Gaming is a global gaming com...Medium