Crucial Exams

GCP Associate Cloud Engineer Practice Question

Your operations team manages an AlloyDB for PostgreSQL primary cluster that supports a busy retail web application. The DBA must ensure that if an accidental DELETE is run, the team can recover to any specific second that occurred within the last 24 hours without interrupting the running production cluster. The solution should rely on native Google Cloud features and require as little ongoing maintenance as possible. What should you do?

  • Set up logical replication to a standby cluster in another region and fail over to that cluster when data is lost.

  • Take periodic persistent-disk snapshots of the primary instance's disks and use them to rebuild the cluster when necessary.

  • Enable continuous automated backups with a 24-hour retention window, then use a point-in-time restore to create a new cluster at the required timestamp.

  • Schedule an on-demand backup every night and, if needed, restore that backup to a new cluster.

GCP Associate Cloud Engineer
Ensuring successful operation of a cloud solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot