MySQL is installed on a Linux server with the configuration:

Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

• A.Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
• B.Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
• C.Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
• D.Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

Comment: *

Name: *

Email: *

Verification: *

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

• A.deploying MySQL agent on supported target operating system
• B.starting and stopping the MySQL instance
• C.analyzing executed MySQL queries
• D.creating e-mail alerts and SNMP traps for MySQL warnings
• E.tracing import and export with mysqldump
• F.monitoring the availability of the MySQL Instance

Comment: *

Name: *

Email: *

Verification: *

When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

• A.Flash-archive recovery area
• B.Cloud storage only
• C.Cloud tape library
• D.Both Cloud storage and local storage

Comment: *

Name: *

Email: *

Verification: *

Which statement would you use to remove the population column from the city table?

• A.ALTER TABLE city LESS population;
• B.ALTER TABLE city DELETE population;
• C.ALTER TABLE city DROP population;
• D.DELETE population FROM city;
• E.DROP population FROM city;

Comment: *

Name: *

Email: *

Verification: *

Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

• A.Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
• B.Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
• C.Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
• D.Increasing the storage capacity so that the database can store more data to scale.
• E.Allocating more CPU to the database instance to improve throughput performance.

Comment: *

Name: *

Email: *

Verification: *