Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Last updated
A retail organization hosts its production environment on Google Cloud. The environment includes a Cloud SQL relational database storing customer transactions and a Cloud Storage bucket storing product media files and receipt documents.
The database administrator needs to implement a recovery strategy that fulfills two specific requirements:
Which combination of recovery mechanisms should the organization implement?
Configure high availability (HA) with regional failover for Cloud SQL, and configure Customer-Managed Encryption Keys (CMEK) on the Cloud Storage bucket.
Schedule daily database SQL exports to Cloud Storage for Cloud SQL, and configure Dual-Region bucket replication for Cloud Storage.
Create on-demand backups prior to instance deletion in Cloud SQL, and apply Object Lifecycle Management deletion rules on the Cloud Storage bucket.
Enable point-in-time recovery (PITR) with automated backups for Cloud SQL, and enable Object Versioning on the Cloud Storage bucket.
Configure high availability (HA) with regional failover for Cloud SQL, and configure Customer-Managed Encryption Keys (CMEK) on the Cloud Storage bucket.
Schedule daily database SQL exports to Cloud Storage for Cloud SQL, and configure Dual-Region bucket replication for Cloud Storage.
Create on-demand backups prior to instance deletion in Cloud SQL, and apply Object Lifecycle Management deletion rules on the Cloud Storage bucket.
Enable point-in-time recovery (PITR) with automated backups for Cloud SQL, and enable Object Versioning on the Cloud Storage bucket.
This solution pairs Cloud SQL Point-in-Time Recovery (PITR)—supported by write-ahead/transaction logging and automated backups—with Cloud Storage Object Versioning to protect structured relational data and unstructured object data against accidental loss or modification.
Point-in-time recovery is the only native Cloud SQL mechanism capable of restoring to an arbitrary minute before a human error or data corruption event. Similarly, Object Versioning is the standard Cloud Storage feature designed specifically to preserve and restore overwritten versions of objects without having to restore entire storage systems.
StudyCerts
StudyCerts