1Z0-888 Exam Dumps | The MySQL user `adam' currently has USAGE permissions to the database. The football database is transactional

<< Prev Question Next Question >>

Question 50/54

The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

A. The `adam' user must also have SELECT on the football database for backups to work.

B. The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.

C. The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

D. The `adam' user must have the SUPER privilege in order to take data backups.

Question 50/54

LEAVE A REPLY

Download PDF File