Which two objects should you transfer from the production environment to the development environment?

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.)

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.)

A.
msdb database

B.
Login accounts

C.
master database

D.
SQL Server Agent jobs

E.
Custom error messages



Leave a Reply 0

Your email address will not be published. Required fields are marked *