Changed 1z0-915-1 Exam Questions

For a MySQL DB system with five active read replicas and a workload consisting mostly of reads, the fastest query response time is achieved by:

C.Connect to the read replica load balancer to perform read-only operations: The read replica load balancer distributes the read workload across all replicas, optimizing performance and response time.

To enable high availability for a stand-alone DB system, the following conditions are required:

The DB system must be active(Answer D): The DB system needs to be in an active state to enable high availability features.

The DB system automatic backup must be enabled(Answer E): Automatic backups must be enabled to ensure data protection and facilitate failover operations.

Steps:

Ensure the DB system is running and operational.

Enable automatic backups through the OCI Console or API.

References:

MySQL High Availability Documentation

Automatic Backups Documentation

A.You can set a value for any global MySQL variable in a configuration: MySQL HeatWave allows you to configure and set global MySQL variables to optimize performance and customize the environment as needed.

C.You can view custom configuration sets with the OCI CLIoci mysql db-system getcommand: The OCI CLI provides commands to retrieve details about MySQL DB systems, including custom configurations.

To create a second user calledadmin2with the same privileges as the administrator, you can use the following statement:

D.CREATE USER admin2 IDENTIFIED BY 'Password'; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;

This creates the useradmin2and grants all privileges, along with the ability to grant those privileges to other users.