nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #174

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #174: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #174. The question stem and answer options stay visible for context.

Database Reliability and Recoverability

Question

You are designing the backup and recovery strategy of a Cloud SQL for MySQL database that serves a write heavy application. You need to be able to restore the database to any point in time within the past five days while minimizing the performance impact of database backups. What should you do-

Options

  • AEnable automatic backup and point in time recovery. Configure the backup window during periods
  • BSchedule hourly on-demand backups and enable point in time recovery. Delete any delete
  • CSchedule a database export job to run every hour from a read replica instance. Retain the export
  • DSchedule a database export job to run every hour. Use serverless export. Retain the export dumps

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.

Topics

#Cloud SQL#Backup and Recovery#Point-in-Time Recovery#Performance Optimization
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions