Online Access Free 1z0-915-1 Exam Questions

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?

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

You want to replicate data from an on-premises MySQL server to a MySQL DB system. The on-premises MySQL server runs in your corporate network. The MySQL server accepts incoming connections from the Internet on a public IP endpoint.
The DB system runs in Oracle Cloud Infrastructure. The DB system endpoint is connected to a privatesubnet of a VCN.
Which network configuration is required?

• A.Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address.
• B.Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway.
• C.Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.
• D.Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway.

You want to enable high availability of a stand-alone DB system. Which two conditions are required? (Choose two.)

• A.The DB system point-in-time recovery must be enabled.
• B.The DB system automatic backup must be enabled.
• C.The DB system delete protection must be enabled.
• D.The DB system crash recovery must be enabled.
• E.The DB system must be active.

Which two methods can you use to import data into a MySQL DB system by using MySQL Shell? (Choose two.)

• A.util.loadDump()
• B.util.dumpInstance()
• C.util.importTable()
• D.util.dumpSchemas()

What happens when you perform a switchover of a high-availability DB system with an attached HeatWave cluster?

• A.The HeatWave cluster is deleted and a new HeatWave cluster is attached to the new primary instance.
• B.The HeatWave cluster remains attached to the same DB system and the new primary instance redirects queries to that cluster.
• C.The HeatWave cluster is attached to the new primary instance.
• D.The HeatWave cluster is no longer valid; you must re-create the HeatWave cluster.