Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Question 78

Examine this command, which executes successfully:

cluster.addInstance(‘@:’, {recoveryMethod: ‘clone’})

Which three statements are true? (Choose three.)

The account used to perform this recovery needs the BACKUP_ADMIN privilege.

A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

InnoDB tablespaces outside the datadir are able to be cloned.

It is always slower than {recoveryMethod: ‘incremental’}.

A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

Correct Answer: A, B, E

The account used to perform this recovery needs the BACKUP_ADMIN privilege, ensuring proper authorization for backup and recovery operations. A target instance must already exist initially; it will then be provisioned with data from an existing instance in the cluster and subsequently join the cluster. Additionally, a new instance undergoes installation, initialization, and data provisioning from a current cluster instance before being joined to the cluster. This comprehensive process verifies the command's effectiveness in cluster expansion and recovery scenarios.

Discussion

marklvOptions: ACE

sorry, keep changing my mind A. true B. False, target instance is not part of the cluster at first C. True D. false, Not always if there was no data in the first place. E. True, initiated and previous node must exist. F. False

marklvOptions: BDE

I guess BDE

alemdba

ABD. to clone account must have BACKUP_ADMIN privileges

marklv

A is right. Not E because is is already installed, just needs data copied.