PrepAway - Latest Free Exam Questions & Answers

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

PrepAway - Latest Free Exam Questions & Answers

A.
msdb database

B.
Login accounts

C.
master database

D.
SQL Server Agent jobs

E.
Custom error messages


Leave a Reply