For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeGCP Associate Cloud Engineer (ACE)GCP Associate Cloud Engineer Practice Exam 5Question 15
    Easy1 markMultiple Choice
    Domain 2.3: Planning and configuring data storage optionsDomain 2DatabasesCloud SQL

    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?

    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 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.
    Question 14All questionsQuestion 16

    Practice the full GCP Associate Cloud Engineer Practice Exam 5

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    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
    View all 50 questions →