Examine this query:
What information does this query provide?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
E
Explanation
:
Q: 3
Which statement is true about cold backups?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Explanation
:
Q: 4
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:
Which statement is true?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Explanation
:
Q: 5
Which two are true about differences between logical and physical upgrades of MySQL databases?
(Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C, F
Explanation
:
Q: 6
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data
directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C, E
Explanation
:
Q: 7
Which two are use cases of MySQL asynchronous replication? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
CE
Explanation
:
Q: 8
Which two statements are true about the binary log encryption feature? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, E
Explanation
:
Q: 9
Which three sets of item information are visible in the mysql system database? (Choose three.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, C, F
Explanation
:
Q: 10
How can mysql_multi be configured to allow MySQL instances to use the same port number?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Explanation
:
Q: 11
You
have
semi-synchronous
replication
configured
and
working
with
one
slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is
completely unrecoverable.
Which two statements are true? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B, F
Explanation
:
Q: 12
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:
You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which
statement is true?
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin
running
Which two actions, either one of which, can fix this error and allow a successful restore of the
cluster? (Choose two.)
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
CD
Explanation
:
Q: 17
The
mysqld
instance
has
the
connection
control
plugin
enabled
with
these
settings:
connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000
The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Explanation
:
Q: 18
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
Examine these InnoDB Cluster parameter settings:
Now examine the partial status:
A permanent network failure isolates host3.
Which two statements are true? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C, F
Explanation
:
Q: 20
You wish to store the username and password for a client connection to MySQL server in a file on a
local file system.
Which is the best way to encrypt the file?
What information does this query provide?
Which statement is true?
You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which
statement is true?
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
Now examine the partial status:
A permanent network failure isolates host3.
Which two statements are true? (Choose two.)
