违法和不良信息举报 联系客服
免费注册 登录

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network

题目

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．Set the database load state for each destination server to No recovery mode.

B．Set the database load state for each destination server to standby mode.

C．Enable the allow database to assume primary role option for both destination servers.

D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.

E．Disable the allow database to assume primary role option for both destination servers.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are the administrator of two Microsoft Windows 2000 computers. One computer is running Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.

You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.

Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.

You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)

A．Configure the IIS virtual directory to allow URL queries.

B．Configure the IIS virtual directory to allow template queries.

C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.

D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.

E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.


正确答案：BE
解析：Explanation:B:TheAllowTemplateQueriesoptionletsyoucreateXMLtemplatesthatcontainSQLstatements,whichcanbeusedtoreturndataasXML.Nobrowserwouldberequired,thoughyoucouldcertainlyuseone.Apossiblenon-browserclientcouldbeaVisualBasicapplicationforexample.E:IfyouforcetheuserstoauthenticatethemselvesviaBasicauthentication,IIShasallinformationrequiredtomakethetrustedconnectiontoSQLServer.WesetupIIStouseWindowsIntegratedAuthenticationwhenconnectingtotheSQLServer.WindowsAuthenticationloginsmustbecreatedontheSQLServeraswell.Incorrectanswers:A:URLqueriesallowexecutionofSQLqueriesdirectlyintheURL.Thiswouldrequireabrowserhowever,butnotallpartnersusebrowsers.Note:TheAllowURLQueriesoptionletsyoutypeSelectstatementsdirectlyinthebrowserandreturnthedataasXML.C:TheInternetGuestAccount,notaspecificWindowsaccount,shouldbeusedtoconnecttotheSQLServerfromtheIISserver.D:WeshouldnotallowaccesstotheSQLServerfortheIISInternetGuestaccount.ThatwouldallowallpeopleconnectingtotheIISserveraccesstotheSQLServeraswell.

第2题：

You are the administrator of a network that includes Windows NT Server 4.0 computers, Windows NT Workstation 4.0 computers, and UNIX computers. The network consists of a single Windows NT domain.

You are upgrading a Windows NT Server computer named Server1 to Windows 2000 Server. Server1 is a BDC in the domain. The existing DNS server is a UNIX computer that supports SRV (service) records and is configured to accept dynamic updates. The existing WINS server is another Windows NT Server computer.

You want to configure Server1 as a domain controller in a New Active Directory forest. You want the existing Windows NT domain accounts to be upgraded to Active Directory. You plan to upgrade the other domain controllers in the domain to Windows 2000 after the upgrade of Server1 is complete.

You want to perform. the upgrade of Server1 with the least possible impact on other computers on the network. What should you do?

A．Promote Server1 to the PDC of the domain. Run Windows 2000 Setup on Server1.

B．Run Windows 2000 Setup on Server1. At the end of Setup, configure Server1 as a DNS server and a WINS server.

C．Add a static mapping for Server1 on the WINS server. On the DNS server, create an SRV record for the LDAP service on Server1. Run Windows 2000 Setup on Server1.

D．Install the Microsoft DNS service on an existing Windows NT server. Apply Windows NT 4.0 service pack 4 or later to the server. Run Windows 2000 Setup on Server1.


正确答案：A
解析：Explanation: We want to upgrade the NT domain to an Active Directory domain; particularly we want to migrate the NT user accounts. First we need to promote server1 to PDC since it contains the master copy of domain information - SAM. Then upgrade the PDC to Windows 2000 Server. Active Directory requires a DNS server that supports SRV (service records). The UNIX DNS server supports this.

Incorrect answers:
B: Server1 must be upgraded to PDC before Windows 2000 is installed. Furthermore, there is already a DNS server on the network and Active Directory does not require a WINS server.

C: Server1 must be upgraded to PDC before Windows 2000 is installed. Furthermore, there is already a DNS server on the network and Active Directory does not require a WINS server.

D: Server1 must be upgraded to PDC before Windows 2000 is installed. Furthermore, there is already a DNS server on the network.

第3题：

You are the administrator of your company's network. The network is configured as shown in the exhibit.

You want to install Windows 2000 Professional on 10 non-PXE-compliant computers that are on the marketing segment of your network. You start one of the computers by using a RIS boot disk. However, you cannot connect to the RIS server.

You verify that the existing client computers on the network can connect to network servers, including the RIS server. The network router does not support BOOTP, so existing client computers use manually configured TCP/IP addresses. You want to enable the computers to connect to the RIS server.

What should you do?

A．Add a computer running DHCP Relay Agent to the marketing segment.

B．Add a computer running the network monitor driver to the marketing segment.

C．Move the Windows 2000 Server computer running WINS to the marketing segment.

D．Move the Windows 2000 Server computer running Active Directory to the marketing segment.


正确答案：A
解析：Explanation: RIS requires DNS, DHCP, and Active Directory. These services are all present according to the exhibit. The problem is the router which isn't RFC-1542 compliant, i.e. it is not BOOTP compliant, and therefore the DHCP Server will not be reached from the marketing segment. Thus the computers will not be able to contact the RIS server since RIS clients require DHCP to acquire TCP/IP configuration. By adding a DHCP Relay Agent to the marketing segment the computers will be able to connect to the DHCP server, get their TCP/IP configuration, and connect to the RIS server.

Incorrect answers:
B: Network monitor driver is used to monitor network traffic. It cannot solve the problem in this scenario and is thus inappropriate.

C: In addition to a DHCP server, the RIS server requires the presence of a DNS server running Active Directory. As DNS and Active Directory are present in the exhibit, there is no need for the WINS server. Both WINS and DNS with Active Directory are responsible for name resolution. A WINS server is required for compatibility with older versions of Windows and with non-Windows computers.

D: A DHCP server, a DNS server and Active Directory is available on this network. These servers and services are required for RIS. However the RIS server cannot access the DHCP server as the router is not RFC-1542 compliant.

第4题：

You work as the enterprise exchange administrator at Xxx .The Xxx network consists of a domain named xxx .Xxx currently makes use of Exchange 2000 Server and Exchange Server 2003 Service Pack 2 （SP2） in their messaging system.You receive instruction from Xxx to migrate the messaging system to Exchange Server 2010 with Client Access server， Mailbox server and Hub Transport servers. What actions must you take？（）

  • A、You should take away the Exchange 2000 Server servers in the environment.
  • B、You should configure EdgeSync synchronization in the environment.
  • C、You should run the setup /NewProvisionedServer in the environment.
  • D、You should run the Migration Preparation Tool from the other servers in the environment.

正确答案:A

第5题：

You are the administrator of the Coho Vineyard network. The network consists of 10 Windows 2000 Advanced Server computers and 250 Windows 2000 Professional computers.

Your company has two domains cohovineyard.com and westcoastsales.com.

The company's intranet site is on a Windows 2000 Advanced Server computer named ServerA. ServerA is in the cohovineyard.com domain and is running Internet Information Services (IIS) and Microsoft Proxy Server 2.0

You want to configure the Windows 2000 Professional computers in the westcoastsales.com domain to access the intranet site. You want users to be able to connect to the intranet site by using the URL http://serverA rather than its fully qualified domain name.

What should you do?

A．Add cohovineyard.com to the Domain Suffix Search Order on the computers.

B．Add westcoastsales.com to the Domain Suffix Search Order on the computers.

C．Add westcoastsales.com to the exceptions list in the proxy server settings on the computers.

D．Configure the proxy server settings on the computers to bypass the proxy server for intranet addresses.


