Online Access Free 1z1-908 Exam Questions

MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

• A.Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.
• B.Add default_authentication_plugin=mysql_native_password in the configuration file.
• C.Set validate-user-plugins=caching_sha2_password in the configuration file.
• D.Add default_authentication_plugin=sha256_password in the configuration file.

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

• A.operating system memory utilization
• B.MySQL Replication monitoring
• C.MySQL Query Analysis data
• D.disk usage and disk characteristics including disk advisors warnings
• E.network-related information and network characteristics
• F.security-related advisor warnings
• G.CPU utilization

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?

• A.Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.
• B.Look for queries with low total latency times in the Latency section in the times series graph.
• C.Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
• D.Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

How can mysql_multi be configured to allow MySQL instances to use the same port number?

• A.The instances listen on different IP addresses.
• B.The instances have appropriate net masks set.
• C.The instances use different user accounts unique to each instance.
• D.The instances use different socket names.

Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

• A.The statement was blocked by MySQL Firewall.
• B.John has not activated the role.
• C.John needs to reconnect to the database.
• D.The DBA needs to execute FLUSH PRIVILEGES.