PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #120
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #120: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Question
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
Options
- ACreate a clone database from a read replica database, and restore the clone in the same region.
- BCreate a clone database from a read replica database, and restore the clone into a different zone.
- CUse the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to
- DUse the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.