Microsoft
70-432 · Question #14
70-432 Question #14: Real Exam Question with Answer & Explanation
The correct answer is B. You should compress the log file backups. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 with a named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You logship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. You have to reduce the size of the log backup. Which action should you perform to achieve this goal?
Options
- AYou should recreate the indexes.
- BYou should compress the log file backups
- CYou should make the Dworks database use the Full recovery mode
- DYou should make the Dworks database use the Simple recovery mode.
Community Discussion
No community discussion yet for this question.