A company runs a Cloud SQL for PostgreSQL database for a financial application. The database has PITR enabled with a 7-day retention. The compliance team requires that the database be restorable to any point in the last 30 days. The finance team wants to minimize storage costs. What should you do?

Increase automated backup retention to 30 days and keep PITR at 7 days.

Disable PITR and rely on automated backups with a 30-day retention.

Increase PITR log retention to 30 days and keep automated backups at the current frequency.

Create a manual backup every day and keep 30 backups.

A company has a Cloud SQL for PostgreSQL database with PITR enabled and a 7-day retention. The team has a documented recovery procedure but has never executed it. The compliance team requires that the recovery procedure be tested at least once a quarter. What should the team do?

Schedule a quarterly test restore to a new instance and verify the data.

Review the recovery documentation quarterly without performing a restore.

Create a manual backup quarterly and verify it is listed in the console.

Enable PITR with a longer retention to ensure more recovery points are available.

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 3

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

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 21–22

21expert · hard
A company runs a Cloud SQL for PostgreSQL database for a financial application. The database has PITR enabled with a 7-day retention. The compliance team requires that the database be restorable to any point in the last 30 days. The finance team wants to minimize storage costs. What should you do?
Select an answer first
22application · medium
A company has a Cloud SQL for PostgreSQL database with PITR enabled and a 7-day retention. The team has a documented recovery procedure but has never executed it. The compliance team requires that the recovery procedure be tested at least once a quarter. What should the team do?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.

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

Questions 21–22

A company runs a Cloud SQL for PostgreSQL database for a financial application. The database has PITR enabled with a 7-day retention. The compliance team requires that the database be restorable to any point in the last 30 days. The finance team wants to minimize storage costs. What should you do?

A company has a Cloud SQL for PostgreSQL database with PITR enabled and a 7-day retention. The team has a documented recovery procedure but has never executed it. The compliance team requires that the recovery procedure be tested at least once a quarter. What should the team do?

Keep studying — Manage a solution that can span multiple database technologies