Microsoft
70-432 · Question #211
70-432 Question #211: Real Exam Question with Answer & Explanation
The correct answer is B. Insert a new row to dm_os_schedulers.. See the full explanation below for the reasoning.
Question
You administer a database for an online ordering system. You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools. You need to ensure that the transaction log backup schedule meets the following requirements: - Log backups occur every 15 minutes between 09:00 hours and 17:00 hours. - Log backups occur every hour between 17:00 hours and 09:00 hours. What should you do?
Options
- ACreate two SQL Server Integration Services (SSIS) packages by using a single schedule.
- BInsert a new row to dm_os_schedulers.
- CCreate a database maintenance plan by using the Database Maintenance Wizard.
- DCreate two SQL Agent jobs by using a single schedule.
Community Discussion
No community discussion yet for this question.