[单选题]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.

正确答案 ：B

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

解析：解析：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).

[单选题]You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.

正确答案 ：F

Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

解析：解析：Explanation:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.IncorrectAnswers:A:ItisnotnecessarytouninstallSQLServer7.0.JustinstallSQLServer2000asthedefaultinstance.WecannotruntheSQLServerupgradewizardunlessSQLServer2000isinstalled.B:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.C:WewanttoensurethattheSQLServer6.5databasesarelistedintheSQLServer2000installationwizard.TocreateDTStransformationpackagesthatupgradeSQLServer6.5databaseestoSQLServer2000databaseswemustinstallSQLServer2000first.

[单选题]You are the administrator of your company's network. An employee named Mark is leaving the company. A new employee named Eric has been hired to replace him.Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer.

正确答案 ：C

Rename Mark's user account to Eric and change the account password.

解析：解析：Explanation: A user account and the permission and rights attached to them can easily be transferred to another user by renaming the account and changing the password. By renaming Mark's user account and by changing the password, Eric will have the same rights and permissions as Mark had, and Mark will not be able to use his old account. This provides the solution with least amount of administrative effort.

查看原题 点击获取本科目所有试题