These practice test questions from MeasureUp are based on Microsoft’s exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008.
The audience for this exam includes individuals who are responsible for administering SQL Server databases. Experience using the management tools for SQL Server to automate database administration, optimize database and server performance, and monitor and troubleshoot database servers will help you prepare for this exam.
By passing exam 70-450, you earn credit toward the Microsoft Certified IT Professional (MCITP): Database Administrator 2008 certification.
Single answer, multiple choice
You manage two instances of SQL Server 2008 running on different computers. The computers are named serv1.busicorp.com and serv2.busicorp.com.
You execute the following to create a symmetric key on serv1:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'My p*55wORd';
CREATE CERTIFICATE cert_keyProtection WITH SUBJECT = 'My Key Protection';
CREATE SYMMETRIC KEY key_DataShare WITH
KEY_SOURCE = 'These are my key generation bits'
ALGORITHM = AES_256,
IDENTITY_VALUE = 'These are my key Identity generation bits'
ENCRYPTION BY CERTIFICATE [cert_keyProtection];
You need to create an identical symmetric key on serv2.
What should you do?
A. Copy the symmetric key from serv1 to serv2.
B. Back up the master key from serv1, restore it to serv2, and then run the same commands on serv2.…
Please log in or subscribe to read this article