Question 1

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 2

Your application is configured to connect to the primary instance of your MySQL HeatWave service. You want to switch to a read replica for read-heavy workloads. Which approach is recommended for minimizing application downtime during the switch?

Options :

A : Update the application-s connection string directly to point to the read replica endpoint.

B : Modify the read replica load balancer configuration to route all traffic to the desired replica.

C : Implement a DNS failover mechanism to automatically switch to the read replica in case of the primary outage.

D : Use a database proxy with read replica awareness to transparently redirect read queries to the replica.

Answer: D

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

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 5

You are experiencing slow query performance in your MySQL HeatWave service. You notice the hs_scan_batch_size dynamic variable is set to a low value. What impact will increasing this variable likely have?

Options :

A : Reduce memory usage within the HeatWave cluster

B : Decrease the overall number of database scans

C : Increase the number of rows processed per scan, potentially improving performance

D : Require a HeatWave service restart for the change to take effect

Answer: C

Confidently Practice Online with Free 1Z0-915-1 Exam Cram

Buying Options: