1Z0-908 Exam Question 16

There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)
  • 1Z0-908 Exam Question 17

    Examine this list of MySQL data directory binary logs:
    binlog.000001
    binlog.000002
    .....
    binlog.000289
    binlog.000300
    binlog.000301
    binlog.index
    Now examine this command, which executes successfully:
    mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
    Which two are true? (Choose two.)
  • 1Z0-908 Exam Question 18

    A valid raw backup of the shop.customers MyISAM table was taken.
    You must restore the table. You begin with these steps:
    1. Confirm that secure_file_priv='/var/tmp'
    2. mysql> DROP TABLE shop.customers;
    3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
    Which two actions are required to complete the restore? (Choose two.)
  • 1Z0-908 Exam Question 19

    Examine this command, which executes successfully:
    $ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
  • 1Z0-908 Exam Question 20

    What is the correct syntax for using transparent data encryption with an existing InnoDB table?