70-432 · Question #14
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…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
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.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.