1Z0-908 is the Oracle exam MySQL 8.0 Database Administration Exam. Paid practice material for this exam is not available yet, but you can try its free sample questions.
Taken from the free sample set for 1Z0-908.
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
performance metrics
InnoDB buffer pool LRU management data
access control lists
view definitions
server runtime configuration
server configuration rollback
stored procedure definitions
Correct answer: A, D, E
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?
The redo logs are backed up first, then the transaction and archive tables.
The redo logs are backed up only if there are changes showing for the transactions tables.
The redo logs are not backed up at all.
The archive tables are backed up first, then the transaction tables and redo logs.
Correct answer: D
Optimistic phase: In this first phase, tables that are unlikely to be modified during the backup process (referred to as the “inactive tables” below, identified by the user with the optimistic-time option or, by exclusion, with the optimistic-busy-tables option) are backed up without locking the MySQL instance. And because those tables are not expected to be changed before the backup is finished, redo logs, undo logs, and system table spaces are not backed up by mysqlbackup in this phase.