nerdexam
Microsoft

70-450 · Question #2

You administer a SQL Server 2008 instance that hosts a database solution in a production environment. The database solution uses several SQL Server Agent jobs to periodically transfer data from…

The correct answer is A. msdb database C. master database. Incorrect: B (master database also includes the login accounts of SQL Server instance. Incorrect: D (msdb database also includes the SQL Agent schedules.

Maintain a BI Solution

Question

You administer a SQL Server 2008 instance that hosts a database solution in a production environment. The database solution uses several SQL Server Agent jobs to periodically transfer data from heterogeneous data sources to the production environment. You also have a separate development environment that is used by several development teams. You design a test recovery plan for the database. You plan to test the recovery plan by performing the following tasks:

  • Restoring the database on a separate SQL Server 2008 instance in a

development environment

  • Running a number of unit tests.

You need to ensure that all database dependencies are included in the recovery plan. Which two objects should you transfer from the production environment to the development environment? (Each correct answer presents part of the solution. Choose two.)

Options

  • Amsdb database
  • BLogin accounts
  • Cmaster database
  • DSQL Server Agent jobs
  • ECustom error messages

How the community answered

(33 responses)
  • A
    73% (24)
  • B
    9% (3)
  • D
    15% (5)
  • E
    3% (1)

Explanation

Incorrect: B (master database also includes the login accounts of SQL Server instance. Incorrect: D (msdb database also includes the SQL Agent schedules.

Topics

#disaster recovery#database restore#msdb database#master database

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice