Question 1

You've trained a HeatWave AutoML model for predicting customer purchase behavior. Which metrics are most important to evaluate its effectiveness for this specific task?

Options :

A : Accuracy & Recall

B : Mean Squared Error (MSE) & R-squared

C : AUC & F1 Score

D : Confusion Matrix & Precision

Answer: C

Question 2

You need to update the query_cache_size configuration parameter in your MySQL HeatWave service. Which of the following methods is recommended for a production environment with minimal disruption?

Options :

A : Modify the my.cnf file and restart the HeatWave service

B : Use the ALTER SYSTEM statement directly in the HeatWave SQL shell

C : Update the parameter through the Oracle Cloud Infrastructure (OCI) Console

D : Use the SET GLOBAL statement in a MySQL client session

Answer: C

Question 3

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

Options :

A : mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0

B : mysqlsh mysql://MySQL8.0:admin@10.0.1.221

C : mysqlsh mysql://admin:MySQL8.0@10.0.1.221

D : mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

E : mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Answer: C,D

Question 4

Your application is configured to connect to the primary instance of your MySQL HeatWave service. You want to switch to a read replica for read-heavy workloads. Which approach is recommended for minimizing application downtime during the switch?

Options :

A : Update the application-s connection string directly to point to the read replica endpoint.

B : Modify the read replica load balancer configuration to route all traffic to the desired replica.

C : Implement a DNS failover mechanism to automatically switch to the read replica in case of the primary outage.

D : Use a database proxy with read replica awareness to transparently redirect read queries to the replica.

Answer: D

Question 5

Your Bastion session is successfully established, but you encounter connection errors when trying to access the MySQL HeatWave DB system through the tunnel. What is a potential cause of this issue?

Options :

A : The security list attached to the Bastion instance doesn't allow outbound connections to the HeatWave DB system port.

B : The HeatWave DB system is running in a different Availability Domain than the Bastion instance.

C : The HeatWave DB system is not configured with the appropriate hostname or service name for the connection attempt.

D : The client application used to connect is incompatible with the MySQL HeatWave protocol.

E : The private subnet where the HeatWave DB system resides doesn't have a route to the Bastion instance subnet.

Answer: A

Fill Preparation Gaps with Free Online 1Z0-915-1 Exam Practice

Buying Options: