WHICH SYSTEM STORED PROCEDURE IS USED TO ENABLE EXTENSIBLE KEY MAN...

20. Which system stored procedure is used to enable Extensible Key Management?

A. Sys.dboption

B. Sys.sp_configure

C. Sys.sp_helpdb

D. Sys.sp_addextendedproc

The correct answer is B. Only the sys.sp_configure stored procedure provides

the ability to enable Extensible Key Management so answers A, C, and D are

incorrect. These stored procedures do not provide the necessary functionality.

Chapter 6: Managing High Availability