1Z0-1151-25 Question 43
Select 2You are managing an Autonomous Transaction Processing (ATP) instance for transactional workloads in Oracle Cloud Infrastructure and have deployed a MySQL Database Service with HeatWave for real-time analytics. Your goal is to continuously replicate new transactions from ATP to the MySQL HeatWave cluster, ensuring minimal latency and a reliable data pipeline. Which two actions must you perform to meet these requirements using recommended Oracle best practices?
- A
- Enable and configure Oracle GoldenGate on the Autonomous Transaction Processing instance to capture changes.
- B
- Configure Autonomous Data Guard for the ATP instance and set up replication to MySQL Database Service.
- C
- Install and configure Oracle GoldenGate for Big Data to apply captured changes into the MySQL HeatWave cluster.
- D
- Enable MySQL Binary Logging on the HeatWave cluster to read and synchronize changes from the Autonomous Database.
- E
- Create a direct database link from the MySQL HeatWave cluster to the ATP instance for real-time data pulls.
Show answer and explanation
Correct answers: A, C
Explanation
To replicate changes from an Oracle Autonomous Transaction Processing instance to a MySQL Database Service (with HeatWave) in near real-time, you must use Oracle GoldenGate. According to Oracle documentation and best practices, you enable and configure Oracle GoldenGate on the ATP side to capture changes, then use Oracle GoldenGate for Big Data (or a MySQL-compatible GoldenGate plugin) to apply the changes into the MySQL HeatWave cluster. Autonomous Data Guard, MySQL Binary Logging, or a direct database link do not adequately support cross-engine replication for this scenario.
- A. Correct.
Option 1 is correct. Oracle GoldenGate must be enabled on the ATP instance so that changes (transactions) can be captured.
- B. Incorrect.
Option 2 is incorrect. Autonomous Data Guard protects data within Oracle Databases, but it cannot directly replicate data to MySQL Database Service. Data Guard is not designed for cross-engine replication to MySQL.
- C. Correct.
Option 3 is correct. Oracle GoldenGate for Big Data (or the MySQL-specific GoldenGate plugin) is required to apply data changes from Oracle Autonomous Database to the MySQL HeatWave cluster in near real-time.
- D. Incorrect.
Option 4 is incorrect. Enabling MySQL Binary Logging is useful if you want to replicate from MySQL to another MySQL, but it does not directly help replicate changes from Oracle ATP to MySQL HeatWave.
- E. Incorrect.
Option 5 is incorrect. Creating a direct database link from MySQL to an Oracle Autonomous Database is not a supported approach for near real-time transactional replication. Oracle GoldenGate is the recommended solution.