Oracle Exam 1Z0-908 Topic 13 Question 95 Discussion

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

Question #: 95
Topic #: 13

[All 1Z0-908 Questions]

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 dat

a. 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?

ATake a physical backup of the MySQL system.

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

CTake a logical backup of the MySQL system.

DTake your backup from a slave of the MySQL system.

Show Suggested Answer

Suggested Answer: A, D, E

by Delsie at Dec 04, 2024, 09:39 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Chuck

14 days ago

Option A seems the most comprehensive, but it might be overkill for a 500GB database. I'd want to understand the trade-offs in terms of backup duration and complexity.

upvoted 0 times

...

Doug

19 days ago

I'm not sure about option D. Wouldn't taking a physical backup be more reliable in terms of ensuring data consistency and availability?

upvoted 0 times

...

Claribel

22 days ago

I agree with Mike. Option D also helps in minimizing the data loss as the slave is usually up-to-date with the main system.

upvoted 0 times

...

Mike

28 days ago

I think option D is the best choice because taking backup from a slave ensures that the main system is not locked during the backup process.

upvoted 0 times

...