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 Professional Cloud ArchitectGCP Professional Cloud Architect Practice Exam 6Question 38
    Medium1 markMultiple Choice
    Subtask 2.2: Storage SystemsDatabaseCloud SQLHigh AvailabilityDisaster Recovery

    GCP PCA · Question 38 · Storage Systems

    You are migrating a mission-critical MySQL database to Cloud SQL. The business requires that the database remains available even if an entire GCP zone goes offline, and they need the ability to recover the database to a specific point in time if a developer accidentally drops a table. Which TWO features must you enable? (Select TWO)

    Answer options:

    A.

    Cross-region read replicas

    B.

    Regional High Availability (HA)

    C.

    Point-in-time recovery (PITR)

    D.

    Cloud Storage multi-region backups

    E.

    Database Migration Service (DMS)

    How to approach this question

    Match the requirement 'survive a zone outage' to HA, and 'recover to a specific time' to PITR.

    Full Answer

    Regional High Availability (HA), Point-in-time recovery (PITR)
    Cloud SQL Regional HA provides synchronous replication to a standby instance in a different zone, ensuring automatic failover during a zonal outage. Point-in-time recovery (PITR) enables you to recover data from a specific point in time (down to a fraction of a second) using write-ahead logs, which is essential for recovering from human errors like dropping a table.

    Common mistakes

    Confusing Read Replicas (A) with HA. Read replicas are asynchronous and require manual failover; HA is synchronous and automatic.
    Question 37All questionsQuestion 39

    Practice the full GCP Professional Cloud Architect Practice Exam 6

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...MediumQ02CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...MediumQ03CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...HardQ04CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...MediumQ05CASE STUDY: TechStream Gaming Overview: Industry: Gaming Size: 500 employees, $100M revenue Env...Easy
    View all 50 questions →