1Z0-1151-25 Question 109
Single answerYour organization is deploying a mission-critical Oracle Database on Google Cloud for advanced analytics. You already have an Oracle Database instance running on Oracle Cloud Infrastructure (OCI). Management wants near real-time data replication between OCI and the new environment on Google Cloud, with minimal overhead and secure connectivity. Which approach should you take to achieve this goal?
- A
Use Oracle GoldenGate with a secure interconnection between OCI and Google Cloud for near real-time synchronization.
- B
Schedule daily export/import jobs using Oracle Data Pump and transfer the files over the public internet.
- C
Implement OS-level file copy of the Oracle Database data files from OCI to Google Cloud.
- D
Use nightly RMAN backup from OCI and manually restore the database on Google Cloud each morning.
Show answer and explanation
Correct answer: A
Explanation
In multicloud architectures where Oracle Database instances must stay synchronized across OCI and Google Cloud, Oracle GoldenGate provides a robust and low-latency solution. It handles transactional replication efficiently and securely, supporting mission-critical workloads. Refer to the Oracle GoldenGate documentation for recommended architectures and configuration best practices in cross-cloud deployments.
- A. Correct.
Option 1 is correct. Oracle GoldenGate is specifically designed for real-time, low-impact replication across different environments, including cross-cloud scenarios. When set up with secure networking (e.g., VPN or interconnect), it provides near real-time data synchronization with minimal overhead, making it ideal for mission-critical workloads.
- B. Incorrect.
Option 2 is incorrect. Data Pump export/import is valid for one-time or periodic bulk data moves but is not suitable for near real-time replication. In addition, transferring large dumps over the public internet introduces latency, security concerns, and operational overhead. This approach won�t meet the near real-time requirement.
- C. Incorrect.
Option 3 is incorrect. OS-level file transfer of Oracle data files is neither recommended nor feasible for active databases needing consistent real-time data replication. Oracle data files must maintain transactional integrity, and copy-based approaches risk data corruption unless the database is fully shut down or properly put in backup mode, which disrupts operations.
- D. Incorrect.
Option 4 is incorrect. Relying on nightly RMAN backups and manual restores is a valid disaster recovery approach but not intended for near real-time replication. You would experience data lag up to 24 hours and additional operational overhead for daily restores, failing the near real-time requirement.