ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 204 discussion

Actual exam question from Microsoft's 98-364
Question #: 204
Topic #: 1
[All 98-364 Questions]

You work as ExamTopics Database Administrator for a MySQL database server.
In an hour or so, you are able to bring a corrupted server online.
You execute the CHECK TABLE command and find that some of the InnoDB tables need to be repaired.
You restart the server and discover that auto-recover has failed.
Which of the following steps will you take to recover the corrupted InnoDB tables?

  • A. Run the ANALYZE TABLE command.
  • B. Run the REPAIR TABLE command.
  • C. Recover the tables from the last backup.
  • D. Run the OPTIMIZE TABLE command.
  • E. Restart the server with the innodb_force_recovery option.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by hajimammad at Nov. 10, 2021, 6:32 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
rogeriosolano
2 years, 10 months ago
Selected Answer: E
According to the question, the corrupted InnoDB tables are not auto-recovered. In such a case, you will have to restart the server with the innodb_force_recovery option. Further, you can dump the table, restart the server normally, and recover the tables from the dump file.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago