A global company runs a Cloud Spanner instance with a multi-region configuration for a user-facing application. The compliance team requires a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 1 hour in the event of a regional outage. The operations team wants to minimize ongoing operational overhead. What should you do?

Enable PITR with a 5-minute log retention and rely on that for recovery.

Create a daily automated backup and restore it to a new instance in another region during a disaster.

Rely on Cloud Spanner's built-in multi-region replication and use backups only for disaster recovery testing.

Set up a separate Cloud Spanner instance in another region and continuously export data using Dataflow.

A database administrator wants to regularly test the backup and recovery procedures for a Cloud SQL instance. What is the best practice for testing?

Review the backup size and compare it to the database size.

Check the backup logs to ensure backups are being created successfully.

Restore the backup to a new instance and verify data integrity.

Run a query on the backup file to check for data.

A database administrator needs to design a backup solution for a Cloud SQL instance with an RTO of 1 hour and an RPO of 24 hours. Which backup strategy is most appropriate?

Enable point-in-time recovery with a retention of 1 day.

Take manual backups every 6 hours.

Use export to Cloud Storage every 12 hours.

Enable automatic daily backups with a retention of 7 days.

A company runs a Cloud Spanner instance for a global application. The team needs to export a table to Cloud Storage for a one-time data analysis. The table is 1 TB and the export must not affect the production workload. What should they use?

Use the Spanner API to run a SELECT * query and write the results to a local file, then upload to Cloud Storage.

Use the Cloud Spanner Dataflow connector to export the table to Avro files in Cloud Storage.

Use the gcloud spanner databases export command.

Create a backup of the database and then export the backup.

A company runs a Cloud SQL for PostgreSQL instance in us-central1. The business requires an RPO of 15 minutes and an RTO of 1 hour in the event of a regional outage. The team is considering setting up cross-region replication to us-east1. What is the primary benefit of this approach?

It reduces the cost of backups by storing them in the replica region.

It eliminates the need for automated backups.

It provides a read replica in another region that can be promoted to a primary instance, reducing downtime.

It automatically fails over without any manual intervention.

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 3

2.3 Design Database Backup and Recovery Solutions PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Part of the Manage a solution that can span multiple database technologies domain, which accounts for ~25% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

22questions here

5free pages

8concepts

~25%of the exam

8 Concepts in This Objective

Automatic scheduled backups
Manual backups and on-demand snapshots
Export and import data for databases
Recovery Time Objective (RTO) and Recovery Point Objective (RPO) design
Point-in-Time Recovery (PITR)
Data retention management
Backup and recovery for cross-region and multi-region databases
Testing and validating backup and recovery

Questions 11–15

11expert · hard
A global company runs a Cloud Spanner instance with a multi-region configuration for a user-facing application. The compliance team requires a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 1 hour in the event of a regional outage. The operations team wants to minimize ongoing operational overhead. What should you do?
Select an answer first
12foundation · easy
A database administrator wants to regularly test the backup and recovery procedures for a Cloud SQL instance. What is the best practice for testing?
Select an answer first
13foundation · easy
A database administrator needs to design a backup solution for a Cloud SQL instance with an RTO of 1 hour and an RPO of 24 hours. Which backup strategy is most appropriate?
Select an answer first
14application · medium
A company runs a Cloud Spanner instance for a global application. The team needs to export a table to Cloud Storage for a one-time data analysis. The table is 1 TB and the export must not affect the production workload. What should they use?
Select an answer first
15expert · hard
A company runs a Cloud SQL for PostgreSQL instance in us-central1. The business requires an RPO of 15 minutes and an RTO of 1 hour in the event of a regional outage. The team is considering setting up cross-region replication to us-east1. What is the primary benefit of this approach?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-CLOUD-DATABASE-ENGINEER” is a trademark of its owner, used for identification only.