Microsoft
70-450 · Question #91
70-450 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. A new database application is hosted by the instance. The data security strategy should be designed for the application. The data should be duplicated to another instance of SQL Server 2008 by utilizing the Snapshot duplication. Since you are the technical support of the company, you should make sure that all stored data should be encrypted, and the minimum amount of administrative effort should be utilized. Which action will you perform?
Options
- AEncrypted connections should be enabled between the instances.
- BTransparent data encryption should be enabled for the Publisher, Distribution, and Subscriber
- CTransparent data encryption for the MSDB database should be enabled on the two instances.
- DCertificate-based encryption should be enabled for the Publisher, Distribution, and Subscriber
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.