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.
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?
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.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
StudyCerts
StudyCerts