You have a MySQL system with 500 GB of data that needs frequent backups.

Oracle 1z0-908 Question Answer

You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:

The MySQL system being backed up can never be unavailable or locked to the client applications.

The recovery from the backup must work on any system.

Only 1 hour of data can be lost on recovery of the backup.

Which option fulfills all backup requirements?

Take a physical backup of the MySQL system.

Use the Clone Plugin to copy the data to another MySQL system.

Take a logical backup of the MySQL system.

Take your backup from a slave of the MySQL system.

Oracle 1z0-908 Summary

Price: $52.5 ~~$149.99~~