You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.You configure a multiserver job on the server in your company's New York City office. You configure this server as a master serv

第1题：

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.

第2题：

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

• A、Configure a Linked Server connection to the application database.
• B、Write a query that uses an OPENDATASOURCE command.
• C、Write a query that uses an OPENQUERY command.
• D、Configure a Remote Server connection to the application database.

第3题：

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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （） 

• A、You should configure Distributed File System
• B、You should configure SQL Server
• C、You should configure SQL Server Full Text
• D、You should configure SQL Server VSS Writer

第4题：

You are the administrator of Company.com’s Windows 2000 Network.  Your routed TCP/IP network consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. All computers are in the Company.com domain. Your network uses TCP/IP as the only network protocol. You are installing 10 new Windows 2000 Professional computers. You want to enable the new computers to use host names to connect to shared resources on the network. You configure a TCP/IP address, a gateway address and a subnet mask on each new computer.   You want to complete the configuration to allow the computers to communicate on the network.  What should you do?（）

• A、Configure a HOSTS file.
• B、Configure a LMHOSTS file.
• C、Configure a WINS server database.
• D、Configure a DHCP server address.
• E、Configure at least one DNS address.

第5题：

You install Windows 2000 Professional on your computer at home. You create a new dial-up connection to connect to your company’s remote access server. You configure the connection to use both of your external modems and to use multilink to bind the modems together. You start the dial-up connection and connect to the remote access server. You notice that only one of the modems is connected to the remote access server. What should you do？（）

• A、Configure the dial-up connection to use a SLIP connection.
• B、Configure the company’s remote access server to accept multilink connections.
• C、Replace your modems with new modems that support multilink.
• D、Grant your user account multilink permission on the company’s remote access.

第6题：

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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （） 

• A、You should backup the master database
• B、You should backup the default.trc file
• C、You should backup the SQL Server registry hive.
• D、You should backup the resource database 

第7题：

Your company has multiple DNS servers in the main office.  You plan to install DNS on a member server in a branch office.You need to ensure that the DNS server in the branch office is able to query any DNS server in the main office， and you need to limit the number of DNS records that are transferred to the DNS server in the branch office. What should you do？ （）

• A、Configure a secondary zone on the DNS server in the branch office.
• B、Configure a stub zone on the DNS server in the branch office.
• C、Configure a stub zone on the DNS server in the main office.
• D、Configure a primary zone on the DNS server in the branch office.

第8题：

Your company has multiple DNS servers in the main office. You plan to install DNS on a member server in a branch office. You need to ensure that the DNS server in the branch office is able to query and DNS server in the main office, and you need to limit the number of DNS records that are transferred to the DNS server in the branch office. What should you do?（）

• A、Configure a secondary zone on the DNS server in the branch office.
• B、Configure a stub zone on the DNS server in the branch office.
• C、Configure a stub zone on the DNS server in the main office.
• D、Configure a primary zone on the DNS server in the branch office.

第9题：

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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （） 

• A、You should configure SQL Server VSS Writer 
• B、You should configure Distributed File System 
• C、You should configure SQL Server 
• D、You should configure SQL Server Full Text

第10题：

第11题：

第12题：

第13题：

You are a security administrator for your company. All servers run Windows Server 2003. All client computers run Windows XP Professional.    You install Software Update Services （SUS） on a server named Server1. The company’s written security policy states that all updates must be tested and approved before they are installed on network computers.    You need to ensure that SUS uses the minimum amount of disk space on Server1.  What should you do？（）

• A、 Configure Server1 to redirect client computers to the Microsoft Windows Update servers.
• B、 Compress the folder in which the downloaded updates are stored.
• C、 Configure Server1 to store only the locales that are needed.
• D、 Download the updates， and then delete updates that are not approved for client computers.

第14题：

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

第15题：

You are the desktop administrator for one of your company's branch offices. The network in the branch office consists of a single network segment, which contains a domain controller, a DHCP server, 10 Windows 2000 Server computers, and 50 Windows 2000 Professional computers. All servers and client computers are members of the company's Active Directory domain. You purchase 50 new client computers for the branch office. Each new client computer contains a built-in PXE-compliant network adapter. You install and configure RIS on one of the Windows 2000 Server computers that is on the network in the branch office. You create a Windows XP Professional RIS image on the Windows 2000 Server computer. You connect the new client computers to the network in the office, and you turn on each computer. Each computer displays a message stating that it cannot contact a PXE boot server. You verify that the RIS server is connected to the network. You need to ensure that the new client computers can connect to the RIS server and can begin installing Windows XP Professional. What should you do?（）

• A、Ask a domain administrator to authorize the RIS server. 
• B、Grant the Everyone group Allow - Read NTFS permission on the RIS image.
• C、Install RIS on the domain controller. Copy the RIS image to the domain controller.
• D、Add a reservation for the RIS server to the DHCP server. 

第16题：

Your company has a main office and two branch offices.Domain controllers in the main office host an Active Directory-integrated zone.The DNS servers in the branch offices host a secondary zone for the domain and use the main office DNS servers as their DNS Master servers for the zone.The company adds a new branch office. You add a member server named Branch3 and install the DNS Server server role on the server. You configure a secondary zone for the domain. The zone transfer fails.You need to configure DNS to provide zone data to the DNS server in the new branch office.What should you do？（）

• A、Run dnscmd by using the ZoneResetMasters option.
• B、Run dnscmd by using the ZoneResetSecondaries option.
• C、Add the new DNS server to the Zone Transfers tab on one of the DNS servers in the main office.
• D、Add the new DNS server to the DNSUpdateProxy Global security group in Active Directory Users and Computers.

第17题：

Your company has a main office and a branch office. Users in the branch office report that they are unable o access shared resources in the main office. You discover that computers in the branch office have IP addresses in the range of 169.254.x.x you need to ensure that computers can connect to shared resources in both the main office and the branch office. What should you do？（）

• A、 Configure a DHCP relay agent on a member server in the main office
• B、 Configure a DHCP relay agent on a member server in the branch office
• C、 Configure the Broadcast Address DHCP server option to include the main offices DHCP server address
• D、 Configure the Resource Location Servers DHCP server option to include the main offices server ip addresses.

第18题：

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. 

第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 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? （） 

• A、You should configure a certificate 
• B、You should configure the SQL Server Agent service to use the NetworkService account.
• C、You should configure the job step to use a proxy account 
• D、You should configure the SQL Server Agent service to use a local Windows account

第20题：

You install Windows 2000 Professional on your portable computer. You create a new dial up connection to connect to your company’s remote access server. You connect to the remote access server by using the dial up connection. You can connect to the servers on the same segment as the remote access server. You cannot access the shared resources that are on the remote segments from the remote access server. What should you do？ （）

• A、Configure the company remote access server to accept multilink connections.
• B、Configure the TCP/IP program for the dial up connection to disable IP header compression.
• C、Configure the TCP/IP properties for the dial up connection to use the default gateway on theremote network.
• D、Grant your user account dial in permission on the company remote access server.

第21题：

第22题：

第23题：