What is the default method to monitor replication lag in MySQL?

• A.Checking the size of the binary log
• B.Querying the Seconds_Behind_Master value from SHOW SLAVE STATUS
• C.Enabling the Slow Query Log
• D.Running SHOW PROCESSLIST on the primary server

Comment: *

Name: *

Email: *

Verification: *

Which two features of MySQL InnoDB Cluster help ensure high availability?

• A.Read-write splitting
• B.Automatic failover
• C.Multi-source replication
• D.Distributed transaction consistency

Comment: *

Name: *

Email: *

Verification: *

Which two settings can be configured in my.cnf to optimize the performance of MySQL?

• A.innodb_buffer_pool_size
• B.max_connections
• C.query_cache_size
• D.binlog_format

Comment: *

Name: *

Email: *

Verification: *

Which two of the following are key features of MySQL Enterprise Firewall?

• A.Blocking SQL injection attempts
• B.Monitoring database replication
• C.Learning and allowing trusted SQL patterns
• D.Optimizing query performance

Comment: *

Name: *

Email: *

Verification: *

Which two types of backups allow for point-in-time recovery in MySQL?

• A.Full backup
• B.Binary log backup
• C.Incremental backup
• D.Cold backup

Comment: *

Name: *

Email: *

Verification: *