Online 1Z0-915-1 Practice Test

Question 1

You plan to update the HeatWave service version with minimal downtime for ongoing queries. Which update approach and strategy should you utilize to achieve this goal?

Options :

A : Perform a rolling update with online schema migration followed by service restart.

B : Apply the update directly to the running service and accept potential query interruptions.

C : Schedule the update during a maintenance window and fully restart the HeatWave service.

D : Migrate queries to a standby HeatWave cluster before updating the primary service.

Answer: A

Question 2

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 3

Which statement accurately describes the data distribution and processing within a HeatWave cluster?

Options :

A : Data is replicated across all nodes, and each node processes all queries independently.

B : Data is partitioned and stored on specific nodes, while queries are executed in parallel on all nodes.

C : A single node stores and processes all data, while other nodes act as standby replicas.

D : Data is cached in-memory on one node, and queries are offloaded to the database system for execution.

E : Queries are divided into subtasks and distributed to available nodes for parallel execution.

Answer: B

Question 4

You want to connect to a DB system with MySQL Shell.

DB system endpoint IP address: 10.0.1.221

Username: admin

Password: MySQL8.0

Which 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

EXPERTY DESIGNED 1Z0-915-1 PRACTICE TEST