nerdexam
Microsoft

70-282 · Question #325

You work as the network administrator at Cer-tech.com. The Cer-tech.com network consists of a single Active Directory domain named Cer-tech.com. As administrator you install Microsoft Windows Small…

The correct answer is B. To achieve this Clive Wilson needs to create a database maintenance plan on the Windows Small. See the full explanation below for the reasoning.

Question

You work as the network administrator at Cer-tech.com. The Cer-tech.com network consists of a single Active Directory domain named Cer-tech.com. As administrator you install Microsoft Windows Small Business Server 2003 on a network server. The Cer-tech.com consists of 25 client computers that are configured to run Microsoft Windows XP Professional. Management informs you to install the accounting application of Cer-tech.com that makes use of a Microsoft SQL 2000 Server on a member server. This Microsoft SQL 2000 Server is configured to run Microsoft Windows Server 2003. This accounting application runs constantly. You install a tape drive on the member server for system backups. You have received instruction from the Manager to create a backup plan that executes database backupsas well as transaction log backups of the accounting application's databases. The Manager also informs you to create separate weekday and weekend schedules for all these backups. You thus need to devise a backup plan that requires the minimum of administrative effort. What should you do?

Options

  • AClive Wilson needs to create a database maintenance plan on the member server. The Database
  • BTo achieve this Clive Wilson needs to create a database maintenance plan on the Windows Small
  • CTo accomplish this he needs to create a backup by using the Windows Small Business Server 2003
  • DA backup of the drive that contains the SQL databases needs to be created by Clive Wilson. Clive

How the community answered

(42 responses)
  • A
    2% (1)
  • B
    79% (33)
  • C
    14% (6)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 70-282 Practice