6
Choose the best answer.
You are having performance issues with MySQL instances.
您的MySQL实例存在性能问题。
Those servers are monitored with MySQL Enterprise Monitor.
这些服务器用MySQL企业监控器进行监控。
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.
对“Exec”列进行排序，并检查 查询响应时间 索引(QRTi)值 较低的SQL查询。
B) Look for queries with low total latency times in the Latency section in the times series graph.
C) Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
D) Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
Answser：A
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-features-qrti.html
7
Choose the best answer.
You want to log only the changes made to the database objects and data on the MySQL system.
您只需要记录在MySQL系统上对数据库对象和数据所做的更改。
Which log will do this by default?
默认情况下，哪个日志将这样做？
A) slow query log
B) binary log 二进制文件
C) error log
D) general query log
E) audit log
Answser：B
8
Choose two.
Identify two ways to significantly improve data security.
确定两种可显著提高数据安全性的方法。
A) Configure mysqld to run as the system admin account, such as root.
B) Use a private network behind a firewall.
behind 在...之后
在防火墙后面使用专用网络
C) Configure mysqld to use only networked disks.
D) Configure MySQL to have only one administrative account.
E) Configure mysqld to use only local disks or attached disks and to have its own account in the host system.
将mysqld配置为只使用本地磁盘或附加磁盘，并在主机系统中拥有自己的帐户。
Answer:B E
分析：网络隔离 最好 ， D 的问题是 administrator 这个权限太大了，应该有多个
administrative account，每个只有部分权限。
9
Choose two.
Which two statements are true about MySQL Enterprise Backup?
关于MySQL企业备份，哪两个语句是正确的
A) It creates logical backups.
B) It supports backing up only table structures.
C) It can perform hot or warm backups.
热备份
D) It supports backup of a remote MySQL system.
E) It supports restoring to a remote MySQL system.
F) It supports the creation of incremental backups.
创建增量备份
Answer:C F
10
Choose the best answer.
Examine these commands, which execute successfully on the ic1 host:
检查一下在ic1主机上成功执行的这些命令：
mysqlsh> dba.createCluster( 'cluster1' , {memberWeight:35}) mysqlsh>
var mycluster = dba.getCluster ()
mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25})
mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50}) Now
examine this configuration setting, which is the same on all nodes:
group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER
Which statement is true if primary node ic1 fails?
如果主节点ic1失败，则哪个语句为真？
A) Node ic2 becomes the new primary and existing transactions are considered stale and rolled
back.
B) Node ic3 becomes the new primary and existing transactions are considered stale and rolled
back.
C) Node ic3 becomes the new primary and is ignored until any backlog of transactions is
completed.
节点ic3成为新的主节点，在任何事务积压完成之前被忽略。
D) Only two nodes remain so the election process is uncertain and must be done manually.
E) Node ic2 becomes the new primary and is ignored until any backlog of transactions is
completed.
Answer:C
个人总结练习，不断成长进步ヾ(◍°∇°◍)ﾉﾞ
