WHICH OF THE FOLLOWING BEST DESCRIBES SQL SERVER 2008 EXTENSIBLE K...

18. Which of the following best describes SQL Server 2008 Extensible Key

Management?

A. Enables third-party EKM/HSM vendors to register their modules in

SQL Server

B. Enables easy management of Encrypting File System (EFS) encryption

C. Enables easy creation of an EKM key with another EKM key

D. Enables easy back up of a database encryption key

The correct answer is A. Answer B is incorrect because SQL Server 2008

extensible key management does not provide the functionality to manage EFS

encryption. Answer C is incorrect because an EKM key cannot be created

with another EKM key so this cannot be done using EKM. Answer D is

incorrect because EKM does not provide the functionality to back up a

database encryption key; this is done using T-SQL.