MySQL 8.0 Database Administrator — Question 85

Examine this command, which executes successfully:
cluster.addInstance(‘<user>@<host>:<port>’, {recoveryMethod: ‘clone’})
Which three statements are true? (Choose three.)

Answer options

• A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
• B. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
• C. InnoDB tablespaces outside the datadir are able to be cloned.
• D. It is always slower than {recoveryMethod: ‘incremental’}.
• E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
• F. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

Correct answer: A, D, F

Explanation

The correct statements A, D, and F highlight necessary conditions and behaviors of the clone recovery process. A is correct as the BACKUP_ADMIN privilege is essential for recovery tasks. D is true because the clone method is generally slower than using incremental recovery. F correctly states that InnoDB redo logs must remain static during the operation to avoid failure. Options B, C, and E are incorrect as they either misstate the requirements or describe processes that do not pertain to the specifics of the clone recovery method.