nerdexam
Microsoft

70-177 · Question #82

70-177 Question #82: Real Exam Question with Answer & Explanation

The correct answer is C. CHECKSUM. The CHECKSUM command requests that the backup operation verify each page for checksum and Answer option B is incorrect. The NO_CHECKSUM is the default selection for the restore, and does not verify each page during the restore process. Answer option D is incorrect. CONTINUE_AFTER

Question

Gary is the Microsoft Project Server administrator for his company, and is configuring a restore method for his SQL Server. Gary would like to use a command to ensure that the backup operation verifies each page for checksum and torn page and for the entire backup. What command should Gary use?

Options

  • ASTOP_ON_ERROR
  • BNO_CHECKSUM
  • CCHECKSUM
  • DCONTINUE_AFTER_ERROR

Explanation

The CHECKSUM command requests that the backup operation verify each page for checksum and Answer option B is incorrect. The NO_CHECKSUM is the default selection for the restore, and does not verify each page during the restore process. Answer option D is incorrect. CONTINUE_AFTER_ERROR is used in conjunction with the CHECKSUM command. When an error occurs, this command allows the restore to continue but Answer option A is incorrect. STOP_ON_ERROR is used in conjunction with the CHECKSUM command. When an error occurs, this command stops the restore process.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-177 Practice