1. [单选题]You want to configure a multiboot system with Windows NT Workstation and Windows 2000 Professional.What should you do?
A. When installing Windows 2000 Professional run chkdisk in Windows NT Workstation.
B. Disable the disk compression in Windows NT Workstation.
C. Install service pack four or later in Windows NT Workstation.
D. Install the distributed file system client on the Windows NT Workstation.
2. [单选题]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.
3. [单选题]You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
A. The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
B. You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
C. What should you do?
D. Create an UPDATE trigger that sends an e-mail message.
E. Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
F. Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
G. Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
4. [多选题]You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)
A. Apply a bulk update lock to the table.
B. Use separate client connections to load the files into the table simultaneously.
C. Create a clustered index on the table.
D. Specify the Full Recovery model for the database.
E. Specify the Bulk-Logged Recovery model for the database.
5. [单选题]You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you configure web sharing on Reports. You name the share WebReports and allow Read permissions on the share.You test the web share by pointing to http://admin01/WebReports from another computer. You receive the following error message, 'You are not authorized to view this page.'
A. You need to be able to access the folder. What must you do?
B. Allow write permission on WebReports.
C. Allow directory browsing permissions on WebReports.
D. In the IIS console, enable anonymous access to WebReports.
E. In the IIS console, set the execute permissions option to script. and executables on WebReports.
6. [多选题]You recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professional. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.What should you do to accomplish these goals? (Choose all that apply)
A. Add Maria's user account to the System group.
B. Add Maria's user account to the Interactive group.
C. Add Maria's user account to the Power Users group.
D. Add Maria's user account to the Administrators group.
E. Add Maria's user account to the Backup Operators group.
7. [单选题]You are the administrator of a network that consists of Windows 2000 Server Computers and Windows 2000 Professional computers.You want to configure the deployment of the most recent Windows 2000 Service pack so that users of the Windows 2000 Professional Computers receive the service pack automatically when they log on to the domain.
A. What should you do?
B. Create a Microsoft Windows installer package for the service pack. Configure RIS to use the package.
C. Create a Microsoft Windows installer package for the service pack. Configure the package in a group policy.
D. Create a Microsoft Windows installer package for the service pack. Configure the package in the local computer policy.
E. Place the service pack in a distributed file system (Dfs).
8. [单选题]You want to install Windows 2000 Professional on 45 new computers on your company's network. You first install Windows 2000 Professional on one of the new computers.You log on to the computer by using the local Administrator account. You install Microsoft Office 97, a virus scanner, and other company-standard applications. You then create a RIS image of the computer you configured.
A. You want to configure the RIS image so that the standard applications will be accessible to the user when the user first logs on to the network. What should you do?
B. Run Rbfg.exe before installing the standard applications.
C. Run RIPrep.exe before installing the standard applications.
D. Copy the All Users profile to the Default Users profile.
E. Copy the local Administrator account profile to the Default Users profile
9. [单选题]You are the network administrator for Ezonexam.com.You are planning to install 10 new Windows 2000 Server computers. Ezonexam has a tight production schedule that requires no changes be made to the Active Directory except during scheduled outages. You schedule the installations during an upcoming network outage which will occur betweenmidnight and 8:00
A. M.
B. You want to complete the installations before production begins in the morning.
C. What should you do?
D. Perform. the installations by using four floppy disks create with the Makebt32.exe utility.
E. Perform. the installations by using four floppy disks create with the Makeboot.exe utility.
F. Perform. the installations by using the Windows 2000 Installation compact disc.
G. Perform. the installations by using the Windows 2000 Installation compact disc and a floppy disk containing a Winnt.sif file.
10. [单选题]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.
