nerdexam
Microsoft

70-432 · Question #127

You are mastering the company database, with SQL Server 2008 computer named SQLTEST1 The master database on SQLTEST1 is down. Some SQL Server Agent jobs should be included in the SQLTEST1. The whole…

The correct answer is A. You should reserve the model and master databases for the database. See the full explanation below for the reasoning.

Question

You are mastering the company database, with SQL Server 2008 computer named SQLTEST1 The master database on SQLTEST1 is down. Some SQL Server Agent jobs should be included in the SQLTEST1. The whole database should be backed up every day. You rebuild and restore the master database. You should make sure that SQLTEST1 functions as it did before the database lost. Which is the correct answer?

Options

  • AYou should reserve the model and master databases for the database.
  • BYou should reserve the Log Transaction for the database.
  • CYou should rebuild the whole table schema for the database.
  • DYou should rebuild the whole SQL Server Web Service for the database.

How the community answered

(56 responses)
  • A
    77% (43)
  • B
    14% (8)
  • C
    4% (2)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice