MySQL HeatWave Implementation Associate Rel 1

Here you have the best Oracle 1z0-915-1 practice exam questions

You have 65 total questions to study from
Each page has 5 questions, making a total of 13 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 23, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 65

You can perform a node estimate when adding a HeatWave cluster to a DB system in OCI Console. Which two tasks are performed by the node estimate process? (Choose two.)

Generate a load command to activate Auto Parallel Load.

Estimate the number of OCPUs required to process selected user tables.

Estimate the memory required for each user table.

Generate a set of ALTER statements to load selected tables into the HeatWave cluster.

Estimate the disk storage required for each user table.

Correct Answer: B, C

Question 2 of 65

What must you do before deleting a DB system?

Take a manual backup.

Stop the instance if it is running.

Disable delete protection if it is enabled.

Stop and remove any connected HeatWave Cluster.

Correct Answer: C

Question 3 of 65

You want to create a new DB system with data import. How do you prepare the data?

Export the data into the file system with a MySQL Shell dump utility.

Export the data into an Object Storage bucket with a MySQL Shell dump utility.

Back up the database into an Object Storage bucket with MySQL Enterprise Backup.

Export the data into the file system with the mysqldump client utility.

Correct Answer: B

Question 4 of 65

Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)

High availability

MySQL Lakehouse

Standalone server

Read replica

HeatWave cluster

Correct Answer: A, C

Question 5 of 65

You want to train a classification model with MySQL HeatWave AutoML. Which two are requirements of the training data set? (Choose two.)

The target column must be numeric.

The target column and all feature columns must be stored in a single table.

All feature columns must be numeric.

There must be at least two feature columns.

The target column must have at least two distinct values.

Correct Answer: B, E