首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
56
问题
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
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
在用户管理组administrators中删除lusi用户。
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
Bobisanewsecurityadministratoratafinancialinstitution.Theorganizationhasexperiencedsomesuspiciousactivityonone
随机试题
氰化物中毒解毒剂首选药物
下列关于交易性金融资产的说法中,正确的有()。
杨红2008年出版了一部中篇小说,取得稿费10000元,同年该小说在一家晚报上连载,取得稿费3200元,则该作家取得稿费应纳的个人所得税额( )元。
资产评估机构申请证券评估资格时,应当最近3年评估业务收入合计不少于()万元,且每年不少于()万元。Ⅰ.2000Ⅱ.5000Ⅲ.200Ⅳ.500
某机构投资者对已在上海证券交易所上市的A公司进行调研时,发现A公司如下信息:(1)甲为A公司的实际控制人,通过B公司持有A公司34%的股份。甲担任A公司的董事长、法定代表人。2009年8月7日,经董事会决议(甲回避表决),A公司为B公司向C银行借款400
一只油轮从甲港顺流而下到乙港,马上又逆水返回甲港,共用8小时,顺水每小时比逆水每小时多行12千米,前4小时比后4小时多行30千米,则甲、乙两港相距()千米。
根据所给材料,回答下列问题。相比虹膜识别、人脸识别,指纹识别是生物识别技术中发展最成熟、最便利、综合成本最优的技术。指纹识别技术利用人体指纹的唯一性与稳定性特点,通过光电技术、模式识别和计算机图像处理技术。对活体指纹进行采集、分析和比对,从而自动
逻辑移位指令SHL用于( )。
下列描述中,属于面向对象思想主要特征的是
Heisofteninclinedto______inotherpeople’saffairs,whichisnoneofhisbusiness.
最新回复
(
0
)