Question: 22
Which three are key advantages of standard MySQL replication?
A. supports native automatic failover
B. enables automatic resync of databases when discrepancies are detected
C. provides arbitrary geographic redundancy with minimal overhead to master
D. synchronously guarantees identical slave copy
E. is easy to configure and has low performance overhead
F. can easily add slaves for read scaling
答案：CEF
解析：标准的MySQL复制不支持故障转移，不支持自动差异检测。
Question: 23
Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?
A. mysqldumpslow
B. mysqldump
C. mysqlaccess
D. mysqlshow
E. mysqlslow
答案： A
解析：无
Question: 24
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?
A. The salve has two intermediate relay slaves connected to it.
B. The slave is configured with slave_parallel_workers = 4
C. At most, two schemas are being updates concurrently.
D. THREAD_ID 21 has stopped running.
E. The slave cannot process the relay log fast enough to use all threads.
F. The server needs more cores to use all slave threads.
