You are the administrator of two Microsoft Windows 2000 adva

【名词&注释】

布丁学网发布"You are the administrator of two Microsoft Windows 2000 adva"考试试题下载及答案，更多微软认证的考试试题下载及答案考试题库请访问布丁学网计算机类考试频道。

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

A. How should you configure the database?
B. Configure the database on the two servers as a SQL Server 2000 cluster.
C. Configure the database on one server, and then configure a standby database on the second server.
D. Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
E. Configure the database as a federated database, and then partition half the data on each server.

查看答案&解析查看所有试题

学习资料：

[单选题]You are upgrading computer1 and computer2 from Windows NT Workstation 4.0 to Windows 2000 Professional. You successfully upgrade computer1. During the upgrade of computer2, a series of power outages interrupts the upgrade.You discover that the upgrade of computer2 is incomplete. Furthermore, you find that computer2 can no longer run Windows NT workstation 4.0. Computer2 does not support booting from the Windows 2000 Professional CD-ROM. You decide to use computer1 to help recover the failed upgrade.

A. What should you do?
B. On computer1, copy the CD-ROM driver and system files named ntdetect, ntbootdd.sys, Ntdll.dll and Setupldr.bin to a formatted floppy disk. On computer2, restart the computer by using the floppy disk. Then run WinNT32/debug from the Windows 2000 Professional CD-ROM.
C. From computer1, copy the CD-ROM driver and system files named Ntdetect, Ntbootdd.sys, Ntdll.dll, and Setupldr.bin to a formatted floppy disk. On the computer2, restart the upgrade by using the floppy disk. Then run WinNT32/rx from the Windows 2000 Professional CD-ROM.
D. On the computer1, run Makebt32.exe from the Bootdisk folder on the Windows 2000 Professional CD-ROM. On computer2, restart the upgrade by using the newly created floppy disks.
E. On computer1, perform. a remote installation from a network share. On computer2, when the text portion of setup has completed, resume the installation by using the Setup Manager.

[单选题]As a Ezonexam employee you are the desktop administrator of a Windows 2000 Professional computer.The Windows 2000 Professional computer has 25 MB of free disk space drive C and 800 MB of free disks pace on drive E. You are unable to print large documents because if inadequate disk space on drive C.

A. You want to be able to use the space on drive E to print large documents.
B. What should you do?
C. From the Printer Properties dialog box, change the location field to E:\Winnt\System32\Spool\Printers.
D. From the Print Server Properties dialog box, change the location of the spool folder to any existing file path on drive E．
E. Copy the C:\Winnt\System32\Spool\Printers folder to the E:\Winnt\System32\Spool\Printers folder.
F. Mount drive C as a subdirectory on drive E．

[多选题]You are the administrator of a Windows 2000 network. You need to store secured files for your company's accounting and legal departments on a Windows 2000 Professional computer.You want to accomplish the following goals:

A. 1. Enable users in both departments to access their own files from the network
B. 2. Enable users in the accounting department to view the legal accounting department's documents
C. 3. Prevent users in the legal department from being able to view the accounting department's documents
D. 4. Enable managers within the company to access and modify both the accounting and the legal department's files
E. You take the following actions:
F. 1. Create two shared folders named Accounting and Legal
G. 2. Create three groups named Accounting, Legal, and Management
H. 3. Allow the Accounting group modify permission on the Accounting folder
I. 4. Allow the Legal group modify permission on the Legal folders.
J. 5. Allow the Management group modify permission on both the Accounting and Legal folders.
K. Which result or results do these actions produce? (Choose all that apply)
L. Users in both departments can access to their own files from the network.
M. Users in the accounting department can view the legal department's documents.
N. Users in the legal department cannot view the accounting department's documents.
O. Company managers can access and modify both departments' files.

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

A. You cancel the SQL Server upgrade wizard.
B. You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?
C. Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
D. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
E. Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
F. Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

[单选题]Exhibit:UPDATE EzonexamConsolidated

A. SET District = ‘Mexico’
B. WHERE RtvID = 45
C. You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
D. When users run the query in the exhibit above the receive the following error message:
E. Server: Mrh3612, Level 16, Stats 1, Line 1
F. View or function ‘EzonexamConsolidated’ is not updateable because it
G. contains aggregates:
H. How should you enable the query to run?
I. Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
J. The appropriate users should be granted UPDATE permissions on each base table.
K. To enable updates on the composite tables create an INSTEAD OF trigger on the view.
L. On each base table add a cascading update trigger.

[单选题]You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.

A. How should you configure SQL1?
B. Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
C. Add SQL2 as remote server.
D. Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
E. Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.

本文链接：https://www.51ksbd.net/show/yl3dxn.html