1Z0-1151-25 Question 49
Single answerYour organization has a MySQL Database Service (MDS) instance running on Oracle Cloud Infrastructure (OCI) to support transactional workloads. You want to run complex analytics on the same datasets without moving the data to a separate platform. After reviewing OCI's capabilities, you decide to enable HeatWave on your existing MySQL DB System. Which of the following approaches will correctly allow you to load your data into HeatWave and begin running analytics queries on the MySQL DB System?
- A
Create a HeatWave cluster from the MySQL DB System details page in the OCI Console, then use the CALL sys.heatwave_load() stored procedure for each schema or table that you want to query with HeatWave.
- B
Clone the MySQL DB System into a read replica in a different region and enable HeatWave automatically on the new replica.
- C
Export the data to an Object Storage bucket using a Data Pump job, then import it into a separate Autonomous Database instance for analytics querying.
- D
Change the primary MySQL DB System shape to an analytics-optimized shape, which automatically activates the HeatWave engine without additional configuration steps.
Show answer and explanation
Correct answer: A
Explanation
To enable and administer HeatWave on a MySQL DB System in OCI, you must create and attach a HeatWave cluster, then load the data from your MySQL DB System to the HeatWave nodes using the CALL sys.heatwave_load() procedure. This simplifies analytics on transactional data without requiring an external database or complex export/import steps. For detailed instructions, refer to the official Oracle Cloud Infrastructure documentation for MySQL Database Service with HeatWave.
- A. Correct.
Option 1 is correct. The recommended process for enabling HeatWave on an existing MySQL DB System includes creating a HeatWave cluster from the MySQL DB System details page in the OCI Console. After the HeatWave nodes are provisioned, you call the stored procedure sys.heatwave_load() in MySQL to load data for the schema(s) and table(s) you want to analyze. Once data is loaded, analytics queries run automatically on the HeatWave cluster without requiring you to switch databases.
- B. Incorrect.
Option 2 is incorrect. While read replicas can be created for MySQL DB Systems, simply cloning to a read replica in a different region does not automatically enable HeatWave, and the feature does not become 'enabled by default' on replicas. HeatWave must be specifically configured and attached to the DB System in the primary region where you want to run analytics.
- C. Incorrect.
Option 3 is incorrect. Data Pump exports and imports are useful for migrating data elsewhere, but exporting to Object Storage and then importing into an Autonomous Database does not take advantage of HeatWave. This approach also introduces additional steps and resources compared to attaching a HeatWave cluster directly to your MySQL DB System.
- D. Incorrect.
Option 4 is incorrect. Simply changing the shape of the MySQL DB System does not automatically activate HeatWave. HeatWave must be explicitly created and configured for the DB System through the OCI Console or CLI.