New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 32 Topic 4 Discussion

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 32 Topic 4 Discussion

1z0-908 Exam Topic 4 Question 32 Discussion:
Question #: 32
Topic #: 4

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

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?


A.

Take a physical backup of the MySQL system.


B.

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


C.

Take a logical backup of the MySQL system.


D.

Take your backup from a slave of the MySQL system.


Get Premium 1z0-908 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.