You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
- It must be possible to rebuild the instance using the backup.
- It must be verified.
- It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

• A. Include the keyring data and/or configuration in the backup.
• B. Include the MySQL socket file in the backup.
• C. Restore the backup to a clean MySQL instance.
• D. Include the relay logs in the backup.
• E. Include the binary logs in the backup.
• F. Copy the backup to a remote host.
• G. Include the MySQL PID file in the backup.
• H. Include the ibtmp1 file in the backup.
• I. Include the operating system disk encryption key in the backup.

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

• A. The server suspends operations for all storage engines until space becomes available.
• B. An error message will be returned to the client .Server Error: ER_IO
• C. The server will crash.
• D. The server suspends that INSERT operation until space becomes available.

What three are correct statements about MySQL backups? (Choose three.)

• A. They are used to set up a test system.
• B. They are used to recover data.
• C. They are used to set up the initial binary log files.
• D. They are used to set up a replication slave.
• E. They are used to prevent data corruption.
• F. They are used to prevent data theft.

You have just executed a manual backup by using this command:
mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

• A. Backup State = Compressed Backup
  Operation = copy-back
• B. Backup State = Prepared Backup
  Operation = validate
• C. Backup State = Prepared Backup
  Operation = apply-log
• D. Backup State = Raw Backup
  Operation = apply-log
• E. Backup State = Raw Backup
  Operation = backupdir-to-image

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

• A. Set isolation level to be READ COMMITTED.
• B. Guarantee a primary key on every table.
• C. Guarantee a secondary index on every table.
• D. Set multiple slave parallel worker threads.
• E. Configure IPv6 network for hosts.
• F. Use the binary log row format.
• G. Set isolation level to be SERIALIZABLE.