Google Cloud Professional Cloud Database Engineer — Question 145

You are the DBA working at a large bank in Europe. Your business-critical banking application runs on Oracle 12.2 in your on-premises data center. You decided to modernize your on-premises Oracle database by migrating to AlloyDB. You must meet the following requirements:

• Remain on-premises and maintain open-source portability.
• Meet regulatory requirements for data residency.
• Support both OLTP and OLAP workloads.
• Maintain high availability (HA) mode and automatic failover.

What should you do?

Answer options

• A. Deploy AlloyDB Omni in a standalone VM on-premises, and set up disaster recovery (DR) in AlloyDB for PostgreSQL.
• B. Migrate to AlloyDB for PostgreSQL by using Database Migration Service.
• C. Deploy Kubernetes-based AlloyDB Omni database cluster on-premises. Enable HA by using the AlloyDB Omni Kubernetes operator, and migrate your Oracle database to Omni.
• D. Deploy AlloyDB Omni as a docker-based container in your on-premises VM, enable HA for it, and migrate your Oracle database to the Omni container.

Correct answer: C

Explanation

Option C is correct because deploying a Kubernetes-based AlloyDB Omni cluster allows for high availability and automatic failover, while meeting the requirement of remaining on-premises. Options A and D do not provide the same level of HA capabilities, and option B does not fulfill the requirement of maintaining on-premises deployment.