首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Ser
You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Ser
admin
2009-05-19
55
问题
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.
The net-libraries on SQL2000 are configured as shown in the exhibit.
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? (Each correct answer presents part of the solution. 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.
答案
A,E
解析
Explanation:
For compatibility with earlier versions of SQL Server, the Multiprotocol Net-Library continues to support its own encryption. This fits this scenario with a SQL Server 7 and a SQL Server 2000.
Note: Network libraries are used to pass network packets between the clients and the server running SQL Server 2000. The network libraries, implemented as dynamic-link libraries (DLLs), perform the network operations required to communicate using specific interprocess communication (IPC) mechanisms.
The Multiprotocol Net-Library uses the Windows NT remote procedure call (RPC) facility and can communicate over most IPC mechanisms supported by Windows NT such as TCP/IP Sockets, NWLink IPX/SPX, and Named Pipes; allow the use of Windows Authentication over all protocols that RPC supports; support encryption for user password authentication as well as data; and can offer performance comparable to native IPC Net-Libraries for most applications.
The Multiprotocol encryption is used only for compatibility purposes with existing systems but is not supported on Windows 98. The Secure Sockets Layer (SSL) encryption that can be enabled using the Server Network Utility is a more comprehensive encryption solution. However, SSL encryption works only with instances of SQL Server 2000 running on a computer that has been assigned a certificate from a public certification authority. The computer on which the application is running must also have a root CA certificate from the same authority.
Incorrect Answers:
B: You can force protocol encryption using SSL. Here Multiprotocol encryption must be used for compatibility purposes. SSL requires a server certificate and is not support by SQL Server 7.0.
C: You can force protocol encryption using SSL. Here Multiprotocol encryption must be used for compatibility purposes. SSL requires a server certificate and is not support by SQL Server 7.0.
D: The Secure Sockets Layer (SSL) encryption that can be enabled using the Server Network Utility is a more comprehensive encryption solution than Multiprotocol encryption. However, SSL encryption works only with instances of SQL Server 2000 running on a computer that has been assigned a certificate from a public certification authority. The Multiprotocol encryption must be used for compatibility purposes.
转载请注明原文地址:https://kaotiyun.com/show/guhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Imaginativeworkssuchasnovels,plays,films,fairytales,andlegendspresentamoreaccurateandmeaningfulpictureofhuman
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
在用户管理组administrators中添加本地用户“sy”。
在用户管理组administrators中删除lusi用户。
随机试题
简述髓腔解剖特点对牙髓炎的意义。
A.循环系统监护B.呼吸系统监护C.泌尿系统监护D.中枢神经系统监护E.血液系统监护测中心静脉压是
关于注射给药吸收的叙述,正确的是
治疗风湿痹痛,四肢拘挛,腰膝酸软,小儿行迟,宜选用的药物是()
汇票的保证不得附有条件,附有条件的( )。
上海一家期货公司是期货交易所的非结算会员,李某是该期货公司的客户。2016年1月2日结算后,期货公司向李某发出追加保证金的通知,1月3日,李某既未追加保证金也未自行平仓,期货公司因此按规定实行了强行平仓。若期货公司对李某强行平仓后资金仍不足以弥补其账户的损
医务社会工作者在为老年人及残障人士提供慢性病及严重疾病照顾中的作用体现在哪些方面?()。
新课改的课程评价有哪些特点?
2008年末固定电话用户为34081万户。其中,城市电话用户为23200万户,农村电话用户为10881万户。新增移动电话用户9392万户,年末达到64123万户。年末全国固定及移动电话用户总数达到98204万户,比上年末增加6909万户。电话普及率达到74
某商场促销活动时宜称:“凡购买100元商品均送80元购物券。对因促销活动产生的纠纷,本商场有最终解释权。”刘女士在该商场购买了1000元商品。返同800元购物券。刘女士持券买鞋时,被告知鞋类商品2天前已退出促销活动,必须现金购买。刘女士遂找商场理论,协商未
最新回复
(
0
)