Online Access Free 1z1-908 Practice Test

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

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

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

Which three are types of information stored in the MySQL data dictionary? (Choose three.)

• A.performance metrics
• B.access control lists
• C.view definitions
• D.server configuration rollback
• E.InnoDB buffer pool LRU management data
• F.server runtime configuration
• G.stored procedure definitions

Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

• A.UPDATE world.country SET Name='one' LIMIT 1;
• B.UPDATE world.country SET Name='first' ORDER BY Name LIMIT
• C.UPDATE world.country SET Name=CONCAT('New ',Name);
• D.UPDATE world.country SET Name='all';
• E.UPDATE world.country SET Name='new' WHERE Name='old';

MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

• A.shell> mysqld --help --verbose
• B.shell> mysqladmin --debug
• C.shell> mysql --print-defaults
• D.mysql> SHOW GLOBAL VARIABLES;