Question

Which operations can be performed using the Data Recovery Ad-visor?

(a) Diagnosing data failure

(b) It is a percentage of rows in which the statistics are collected incrementally for partitions

(c) Presenting appropriate repair options

(d) Generating reports for possible causes of failure

Answer 1

The correct option is (a) Diagnosing data failure

Explanation: The Data Recovery Ad-visor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user’s request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).