Question 1

You are evaluating cost-effectiveness for your MySQL HeatWave FastConnect connection. Which factor significantly impacts the pricing of the service?

Options :

A : The chosen OCI region

B : The type of encryption used

C : The chosen FastConnect provider

D : The overall data transfer volume

Answer: D

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

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 4

You want to add a node to your HeatWave cluster for both transactions and analytics. What's the best approach?

Options :

A : Deploy a standalone node.

B : Create a new cluster and migrate data.

C : Add the node to the existing cluster.

D : Configure the node as a HeatWave proxy.

Answer: C

Question 5

You plan to update the HeatWave service version with minimal downtime for ongoing queries. Which update approach and strategy should you utilize to achieve this goal?

Options :

A : Perform a rolling update with online schema migration followed by service restart.

B : Apply the update directly to the running service and accept potential query interruptions.

C : Schedule the update during a maintenance window and fully restart the HeatWave service.

D : Migrate queries to a standby HeatWave cluster before updating the primary service.

Answer: A

Free 1Z0-915-1 Mock Exam – Practice Online Confidently

Buying Options: