Question 1

Your VCN already contains multiple subnets for various purposes. What additional resource should you configure within the chosen subnet before provisioning your MySQL HeatWave DB system?

Options :

A : A NAT gateway to enable outbound internet access for the database.

B : A security list with inbound and outbound rules specific to the MySQL HeatWave service.

C : A route table linking the subnet to a virtual private cloud (VPC) in another region.

D : An internet gateway to enable direct public connectivity for the database instance.

E : Additional network security groups for granular access control within the subnet.

Answer: B

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 want to connect your application to a read replica of your MySQL HeatWave service in OCI. Which connection string element is crucial for specifying the read replica endpoint?

Options :

A : The HeatWave service name

B : The database name

C : The read replica endpoint URL

D : The HeatWave cluster identifier

Answer: C

Question 4

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 5

You're migrating a high-volume transactional database to MySQL HeatWave using replication. To minimize downtime on the source system, what replication configuration would be MOST effective?

Options :

A : Configure continuous replication with minimal lag between source and target.

B : Implement snapshot replication with periodic data synchronization at scheduled intervals.

C : Set up asynchronous replication with manual data synchronization when downtime is acceptable.

D : Utilize statement-based replication with delayed commit on the HeatWave target system.

Answer: B

Higher Test Marks with Free Online 1Z0-915-1 Exam Practice

Buying Options: