护理学章节练习
单选题TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQ
题目
On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.
On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.
On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.
On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.
参考答案和解析
相似问题和答案
第1题：
TestKing.com has a server named SQL1 that runs SQL Server 2005 Enterprise Edition.SQL1 has 2 GB of RAM， 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log？（）
- A、MSAS 2005：Cache
- B、MSAS 2005：Memory
- C、MSAS 2005：Proactive Caching
- D、SQLServer：Buffer Manager
正确答案:D
第2题：
公司A有一个名为SQL1的SQL Server 2005服务器。SQL1设置为SQL Server和Windows身份认证模式。使用Windows认证，在SQL1上你有sysadmin权限。使用SQL1工作的所有用户都反映说：使用SQL1的所有应用程序均停止响应。你的上司让你去调查此问题。在任务管理器中，你注意到CPU使用率为100%。你试图用SQL Server Management Studio连接到SQL1。但SQL1没有响应。你需要连接到SQL1才能诊断问题。哪两种方法可能让你达成此目标？（）
- A、用osql实用工具连接到SQL1
- B、使用专用管理员连接的sqlcmd实用工具连接到SQL1
- C、用SQL Server Management Studio连接到SQL1。打开一个查询窗口并执行以下语句：DBCC TRACEON 1244
- D、在SQL Server Management Studio中，在工具栏上，点击数据库引擎查询以打开连接到数据库引擎对话框。在服务器名称文本框内，敲入ADMIN：SQL1。选择SQL Server身份认证并提供你的sa身份。点击连接按钮
正确答案:B,D
第3题：
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.
解析：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.
第4题：
TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do？（）
- A、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.
- B、On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.
- C、On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.
- D、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.
正确答案:D
第5题：
You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new R&D configuration， which will include the Research， Parts， and Engineering databases.Which two combinations will be the most appropriate？（）
- A、Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise Edition
- B、Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise Edition
- C、Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise Edition
- D、Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition
正确答案:A,B
第6题：
You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）
- A、one SQL Server 2005 computer with one instance
- B、two SQL Server 2005 computers， each with two instances
- C、two SQL Server computers， one with one instance and one with three instances
- D、one SQL Server 2005 computer with two instances
正确答案:D
第7题：
TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）
- A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.
- B、Configure SQL2 as a remote server. Write the query on SQL1.
- C、Configure SQL2 as a linked server to impersonate the remote login.
- D、Configure SQL2 as a distributed server. Use pass-through authentication.
正确答案:C
第8题：
You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal？（）
- A、Named Pipes
- B、TCP/IP
- C、Shared Memory
- D、Virtual Interface Adapter （VIA）
- E、Multiprotocol
正确答案:A,B
第9题：
You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）
- A、 Named Pipes
- B、 TCP/IP
- C、 Shared Memory
- D、 Virtual Interface Adapter (VIA)
- E、 Multiprotocol
正确答案:A,B
第10题：
You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）
- A、Internet Information Services
- B、SQL Server Browser
- C、SQL Server Agent
- D、Microsoft Distributed Transaction Coordinator
正确答案:B,D