View Mode
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
Q: 12
You are upgrading a MySQL instance to the latest 8.0 version. Examine this output: 1Z0-908 question You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?
Options
Q: 13
You are backing up raw InnoDB files by using mysqlbackup. Which two groups of files will be backed up during a full backup? (Choose two.)
Options
Q: 14
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.)
Options
Q: 15
Examine this SQL statement: mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION; Which two are true? (Choose two.)
Options
Q: 16
Examine the modified output: 1Z0-908 question Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
Options
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
Q: 18

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

Options
Q: 19
Examine these InnoDB Cluster parameter settings: 1Z0-908 question Now examine the partial status: 1Z0-908 question A permanent network failure isolates host3. Which two statements are true? (Choose two.)
Options
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?
Options
Question 11 of 20 · Page 2 / 2

Premium Access Includes

  • ✓ Quiz Simulator
  • ✓ Exam Mode
  • ✓ Progress Tracking
  • ✓ Question Saving
  • ✓ Flash Cards
  • ✓ Drag & Drops
  • ✓ 3 Months Access
  • ✓ PDF Downloads
Get Premium Access
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail 10% DISCOUNT on YOUR PURCHASE

  • USE THE CODE GIVEN BELOW ON YOUR CHECKOUT
DISCOUNT10