oracle 1z0-915-1 practice test

MySQL HeatWave Implementation Associate Rel 1

Last exam update: Nov 18 ,2025
Page 1 out of 5. Viewing questions 1-15 out of 65

Question 1

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.)

  • A. Generate a load command to activate Auto Parallel Load.
  • B. Estimate the number of OCPUs required to process selected user tables.
  • C. Estimate the memory required for each user table.
  • D. Generate a set of alter statements to load selected tables into the HeatWave cluster.
  • E. Estimate the disk storage required for each user table.
Mark Question:
Answer:

B, C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 2

What must you do before deleting a DB system?

  • A. Take a manual backup
  • B. Stop the instance if it is running.
  • C. Disable delete protection if it is enabled.
  • D. Stop and remove any connected HeatWave Cluster.
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

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

  • A. Export the data into the file system with a MySQL Shell dump utility
  • B. Export the data into an Object Storage bucket with a MySQL Shell dump utility.
  • C. Back up the database into an Object Storage bucket with MySQL Enterprise Backup.
  • D. Export the data into the file system with the mysqldump client utility.
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

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

  • A. High availability
  • B. Lakehouse
  • C. Standalone server
  • D. Read replica
  • E. HeatWave cluster
Mark Question:
Answer:

A, C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 5

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

  • A. The target column must be numeric.
  • B. The target column and all feature columns must be stored in a single table.
  • C. All feature columns must be numeric.
  • D. There must be at least two feature columns.
  • E. The target column must have at least two distinct values.
Mark Question:
Answer:

B, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6

You want to connect to a DB system with MySQL Shell.
DB system endpoint IP address: 10.0.1.221
Username: admin
Password: MySQL8.0
Which two commands work? (Choose two.)

  • A. mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0
  • B. mysqlsh mysql://MySQL8.0:[email protected]
  • C. mysqlsh mysql://admin:[email protected]
  • D. mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0
  • E. mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0
Mark Question:
Answer:

C, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 7

Which sequence of steps must you perform to change the configuration of a high-availability DB
system?

  • A. Disable high availability, edit the DB system, change the configuration, and enable high availability.
  • B. Stop the DB system, edit the DB system, change the configuration, and start the DB system.
  • C. Edit and change the configuration of all secondary instances, switch over to a secondary instance, and edit and change the configuration of the former primary instance.
  • D. Edit the DB system and change the configuration.
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Why would you select "Source cannot use GTID auto-positioning" when creating a channel?

  • A. The target DB system is a high-availability DB system.
  • B. Some tables have no primary key
  • C. The binary log offset is unknown.
  • D. The source gtid mode is OFF.
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

You have an inbound replication channel that replicates data from one DB system to another DB
system. Both DB systems are created with the default configuration.
You encountered the following error on the target DB system:

What is the possible cause?

  • A. The missing GTID set has been archived to object storage and is no longer available.
  • B. The target DB system relay log file destination is full.
  • C. The channel has been disabled for more than 2 hours.
  • D. The administrator has deleted the binary log files from the source DB system.
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

What happens when you perform a switchover of a high-availability DB system with an attached
HeatWave cluster?

  • A. The HeatWave cluster is deleted and a new HeatWave cluster is attached to the new primary instance.
  • B. The HeatWave cluster is attached to the new primary instance.
  • C. The HeatWave cluster remains attached to the same DB system and the new primary instance redirects queries to that cluster.
  • D. The HeatWave cluster is no longer valid; you must re-create the HeatWave cluster.
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?

  • A. updateGtidSet: off
  • B. showMetadata: false
  • C. skipBinlog: true
  • D. deferTableIndexes: all
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

You want to restore the backup of a stand-alone DB system to a new DB system.
Which two changes are allowed? (Choose two.)

  • A. Use a smaller data storage size for the new DB system.
  • B. Use a different subnet for the new DB system.
  • C. Use a different shape for the new DB system.
  • D. Use a different tenancy for the new DB system.
  • E. Use a different region for the new DB system.
Mark Question:
Answer:

B, C

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 13

Which two are true about read replica load balancer? (Choose two.)

  • A. It has the same endpoint as the DB system.
  • B. It distributes connections among the source DB system and all read replicas.
  • C. User accounts containing a client host name cannot connect to the read replica load balancer.
  • D. It is created when the DB system is first created.
  • E. It distributes connections among read replicas.
Mark Question:
Answer:

B, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 14

Which type of configuration variables CANNOT be modified in MySQL custom configurations?

  • A. Initialization variables
  • B. User variables
  • C. System variables
  • D. Default user variables
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

Which MySQL HeatWave AutoML routine evaluates a model?

  • A. ML_EXPLAIN
  • B. ML_EXPLAIN_TABLE
  • C. ML_TRAIN
  • D. ML_SCORE
  • E. ML_PREDICT_TABLE
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000
To page 2