Question 1

You need to create a read replica for your MySQL HeatWave service in a different OCI region. Which of the following is the MOST efficient approach?

Options :

A : Clone the entire HeatWave service with its read replica configuration.

B : Create a new HeatWave service in the target region and manually configure a read replica connection.

C : Use the Oracle Cloud Infrastructure (OCI) Console to create a read replica directly from the source HeatWave service.

D : Backup the source HeatWave service and restore it in the target region, including the read replica configuration.

Answer: C

Question 2

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 3

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 4

What additional configuration is needed alongside IAM integration to enable users to connect to the MySQL HeatWave DB system using IAM credentials?

Options :

A : Configure a Bastion session with the DB system-s private subnet as the target resource.

B : Set up SSH key authentication on the DB system and specify the key pair during IAM user creation.

C : Create a dedicated security list rule allowing inbound traffic from the OCI Console IP address range.

D : Configure virtual private cloud (VPC) peering between the DB system-s VCN and the IAM service VCN.

E : Assign the heatwave_user role to IAM users intended to access the HeatWave layer.

Answer: E

Question 5

You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database tools to use the SQL Worksheet feature. Which three steps are required? (Choose three.)

Options :

A : Create an OCI password.

B : Create an encryption key.

C : Create an OCI vault.

D : Create an OCI secret.

E : Import an X.509 certificate into the OCI vault.

Answer: A,D,E

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

Buying Options: