Question 1

You're setting up inbound replication from an on-premises MySQL database to your MySQL HeatWave service in OCI. Which connectivity option offers the highest security and reliability for data transfer?

Options :

A : Configure direct TCP/IP connection between the on-premises database and HeatWave service.

B : Utilize Oracle GoldenGate with Secure Sockets Layer (SSL) encryption for data replication.

C : Establish connection through OCI VPN Connect with IPSec tunnel encryption.

D : Implement Oracle Cloud Infrastructure Object Storage as an intermediate staging point for data.

Answer: B

Question 2

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 3

You need to set up inbound replication for a specific schema in your on-premises MySQL database to a dedicated table in your MySQL HeatWave replica. Which channel configuration should you utilize?

Options :

A : Use a single channel with a table filter to include only the desired schema from the source.

B : Configure a multi-source channel capturing all changes from the on-premises database and filter specific tables during apply on the HeatWave side.

C : Create a dedicated channel for the target table in the HeatWave replica and specify the source schema and table during channel creation.

D : Implement a statement-based filter on the source database replication plugin to selectively capture changes for the target table.

Answer: C

Question 4

You want to connect to a DB system with MySQL Shell.DB system endpoint IP address: 10.0.1.221Username: adminPassword: MySQL8.0Which two commands work? (Choose two.)

Options :

A : mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0

B : mysqlsh mysql://MySQL8.0:[email protected]

C : mysqlsh mysql://admin:[email protected]

D : mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

E : mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Answer: C,D

Question 5

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

Smartly Prepare Exam with Free Online 1Z0-915-1 Practice Test

Buying Options: