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

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

Question 3

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

Question 4

You need to modify the data filtering of an existing inbound replication channel in your MySQL HeatWave service. What two methods can you use to achieve this?

Options :

A : Update the channel definition using the ALTER HEATWAVE CHANNEL statement.

B : Modify the filter rules directly on the source database replication plugin.

C : Recreate the replication channel with the desired data filtering applied.

D : Utilize the Oracle Cloud Infrastructure (OCI) Console to edit the channel properties.

Answer: A,B

Question 5

During a MySQL HeatWave HA cluster upgrade, you initiate a planned switchover. Which two actions are most likely to occur during this process?

Options :

A : Automatic failover triggers if the upgrade takes longer than expected.

B : All user connections are paused and resumed to the new primary node.

C : Data is replicated asynchronously to the new primary node during switchover.

D : The previous primary node becomes completely unavailable after the switch.

E : New queries are directed to the secondary node even before the switchover finishes

Answer: B,C