ExpertEasy1 markMultiple Choice
GCP ACE · Question 15 · Domain 2.3: Planning and configuring data storage options
Your company is migrating an on-premises MySQL database to Google Cloud. The database is 500 GB in size. The application requires full MySQL compatibility, high availability within a single region, and automatic backups. The team wants to minimize database administration overhead.
Which Google Cloud database service should you choose?
Your company is migrating an on-premises MySQL database to Google Cloud. The database is 500 GB in size. The application requires full MySQL compatibility, high availability within a single region, and automatic backups. The team wants to minimize database administration overhead.
Which Google Cloud database service should you choose?
Answer options:
A.
Cloud Spanner
B.
Cloud SQL
C.
BigQuery
D.
Compute Engine with MySQL installed
How to approach this question
Identify the key requirements: Relational (MySQL), fully managed (minimize overhead), regional HA, and size (500 GB).
Full Answer
B.Cloud SQL✓ Correct
Cloud SQL
Cloud SQL is the fully managed relational database service in GCP. It supports MySQL, PostgreSQL, and SQL Server. It handles backups, replication, and high availability automatically. Since the database is 500 GB (well under the 64 TB limit) and requires MySQL compatibility, Cloud SQL is the perfect fit.
Common mistakes
Choosing Cloud Spanner because of 'high availability', but missing that Spanner is for massive, global scale and lacks native MySQL drop-in compatibility.
Practice the full GCP Associate Cloud Engineer Practice Exam 5
50 questions · hints · full answers · grading
More questions from this exam
Q01You are starting a new initiative and need to create a new Google Cloud project using the command...EasyQ02A developer on your team needs to manage App Engine applications, including deploying new version...MediumQ03You have created a new Google Cloud project. You need to allow a specific group of developers to ...MediumQ04Which statement best describes the relationship between Google Cloud projects and billing accounts?EasyQ05Your company wants to be notified immediately in their Slack channel whenever their monthly Googl...Medium