Google Cloud Professional Cloud Database Engineer — Question 74

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

Answer options

• A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
• B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
• C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
• D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

Correct answer: B

Explanation

Option B is correct as it combines the capabilities of Bare Metal Solution for Oracle and Actifio to ensure efficient backup to Cloud Storage, meeting the required RTO and RPO. Option A and D do not leverage cloud storage effectively and rely on on-premises tapes, which may not meet the recovery objectives. Option C, while utilizing Cloud Storage, does not incorporate the Actifio solution, which is designed for efficient backup management.