Examkin

Soru

Zorluk: KolayManaging Storage and Database Solutions

A cloud engineer needs to ensure that a production Cloud SQL for MySQL instance can be restored to a specific point in time in the event of accidental data corruption. Which action should the engineer perform on the instance?

  1. Enable automated backups and binary logging on the Cloud SQL instance.Cevap
  2. B
    Configure an Object Lifecycle Management policy to transition the database storage class to Coldline.
  3. C
    Migrate the database tables to Cloud Bigtable to enable automated transactional point-in-time rollbacks.
  4. D
    Enable Uniform Bucket-Level Access on the Cloud SQL storage volume.

Cevap

Enable automated backups and binary logging on the Cloud SQL instance.
Enabling automated backups together with binary logging on Cloud SQL for MySQL records all database modifications, allowing the instance to be restored to any exact minute or transaction log state.

Adım Adım Çözüm

1
Identify the operational requirement for database recovery.
The requirement calls for point-in-time recovery (PITR) on a Cloud SQL for MySQL database.
Point-in-time recovery allows restoring data to a specific timestamp before corruption occurred.
2
Determine the mandatory GCP Cloud SQL configuration flags.
Automated backups must be enabled along with binary logging.
Binary logging records all write operations between backup snapshots, enabling precise point-in-time restoration.

Anahtar Kavram

Cloud SQL Backup and Point-in-Time Recovery Management
Bu soruyu puanla

Konular

Managing Storage and Database Solutions