MCTS章节练习(2019.04.23)

单项选择题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）
A.You should run the bulk copy program utility along with an output file and no format file
B.You should run the SQLCmd utility and save the output to a file
C.You should run the SQL Import and Export Data Wizard and save the output to a file.
D.You should run the bulk copy program utility along with a format file and an output file.
单项选择题
You have a computer that runs Windows 7. Multiple users log on to the computer. The computer has fiveremovable devices. You need to ensure that users can only access removable devices that have beenpreviously installed on the computer. What should you modify in the Local Group Policy ?（）
A.Enable the Prevent redirection of USB devices setting.
B.Enable the Prevent installation of removable devices setting.
C.Disable the WPD Devices： Deny read access setting.
D.Disable the Allow administrators to override Device Installation Restriction policies setting.
多项选择题
You are developing a WCF service. The service includes an operation names GetProduct. You need to ensure that GetProduct will accept a POST request and will indicate that the returned data is XML. Which two actions should you perform?（）
A.Add the WebGet attribute to the service contract.
B.Set WebOperationContext.Current.OutgoingRequest.ContentType to "text/xml" in the GetProduct method.
C.Add the WebInvoke attribute to the service contract.
D.Set WebOperationContext.Current.OutgoingResponse.ContentType to "text/xml" in the GetProduct method.
多项选择题
你正在开发一个使用 SqlConnection 对象连接到 Microsoft SQL Server 数据库的应用。你的连接对象正在使用连接池。当连接池满的时候请求将被排队或者某些连接请求可能被拒绝。你需要确保应用能够尽早的释放连接给连接池。因此，为了减少连接被拒的可能性，你应该从下面那三个方法着手解决？（）
A. 确保完成执行后调用每个连接对象的Close方法。
B. 确保完成执行后每个连接对象保持打开状态。
C. 在连接字符串内增加Max Pool Size的值。
D. 在连接字符串内增加Min Pool Size的值。
E. 在连接字符串内增加Connection Lifetime的值。
F. 增加SqlConnection对象的ConnectionTimeout属性的值。
多项选择题
你在为一家银行工作。这家银行使用SQL SERVER 2005数据库存储客户的在线交易数据。已知，银行每天处理大约50，000次交易。应用系统必须要求在列TransactionID上有一个聚集索引。现在，你要为交易创建一个表，它能高效的支持按日期进行交易报表的查询。请问，下面哪两种方法可以达到这个目的？（）
A.以日期列创建一个非聚集索引
B.以日期列创建唯一聚集索引
C.映射每一个数据分区到一个文件组上，每一文件组放置在不同的物理磁盘
D.创建一个以日期进行分区的分区方案
单项选择题
A Windows Communication Foundation (WCF) service only accepts messages that are signed and encrypted. A client application is not receiving expected responses from the service. You need to enable logging to verify that the messages from the client are signed and encrypted. You also need to see what each message looks like before the message body is deserialized into a NET object. What should you do?（）
A.
B.
C.
D.
单项选择题
您有一台运行 Windows 7 的计算机。您需要将操作系统和所有计算机配置都捕获到一个 Windows 映像（WIM）文件中。捕获映像之前，您应该怎么做？（）
A.运行 Oscdimg.exe
B.运行“Windows 系统映像管理器”（Windows SIM）
C.打开一个已提升优先权的命令提示符
D.通过使用 Windows 预安装环境（Windows PE）来启动计算机
单项选择题
您有一台名为 Computer1 的计算机运行 Windows 7。Computer1 有一台共享的打印机。您需要配置 Computer1，以便仅授权管理员关闭计算机。您应该怎么做？（）
A.从“用户帐户”中，修改“用户配置文件”设置
B.从“用户帐户”中，修改“用户帐户控制”（UAC）设置
C.从“本地计算机策略”中，修改“安全选项”
D.从“本地计算机策略”中，修改“用户权限分配”
多项选择题
你的公司有一个AD域。服务器server2运行windows server 2008.所有客户计算机运行windows vista。你在server2上安装了终端服务角色、TS Web访问角色服务、和TS网关服务角色。你需要确保客户计算机有相应的防火墙、反病毒软件、反间谍软件antispyware。你应该进行哪两项操作？（）
A.在域中的一个服务器上配置网络访问保护（NAP）
B.把终端服务器加入到windows授权访问域本地安全组
C.把终端服务客户端计算机加入到windows授权访问域本地安全组
D.要求请求的客户端发送终端服务访问策略健康状态
多项选择题
You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services， and configuring aweb services infrastructure. There is a server that runs Windows Server 2008 in your company. The serverhas the Web Server （IIS） server role installed. Now you receive an order from the company management.You are asked to activate SSL for the default Web site.What should you do？（）
A.Use the IIS Manager console to add bindings for the HTTPS protocol to the default Web site.
B.You should use the IIS Manager console to obtain and import a server certificate.
C.Use the Server Manager console to perform the installation of the Digest Authentication component forthe Web server role.
D.You should choose the Generate Key option in the Machine Key dialog box for the default Web site.