Oracle 1Z0-320 Question Answer

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.
Which syntax accomplishes this?

A. CREATE USER ‘mysqlbackup’@localhost’IDENTIFIED BY ‘new-password’;
B. CREATE USER ‘mysqlbackup’@localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT SUPER ON *.* TO ‘mysqlbackup’@’ localhost;
GRANT PROCESS ON *.* ‘mysqlbackup’@’localhost’;
C. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘’mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@localhost’;
D. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* to ‘mysqlbackup’@localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON
mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* to ‘mysqlbackup’@’localhost’;
GRANT SUPER ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT PROCESS ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO ‘mysqlbackup’@’localhost’;
E. CREATE USER ‘mysqlbackup’@’localhost’ IDENTIFIED BY ‘new-password’;
GRANT RELOAD ON *.* TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO ‘mysqlbackup’@’localhost’;
GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO ‘mysqlbackup’@’localhost’;
GRANT REPLICATION CLIENT ON *.* TO ‘mysqlbackup’@’localhost’;

Answer: A