正确答案：A
解析：Explanation: ServerA is located in the domain cohovineyard.com. If you add cohovineyard.com to the domain suffix then http://ServerA will translate to http://ServerA.cohovineyard.com, which would resolve this problem. This configuration can be done by opening TCP/IP properties, selecting the Advanced button, selecting the DNS tab, selecting 'Append these DNS Suffixes (inorder)', selecting Add, and entering cohovineyard.com

Incorrect Answers:
B: ServerA is located in the cohovineyard.com domain, not in the westcoastsales.com domain.

C: The domain suffix must be used to configure the connection, and not the proxy server settings.

D: By configuring the proxy setting to bypass the proxy server for intranet addresses, you would prevent intranet access from accessing external DNS servers. It also would not allow users to use the shorthand URL of http://serverA.

第6题：

You are the administrator for your company's network. The network is configured as shown in the exhibit.

You want to install Windows 2000 Professional on 20 new PXE-compliant computers on the marketing segment of your network. The new computers do not have operating systems installed.

You create a RIS image. You load the image onto the RIS server. You then start the new computers.

You find that the new computers cannot connect to the RIS server. You verify that the new computers cannot connect to the RIS server. You verify that the existing client computers in the network can connect to the network servers, including the RIS server. You want to enable the new computers to connect to the RIS server.

What should you do?

A．Add a Windows 2000 Server computer running WINS to the network.

B．Add a Windows 2000 Server computer running DHCP to the network.

C．Add the domain Everyone group to the RIS OS image security settings.

D．Place the new computers on the same segment as the RIS server.


正确答案：B
解析：Explanation:RIShasthefollowingrequirements:(1)DNSserver,(2)DHCPserverand(3)ActiveDirectory(Windows2000DomainController)TheexhibitshowsthepresenceofActiveDirectoryandDNS,butalackofaDHCPserver.WemustthereforeaddaDHCPserver.Incorrectanswers:A:RISdoesnotuseWINSatall.RISrequiresDNSfornameresolution.C:ThereshouldbenoneedtomanuallyconfigurefilepermissionsontheRISOSimage.D:MovingthenewcomputersintothesamesegmentwillnotworksincethereisnoDHCPserverpresent.Generally,RISworkswellinnetworkswithsubnets.

第7题：

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database?

A．Configure the database on the two servers as a SQL Server 2000 cluster.

B．Configure the database on one server, and then configure a standby database on the second server.

C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D．Configure the database as a federated database, and then partition half the data on each server.


正确答案：A
解析：Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS).

In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.

Incorrect Answers:
B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.

Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server's copies of databases must be restored back to the primary server.

C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.

Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.

An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.

D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.

第8题：

You are an administrator of Ezonexam.com's network. You want to perform. routine upgrades on your Windows 2000 Server computer. You use your non-administrator user account in the domain to logon to the server.

You want to upgrade all of the critical system files and patches on the server in the shortest possible time.

What should you do?

A．Use Windows Update.

B．Run System File Checker.

C．Log on as administrator and run Windows Update.

D．Log on as administrator and run System File Checker.


正确答案：C
解析：Explanation:WindowsUpdateisusedtoupgradethesystemfilesandtoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.AllnecessaryfilesaredownloadedthroughtheInternet.TobeabletorunWindowsUpdatewemusthaveadministrativerights.Incorrectanswers:A:Thenon-administrativeuseraccountcannotbeusedtorunWindowsUpdate.TorunWindowsUpdatewemusthaveadministrativerights.B:SystemFileCheckercheckstheintegrityofthesystemfiles.Itcannotbeusedtoupgradethesystemfilesortoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.D:SystemFileCheckercheckstheintegrityofthesystemfiles.Itcannotbeusedtoupgradethesystemfilesortoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.

第9题：

You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

Which three actions should you take? (Each correct answer presents part of the solution. Choose three)

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.


正确答案：BCE
B,C,E 解析：Explanation:
B: We need to use a default instance of SQL Server in order to allow all the different clients to connect.

