1z0-915-1 VCE Exam Download

To copy transactions from an on-premises MySQL instance to a DB system, you useinbound replication(Answer B).

Inbound Replication: This feature allows the MySQL DB system to receive and apply changes (transactions) from an external MySQL instance.

Replication Configuration: You need to set up replication between the on-premises MySQL instance and the MySQL DB system by configuring the master (on-premises) and the slave (DB system) appropriately.

References:

MySQL Replication Documentation

OCI MySQL Database Service Documentation

When creating a Bastion service to connect to a MySQL DB system, the following are true:

The Bastion CIDR block allowlist must include the IP address of all valid client machines(Answer C): This ensures that only the IP addresses specified in the allowlist can access the Bastion service, enhancing security by restricting access to known clients.

The Bastion subnet must have an ingress rule to allow stateful connections on the MySQL DB system port number(Answer E): This allows the Bastion service to communicate with the MySQL DB system by permitting traffic through the necessary ports.

References:

OCI Bastion Service Documentation

Setting Up Bastion with MySQL DB System

When changing the storage size of a DB system,you cannot decrease the DB system's storage size(Answer B). This restriction ensures data integrity and prevents potential data loss that could occur if the storage size were reduced.

You can only increase the storage size of the DB system.

The storage increase is done online without shutting down the DB system, allowing for uninterrupted operations.

References:

OCI MySQL DB System Scaling Documentation

When performing a node estimate while adding a HeatWave cluster to a DB system in OCI Console, the process undertakes the following tasks:

Estimate the number of OCPUs required to process selected user tables(Answer B): The node estimation process calculates the necessary OCPUs based on the size and complexity of the tables selected by the user. This ensures that the cluster has adequate processing power for efficient performance.

Estimate the memory required for each user table(Answer C): This task involves determining the memory requirements for each table that will be loaded into the HeatWave cluster. This ensures that there is sufficient memory to handle the data and execute queries efficiently.

References:

OCI Console Documentation on HeatWave

MySQL HeatWave User Guide