MySQL 2019 Implementation Essentials: 1Z0-920

Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A. MySQL Enterprise Monitor and MySQL Audit

B. MySQL Workbench and MySQL Enterprise Firewall

C. MySQL Audit and MySQL Workbench

D. SQL Enterprise Monitor and MySQL Enterprise Authentication

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. On the Master server, disable binlog by removing the --log-bin option.

B. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

C. To safely purge binary log files, perform these steps:

1.

On each slave server, use show slave status to check which log file it is reading.

2.

Obtain a listing of the binary log files on the master server with show binary logs.

3.

Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up- to-date, this is the last log file on the list.

4.

Make a backup of all the log files you are about to delete. (This step is optional, but always

advisable.)

5.

Purge all log files up to but not including the target file by using the purge binary logs statement

D. Execute the purge binary logs statement without argument.

E. Delete all binlog files manually on the file system to release storage spaces.

The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being

monitored with suitable privileges to collect information about the server.

Which statement is correct?

A. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

B. MySQL Enterprise Monitor creates the required users automatically.

C. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

D. Monitoring metrics need super and root privileges because they are not available for a less- privileged user.