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 *