1z0-320 Exam Dumps | The MySQL database for backup with used data is configured only with the InnoDB storage engine. System

<< Prev Question Next Question >>

Question 14/48

The MySQL database for backup with used data is configured only with the InnoDB storage engine.
System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.
You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).
Which three options would you choose to optimize the backup performance?

A. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking

B. Using the - - only- innodb or - - only- innodb- with -frm option to back up only InnoDB tables

C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL

D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time

E. Using the - - no-locking option to backup non_InnoDB files

Question 14/48

LEAVE A REPLY

Download PDF File