Question 1

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

Question 2

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

Question 3

Your inbound replication from an on-premises MySQL database to your HeatWave service is experiencing errors and delays. How can you troubleshoot the issue effectively?

Options :

A : Monitor HeatWave resource utilization and adjust resource allocation if needed.

B : Analyze HeatWave redo logs for errors related to replication activity.

C : Check the on-premises database logs for connectivity issues and replication errors.

D : Review all GoldenGate logs and configuration settings for potential inconsistencies.

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 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

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

Buying Options: