Quiz 70-450

Quiz 70-450, PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

You need to ensure that the application is successfully deployed to the instance

You need to ensure that the stored procedures in the MSDB database are executed by using the security context of the application user

You need to ensure that all stored data is encrypted by using the least amount of administrative effort

What are two possible ways to achieve this goal?

Which solution should you use?

Which cluster configuration should you use?

You need to reconfigure the mirroring strategy to minimize the risk of database unavailability

You need to design a replication strategy to minimize latency

Which three tasks should you perform?

You need to ensure that the backup jobs have a minimal effect on the performance of the server