Oracle Exam 1Z0-920 Topic 7 Question 12 Discussion

Actual exam question for Oracle's 1Z0-920 exam

Question #: 12
Topic #: 7

An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.

What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

AMySQL Enterprise Backup does not back up system data so that it is much faster.

BMySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

Cmysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

Dmysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

Emysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

Show Suggested Answer

Suggested Answer: D, E

by Carlee at May 04, 2022, 12:33 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-920 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!