Question 1

Which type of configuration variables CANNOT be modified in MySQL custom configurations?

Options :

A : Initialization variables

B : User variables

C : System variables

D : Default user variables

Answer: A

Question 2

You have provisioned a MySQL HeatWave DB system in your VCN and want to connect using MySQL Shell from your local machine. Which additional configuration is necessary to establish a secure connection?

Options :

A : Configure a bastion service in your VCN and access the DB system through the bastion instance-s internal IP address.

B : Enable SSH public key authentication on the DB system and utilize the \connect command with the public endpoint IP address and private key.

C : Grant your user account the connect privilege for the database and use the mysql command with the DB system-s public endpoint IP address and username/password.

D : Create a route table entry in your VCN routing traffic from your local machine-s subnet to the DB system-s subnet directly.

E : Configure a VPN connection between your local machine and the VCN containing the DB system and connect using the private endpoint IP address.

Answer: B

Question 3

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 4

What additional configuration is required within the HeatWave DB system to enable OCI IAM-based authentication for user access?

Options :

A : No additional configuration is needed, OCI IAM automatically integrates with HeatWave.

B : The HeatWave Administrator needs to create and map database roles to corresponding OCI IAM groups or users.

C : A custom authentication plugin needs to be developed and deployed within the HeatWave instance.

D : The HeatWave system administrator must configure the OCI IAM service with specific policies for database access.

E : The database schema needs to be modified to accommodate the OCI IAM user identifiers.

Answer: B

Question 5

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