Free MySQL HeatWave Implementation Associate Rel 1 Exam 1Z0-915-1 Exam Practice Test

You have successfully enabled high availability of a stand-alone DB system. Which is true?

• The DB system performs load balancing by distributing client connections to all instances.
• The DB system provides new port numbers on the same endpoint to connect to the secondary instances for read-only connections.
• The DB system provides new endpoints to connect to the secondary instances for read-only connections.
• The DB system has three instances running in different availability or fault domains.

You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database tools to use the SQL Worksheet feature.Which three steps are required? (Choose three.)

• Create an OCI password.
• Create an encryption key.
• Create an OCI vault.
• Create an OCI secret.
• Import an X.509 certificate into the OCI vault.

You want to create a custom configuration for the MySQL DB system in OCI Console. Which three can you set? (Choose three.)

• Shape
• VCN
• Description
• Subnet
• Compartment

You have successfully provisioned a MySQL DB system on Oracle Cloud Infrastructure by using OCI Console. You have installed the standard MySQL client libraries and MySQL Shell on your workstationthat is not connected to any VPN, FastConnect, or SSH tunnel.You CANNOT connect directly to the DB system endpoint from your workstation connected to the Internet.What is the reason?

• MySQL DB system allows only SSL-encrypted connections.
• MySQL DB system endpoint does not have a public IP address.
• MySQL DB system allows only connections through a proxy server.
• MySQL DB system cannot use the standard MySQL client libraries.

You want to deploy a high-availability MySQL DB system in a region with multiple availability domains.Which two types of subnet provide maximum redundancy? (Choose two.)

• A public AD-specific subnet
• A private regional subnet
• A public regional subnet
• A private AD-specific subnet

You want to migrate an on-premises MySQL database to a MySQL DB system on OCI.Which method provides the least amount of application down time when switching to the DB system?

• Run MySQL Shell on an OCI compute instance to export and import the data for faster migration.
• Store the exported data in object storage to speed up the export and import.
• Use inbound replication to synchronize the MySQL database transactions to the DB system.
• Use the largest DB system shape to speed up the import.

Which two are true about creating a Bastion service to connect to a MySQL DB system? (Choose two.)

• The Bastion service must have a public IP address.
• The Bastion service must be in the same VCN as the DB system.
• The Bastion CIDR block allowlist must include the IP address of all valid client machines.
• The Bastion CIDR block allowlist must include the IP address of the DB system.
• The Bastion subnet must have an ingress rule to allow stateful connections on the MvSQL DB system port number.

Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)

• High availability
• Lakehouse
• Standalone server
• Read replica
• HeatWave cluster

You want to migrate an on-premises MySQL database to MySQL HeatWave by exporting the MySQL database with MySQL Shell util.dumpInstance.What is the purpose of the ocimds: true option?

• It launches a new DB system and imports the data concurrently with the export operation.
• It enables all MySQL HeatWave compatibility options.
• It returns an error if the database has any incompatibilities with MySQL HeatWave.
• It stores the exported files in OCI Object Storage.

You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and 95% reads.Which connection method provides the fastest query response time?

• Connect to the source DB system to perform read-only operations.
• Connect to a specific read replica to perform read-only operations.
• Connect to the read replica load balancer to perform read-only operations.
• Connect to the read replica load balancer to perform read/write operations.