nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #31

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

The correct answer is A: Use Cloud SQL serverless exports.. https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports

Managing and Maintaining Database Solutions

Question

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

Options

  • AUse Cloud SQL serverless exports.
  • BCreate a read replica, and then use the mysqldump utility to export each table.
  • CClone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
  • DUse the mysqldump utility on the primary database instance to export the backup.

Explanation

https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports

Topics

#Cloud SQL for MySQL#Database Backup#Managed Exports#Operational Best Practices

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions