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 3Question 28
    Medium1 markMultiple Choice
    Domain 3.4: Deploying and implementing data solutionsDomain 3.4Cloud SQLHigh AvailabilityDatabases

    GCP ACE · Question 28 · Domain 3.4: Deploying and implementing data solutions

    You are initializing a new Cloud SQL for PostgreSQL instance for a production application. The database must be highly available and able to survive a zone failure with zero data loss and minimal downtime.

    Which TWO configuration choices must you make during initialization? (Select TWO)

    Answer options:

    A.

    Select 'Zonal' availability.

    B.

    Select 'Regional' availability.

    C.

    Enable automatic backups.

    D.

    Create a read replica in a different region.

    E.

    Enable Cloud Spanner integration.

    How to approach this question

    Understand the requirements for High Availability (HA) in Cloud SQL.

    Full Answer

    To configure High Availability (HA) in Cloud SQL, you must select 'Regional' availability. This provisions a primary instance and a standby instance in a different zone with synchronous replication. Furthermore, Cloud SQL requires automatic backups to be enabled in order to support HA configurations.

    Common mistakes

    Confusing Read Replicas (which are asynchronous and manual failover) with Regional HA (which is synchronous and automatic failover).
    Question 27All questionsQuestion 29

    Practice the full GCP Associate Cloud Engineer Practice Exam 3

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01You are starting a new project in Google Cloud and need to create a new GCP project and enable th...EasyQ02A new team member has joined your operations team. They need to be able to view all Compute Engin...MediumQ03Your company is migrating to Google Cloud. You currently manage all employee identities in an on-...MediumQ04Your development team is experimenting with new GCP services in a sandbox project. The finance te...MediumQ05Your company wants to perform complex, custom SQL analysis on their Google Cloud billing data to ...Easy
    View all 50 questions →