Microsoft
70-432 · Question #211
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…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #211. The question stem and answer options stay visible for context.
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.
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.