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?
Correct : B
Start a Discussions
You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?
Correct : D
Start a Discussions
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
Correct : A, F
Start a Discussions
Examine this query and its output:
Which two statements are true? (Choose two.)
Correct : D, E
Start a Discussions
Which two statements are true about MySQL Installer? (Choose two.)
Correct : B, C
Start a Discussions