Question 1

How does the MySQL HeatWave architecture handle data distribution and access across multiple HeatWave Compute Nodes?

Options :

A : Broadcast: All nodes receive and process every query, leading to redundant work and potentially decreased performance.

B : Master-slave: One node acts as the master and receives all queries, while other nodes act as slaves and only execute the tasks assigned by the master.

C : Hash partitioning: Data is distributed and stored on specific nodes based on a hashing algorithm, ensuring efficient data access and parallel query execution.

D : Round-robin: Queries are sent to nodes in a circular fashion, potentially leading to uneven workloads and performance bottlenecks

Answer: C

Question 2

What additional configuration is needed alongside IAM integration to enable users to connect to the MySQL HeatWave DB system using IAM credentials?

Options :

A : Configure a Bastion session with the DB system-s private subnet as the target resource.

B : Set up SSH key authentication on the DB system and specify the key pair during IAM user creation.

C : Create a dedicated security list rule allowing inbound traffic from the OCI Console IP address range.

D : Configure virtual private cloud (VPC) peering between the DB system-s VCN and the IAM service VCN.

E : Assign the heatwave_user role to IAM users intended to access the HeatWave layer.

Answer: E

Question 3

You have a DRG attached to a VCN containing your MySQL HeatWave DB system. You need to restrict access to the database from another VCN within the same region. Suggest most effective way to achieve this using DRG and security list configurations?

Options :

A : Configure a route table in the remote VCN to direct traffic to the HeatWave system through the DRG.

B : Create a security list rule in the DRG allowing inbound traffic from the HeatWave system-s subnet to the remote VCN-s subnet.

C : Modify the DRG attachment to restrict access from the remote VCN-s CIDR block.

D : Implement a security list rule in the remote VCN-s subnet denying inbound traffic from the HeatWave system-s subnet.

E : Use IAM policies to control user permissions and restrict access at the database level.

Answer: D

Question 4

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 5

The following statements are executed successfully:Which two are true? (Choose two.)

Options :

A : The data placement key of the airport table is airport_id.

B : The airport.tbl file is in CSV format.

C : The fields in the airport.tbl file are delimited by comma.

D : The data of the airport table is loaded into the MySQL DB system.

E : Every row in the airport table has a unique airport_id value.

Answer: A,D

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

Buying Options: