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.
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)- A73% (24)
- B9% (3)
- D15% (5)
- E3% (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
Community Discussion
No community discussion yet for this question.