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

Jamal

29 days ago

I hear Option E is 'Pray to the MySQL gods and hope for the best'. Gotta love those backup requirements!

upvoted 0 times

...

Kathrine

1 months ago

Option C is tempting, but I'm worried about the time to recover a logical backup for a 500GB database. That could take a while.

upvoted 0 times

Tequila

12 days ago

User 2: I agree, using a slave for backup seems like the most efficient option in this case.

upvoted 0 times

...

Daren

16 days ago

User 1: Option D sounds like the best choice since it allows for minimal data loss and the backup can be taken from a slave.

upvoted 0 times

...

Lazaro

1 months ago

Option B with the Clone Plugin sounds interesting, but I'm not familiar with it. I'd need to research how it works and whether it meets all the requirements.

upvoted 0 times

Alita

1 months ago

Using a slave of the MySQL system for backup could be a reliable solution to meet the backup requirements.

upvoted 0 times

...

Leeann

1 months ago

Taking a physical backup of the MySQL system might be a safer option to ensure no data loss.

upvoted 0 times

...

Thad

1 months ago

Option B with the Clone Plugin is a good choice. It allows you to copy the data to another MySQL system easily.

upvoted 0 times

...

Margret

2 months ago

I'm leaning towards Option D. Taking the backup from a slave should minimize downtime and data loss, though I'd want to ensure the slave is configured correctly.

upvoted 0 times

Otis

15 days ago

Taking backup from a slave seems like the best option to ensure minimal data loss and downtime.

upvoted 0 times

...

Julieta

18 days ago

I agree, as long as the slave is set up properly, it should meet the backup requirements.

upvoted 0 times

...

Cyril

1 months ago

Option D sounds like a good choice. Using a slave for backup can help with minimizing downtime.

upvoted 0 times

...

Chuck

2 months 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