ExpertMedium1 markMultiple Choice
GCP ACE · Question 38 · Domain 4.4: Managing storage and database solutions
You are managing a Cloud SQL for PostgreSQL instance. You need to ensure you can recover the database to a specific point in time within the last 7 days in case of accidental data deletion. Which TWO features must be enabled? (Select TWO)
You are managing a Cloud SQL for PostgreSQL instance. You need to ensure you can recover the database to a specific point in time within the last 7 days in case of accidental data deletion. Which TWO features must be enabled? (Select TWO)
Answer options:
A.
Automated backups
B.
High Availability (Regional) configuration
C.
Point-in-time recovery (Write-Ahead Logging)
D.
Read Replicas
E.
Cloud Storage export
How to approach this question
Identify the two Cloud SQL features required to restore a database to an exact timestamp.
Full Answer
To perform a point-in-time recovery (PITR) in Cloud SQL, you must have automated backups enabled. PITR uses the automated backup as a base, and then replays the Write-Ahead Logs (WAL) up to the exact timestamp you specify. Therefore, both Automated Backups and Point-in-time recovery must be enabled.
Common mistakes
Selecting High Availability, thinking it protects against human error (data deletion). HA only protects against infrastructure failure.
Practice the full GCP Associate Cloud Engineer Practice Exam 1
50 questions · hints · full answers · grading
More questions from this exam
Q01What is the highest level of the Google Cloud resource hierarchy?EasyQ02You need to enable the Compute Engine API in a new project using the command line. Which command ...EasyQ03You are setting up a new GCP environment. You need to grant a group of developers access to view ...MediumQ04You want to receive an email notification when your GCP spending exceeds $1000 this month. What s...EasyQ05You need to analyze your GCP billing data using complex SQL queries to understand cost trends acr...Medium