Oracle Exam 1Z0-908 Topic 8 Question 91 Discussion

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

Question #: 91
Topic #: 8

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.

Company policy is to create a backup every day.

The main tables being updated are prefixed with transactions-.

These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*" backup

Which optimization process best describes what happens with the redo logs?

AThe redo logs are backed up first, then the transaction and archive tables.

BThe redo logs are backed up only if there are changes showing for the transactions tables.

CThe redo logs are not backed up at all.

DThe archive tables are backed up first, then the transaction tables and redo logs.

EThe transaction tables are backed up first, then the archive tables and redo logs.

Show Suggested Answer

Suggested Answer: C, E

by Jesusita at Sep 13, 2024, 08:38 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lili

1 months ago

Option E looks good, but I'm a little worried about backing up the archive tables first. Wouldn't it be better to prioritize the transaction tables, since those are the ones that are actively being updated?

upvoted 0 times

...

Crista

1 months ago

Haha, Option C is a classic - 'The redo logs are not backed up at all.' That's a surefire way to lose all your data if something goes wrong!

upvoted 0 times

Deonna

8 days ago

B) The redo logs are backed up only if there are changes showing for the transactions tables.

upvoted 0 times

...

Hershel

18 days ago

A) The redo logs are backed up first, then the transaction and archive tables.

upvoted 0 times

...

Felicidad

2 months ago

I'm not sure about that. Wouldn't it be better to back up the redo logs first, just in case there are any unsaved transactions? Option A seems more reliable to me.

upvoted 0 times

Susy

11 days ago

Yes, it's better to be safe than sorry. Option A is definitely the way to go.

upvoted 0 times

...

Jacqueline

14 days ago

I agree, backing up the redo logs first is a good precaution in case there are any unsaved transactions.

upvoted 0 times

...

Audra

26 days ago

I think Option A makes sense. It's important to back up the redo logs first to ensure no data is lost.

upvoted 0 times

...

Cherrie

2 months ago

Option B looks good. The redo logs are only backed up if there are changes to the transactions tables, which makes sense for an optimized backup process.

upvoted 0 times