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

Cherrie

4 days 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

...