Question 1

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 2

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 3

Which backup method utilizes minimal network resources and complies with security best practices?

Options :

A : Offline backup using the HeatWave Administration Console

B : Online backup with RMAN to Object Storage via a public endpoint

C : Online backup with the HEATWAVE_FULL_BACKUP tool to a local NVMe disk

D : Online backup with Data Guard to another HeatWave service in a separate VCN

Answer: A

Question 4

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

Options :

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

Answer: C,D

Question 5

You have a DRG attached to a VCN containing your MySQL HeatWave DB system. You need to restrict access to the database from another VCN within the same region. Suggest most effective way to achieve this using DRG and security list configurations?

Options :

A : Configure a route table in the remote VCN to direct traffic to the HeatWave system through the DRG.

B : Create a security list rule in the DRG allowing inbound traffic from the HeatWave system-s subnet to the remote VCN-s subnet.

C : Modify the DRG attachment to restrict access from the remote VCN-s CIDR block.

D : Implement a security list rule in the remote VCN-s subnet denying inbound traffic from the HeatWave system-s subnet.

E : Use IAM policies to control user permissions and restrict access at the database level.

Answer: D