C: The client computers in this scenario will be running Windows 98, Novel NetWare and Apple Macintosh. SQL Server Authentication is required as these operating systems are not supported by Windows Authentication, however, the use of SQL Server Authentication is offered only for backward compatibility, hence we need to implement Mixed Mode Authentication.

E: By using specific communication protocols, and not the Multiprotocol Net-Library, performance would be better. Every extraneous protocol adds overhead.

Note: Configuring Net-Libraries has been simplified for applications using the SQL Server 2000 client connectivity components. Selecting the client protocols to be installed on the application computer must be done during setup, and selecting the server protocols to be enabled on the instance of SQL Server 2000 must be done during the SQL Server 2000 setup. No other configuration is required. Once setup, a client can connect to any instance of SQL Server 2000 by specifying the network name of the database computer and the instance name.

Note: SQL Server 2000 can operate in either Windows Authentication mode, which allows a user to connect through a Windows NT 4.0 or Windows 2000 user account; Mixed mode, which allows users to connect to an instance of SQL Server 2000 by using either Windows Authentication or SQL Server Authentication.

Furthermore, users who connect through a Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication mode or Mixed mode. When a user connects to SQL Server 2000 with a nontrusted connection, SQL Server 2000 performs the authentication itself by checking if a SQL Server login account has been created and if the supplied password is correct. SQL Server Authentication is also used for backward compatibility because applications written for SQL Server 7.0 or earlier may require the use of SQL Server logins and passwords. In addition, SQL Server Authentication is required when an instance of SQL Server is running on Windows 98 because Windows Authentication mode is not supported on Windows 98.

Incorrect Answers:
A: The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000 or server enumeration.

D: As client computers will be running Windows 98, Novel NetWare and Apple Macintosh, we cannot use Windows Authentication as these operating systems are not supported by Windows Authentication.

Note: Windows Authentication mode allows a user to connect through a Windows NT 4.0 or Windows 2000 user account and makes use of trusted connections. When a user connects to SQL Server 2000 a nontrusted connection, SQL Server 2000 performs the authentication itself by checking if a SQL Server login account has been created and if the supplied password is correct. Mixed mode allows users to connect to an instance of SQL Server 2000 by using either Windows Authentication or SQL Server Authentication.

F: The Multiprotocol Net-Library is used to support the different protocol that the clients use. This provides easy of administration. However, since unused protocols are installed, it also introduces overhead. This is not the best solution.

Note: The Multiprotocol Net-Library allows for the automatic selection of available network protocols to communicate with an instance of SQL Server 2000. This is convenient for connecting to multiple servers running different network protocols without having to reconfigure the client connection for each server. If the client and server Net-Libraries for TCP/IP Sockets, NWLink IPX/SPX, or Named Pipes are installed on the client and server, the Multiprotocol Net-Library will automatically choose the first available network protocol to establish a connection.

The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000 or server enumeration.

第10题：

You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003, and all client computers run Windows XP Professional. You are required to implement a backup strategy for all five servers on the network. You use the Backup Utility to schedule nightly backup jobs. You create a domain user account named BackupSvc, and add it to the local Backup Operators group on all file servers. The scheduled backup jobs will use BackupSvc to log on to the network Nightly backups occur successfully for six weeks. Then, nightly backups fail on all servers. When you examine the event log of one server, you discover that the password for BackupSvc is expired. You reset the password and select the Password never expires option for BackupSvc. The next day, you discover that the previous night's backup failed on all file servers. You need to ensure that the next night's backup is successful. Which two actions should you perform? (Each correct answer presents part of the solution.（） Choose two)

  • A、Stop and restart every file server.
  • B、Stop and restart the backup application on every file server.
  • C、Change the password for the backup job on every file server.
  • D、In Active Directory Users and Computers, increase the value of the Account lockout threshold option.
  • E、Unlock the BackupSvc account.

正确答案:C,E

更多相关问题
相关内容