Google Cloud Professional Cloud Database Engineer — Question 79

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

Answer options

• A. 1 Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on all flash storage. 3. Keep backups older than one day stored in Actifio OnVault storage.
• B. 1 Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on standard storage. 3. Keep backups older than one day stored in Actifio OnVault storage.
• C. 1. Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on standard storage. 3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
• D. 1. Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on all flash storage. 3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.

Correct answer: B

Explanation

The correct answer is B because it suggests using standard storage for local backups, which is a more cost-effective solution while still meeting the RTO and RPO requirements. Options A and D propose keeping backups on flash storage, which is more expensive, and option C suggests using Coldline Storage, which may not meet the 5-year retention requirement as effectively as Actifio OnVault storage.