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

第1题：

Your company 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 toreconfigure 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 Agent 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. 

第2题：

You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）

• A、Microsoft SQL Server 2005 Mobile Edition
• B、Microsoft SQL Server 2005 Express Edition
• C、Microsoft SQL Server 2005 Standard Edition
• D、Microsoft SQL Server 2005 Workgroup Edition

第3题：

Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）

• A、Join the two servers by using the four-part syntax of server.database.schema.table.
• B、Reference SQL2 by using an alias.
• C、Add SQL2 as a remote server to SQL1.
• D、Add SQL2 as a linked server to SQL1.

第4题：

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

第5题：

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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第6题：

You need to design a Windows Server Update Services （WSUS） infrastructure that meets the  following requirements：   èThe updates must be distributed from a central location.   èAll computers must continue to receive updates in the event that a server fails. What should you include in your design？（）

• A、Configure two WSUS servers in a Microsoft SQL Server 2008 failover cluster. Configure each WSUS  server to use a local database.
• B、Configure a single WSUS server to use multiple downstream servers. Configure each WSUS server touse a RAID 1 mirror and a local database.
• C、Configure a single WSUS server to use multiple downstream servers. Configure each WSUS server to  use a RAID 5 array and a local database.
• D、Configure a Microsoft SQL Server 2008 failover cluster. Configure two WSUS servers in a Network Load Balancing cluster. Configure WSUS to use the remote SQL Server 2008 database instance.

第7题：

ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

• A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
• B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
• C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
• D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

第8题：

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.

第9题：

You are a database administrator of two SQL Server 2005 computers named SQL1 and SQL2. You have a Microsoft .NET application that has been modified so that it now accesses a database on SQL2 in addition to SQL1. You do not want the user application to connect directly to SQL2. You need to enable the data retrieval from SQL2 while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do？（）

• A、Change the .NET application to define a new server connection to SQL2.
• B、Configure a linked server on SQL1 to point to SQL2.
• C、Configure a linked server on SQL2 to point to SQL1.
• D、Change the stored procedures called by the .NET application to include the OPENXML command.

第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

第11题：

第12题：

第13题：

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

• A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.
• B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
• C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.
• D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

第14题：

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A user in TestKing.com named Eric writes many ad hoc queries against the company databases.Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first？（）

• A、Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
• B、Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
• C、Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.
• D、Instruct Eric to specify SQL Server object names by using four-part notation.

第15题：

You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional， you must configure access to the vendors site. What should you do？（）

• A、Configure an HTTP endpoint for SQL2 on SQL1.
• B、Configure SQL2 as a linked server on SQL1.
• C、Configure an HTTP endpoint for SQL1 on SQL2.
• D、Configure SQL1 as a linked server on SQL2.

第16题：

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

第17题：

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

第18题：

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 foreach 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.

第19题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the requirement of the company CIO， users on the SQL Server instance must be able to use the OPENROWSET（） function to query remote data source.  In the options below， which sp_configure configuration option should you configure？

• A、Agent XPs 
• B、remote access 
• C、remote proc trans 
• D、Ad Hoc Distributed Queries

第20题：

You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）

• A、Set the appropriate local password policies for all computers on which SQL Server is installed.
• B、Set the server authentication mode of all SQL Server instances to Windows Authentication mode.
• C、Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.
• D、Create SQL Server logins that have CHECK_POLICY enabled.

第21题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

• A、You should use Dynamic Management Views 
• B、You should use SQL Server Resource Governor 
• C、You should use SQL Server Profiler 
• D、You should use Windows System Monitor

第22题：

第23题：