You are creating a strategy for backing up MySQL using a cold binary backup.

Oracle 1z0-888 Question Answer

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.)

Include the keyring data and/or configuration in the backup.

Restore the backup to a clean MySQL instance.

Copy the backup to a remote host.

Include the MySQL socket file in the backup.

Include the ibtmp1 file in the backup.

Include the relay logs in the backup.

Include the operating system disk encryption key in the backup.