1Z0-1151-25 Question 48
Select 3Your company is migrating data from an on-premises Oracle Database to an Autonomous Database in Oracle Cloud Infrastructure (OCI) for analytics, while also deploying MySQL Database HeatWave for real-time analytics of MySQL workloads. You need to achieve secure connectivity, consistent backups, and adequate resource scaling. Which three actions are recommended to address these requirements?
- A
- Use Oracle Data Pump for the initial data load from your on-premises Oracle Database to the Autonomous Database, then configure Oracle GoldenGate for continuous replication.
- B
- Configure a VCN peering between your on-premises network and the MySQL Database HeatWave VCN in OCI to enable secure data transfer.
- C
- Enable the HeatWave plugin in your MySQL instance so it can automatically replicate query results back to your on-premises databases.
- D
- Schedule and manage automatic backups for your MySQL Database HeatWave instance via the OCI console or CLI, then customize retention periods as needed.
- E
- Scale the Autonomous Database resources by adjusting OCPUs or enabling auto-scaling through the OCI console to handle variable workloads.
Show answer and explanation
Correct answers: A, D, E
Explanation
When integrating on-premises databases with OCI services like Autonomous Database and MySQL Database HeatWave, it is critical to combine a secure connectivity model (such as an IPSec VPN or FastConnect), robust backup strategies, and scalable resource configurations. Oracle Data Pump plus Oracle GoldenGate is a proven solution for initial load and real-time replication, while automated backups in MySQL Database HeatWave and resource auto-scaling in Autonomous Database help maintain performance and resilience. Refer to Oracle Cloud Infrastructure documentation for detailed guidance on these configurations and best practices.
- A. Correct.
Option 1 is correct. Using Oracle Data Pump to transfer data from on-premises Oracle Databases into an Autonomous Database for the initial load is a standard practice. Then, configuring Oracle GoldenGate for near-real-time replication ensures ongoing synchronization of your data.
- B. Incorrect.
Option 2 is incorrect. VCN peering is typically used to connect two VCNs in OCI. For on-premises connectivity, you would use an IPSec VPN or FastConnect for secure data transfer rather than VCN peering.
- C. Incorrect.
Option 3 is incorrect. While MySQL Database HeatWave accelerates analytics queries on MySQL data, there is no �HeatWave plugin� that automatically replicates query results back to on-premises environments. Data replication typically requires a database replication solution such as MySQL replication or Oracle GoldenGate (for Oracle DBs).
- D. Correct.
Option 4 is correct. MySQL Database HeatWave supports automated backups through the OCI console or CLI. Administrators can define their backup schedule and retention policies to ensure data safety and regulatory compliance.
- E. Correct.
Option 5 is correct. Autonomous Databases support dynamic allocation of OCPUs and auto-scaling to accommodate fluctuating workloads. Adjusting the OCPU count or enabling auto-scaling helps balance performance and cost.