Data Encryption

  • What would be the correct answer?

    Q. You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.

    SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.

    SQL2000 and SQL7 exchange confidential company information.

    You need to ensure that unauthorized users cannot access this information.

    Which two actions should you take? (Choose two)

    A. On SQL2000, enable the multiprotocol net library.

    B. On SQL2000, select the force protocol encryption check box.

    C. On SQL7, select the force protocol encryption check box.

    D. On SQL2000, install a secure sockets layer (SSL) encryption certificate.

    E. On SQL2000 and SQL7, enable multiprotocol encryption.

  • Please do not cross-post. See reply here:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=10&messageid=171721

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply