1. [单选题]You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.
A. You want to ensure that the journalists can query the database. What should you do?
B. Create a new full-text catalog for the Articles database
C. Rebuild the full-text catalog for the Articles database
D. Create a new full-text index on the table that holds the text for the articles
E. Repopulate the full-text index on the table that holds the text for the articles
2. [单选题]You plan to install Windows 2000 Server on 10 new computers. These servers will provide file and print services in branch offices of Ezonexam.com. The company wants each branch office to purchase its own copy of Windows 2000 Server, and the installation in each branch office should use the serial number associated with the branch office's own copy.You want to install, configure, and test Windows 2000 Server on these computers at the main office before shipping the computers to the branch offices. You want users in the branch office to enter the computer names and serial numbers when they receive the computers.
A. What should you do?
B. Install Windows 2000 Server on the computers by using an unattend.txt file, and then use the registry editor to remove the computer name and license details.
C. Start the installation process from an MS-DOS boot disk. Install Windows 2000 Server on the computers from an existing server by running the Winnt command with the PreInst switch.
D. Install Windows 2000 Server on the computers, and then use Setup Manager to create a sysprep.inf file for sysprep.exe. Place the sysprep.inf file on the computers and run the sysprep-nosidgen command.
E. Create an unattend.txt file by using Setup Manager. Include the following line in the unattend.txt file. emPrenistall=YES. Use this file to perform. the installation.
3. [多选题]You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
A. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)
B. Enable the Always read properties from UDL file option in the Connection Properties dialog box.
C. Disable the Always read properties from UDL file option in the Connection Properties dialog box.
D. Delete the .udl files and store connection details in the registry by using system data source names.
E. Delete the .udl files, and store connection details in the registry by using user data source names.
F. Make the .udl files available on a network share.
4. [单选题]You need to install Windows 2000 Professional on 30 new computers. You also need to deploy a Windows 2000 Professional service pack during the installation.First, you create a network distribution folder named InstallFiles. You copy the i386 folder from the Windows 2000 Professional CD to the InstallFiles folder.
A. What should you do?
B. Copy the service pack files to the InstallFiles\Misc folder.
C. Copy the service pack files to the InstallFiles\$OEM$ folder.
D. From an existing client computer, run theUpdate -ucommand from the service pack to the InstallFiles folder.
E. From an existing client computer, run theUpdate -s:InstallFilescommand from the service pack to the InstallFiles folder.
5. [单选题]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 server, and designate the remaining 11 servers as target servers.
A. After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.
B. You need to make the New York City server a target server instead of a master server. What should you do?
C. On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.
D. On the JobMaster server, enlist all other servers as target servers.
E. On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.
F. On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.
6. [单选题]From your Windows 2000 Professional computer, you need to map drive G to the default administrative share on drive C of a server named AppSrv.What can you do to map the drive?
A. Run thenet share C$=G:\command.
B. Run thenet use G: \\AppSrv\C$command.
C. Browse to AppSrv in Windows Explorer, and map drive G to the C$ share.
D. Browse to AppSrv in My Network Places, and map drive G to the C$ share.
7. [单选题]You are installing Windows 2000 Server on a multiprocessor computer. The manufacturer has provided a customized Hardware abstraction layer (HAL) to use with the computer. The customized HAL is on a floppy disk.You want to install the customized HAL designed for the computer. What should you do?
A. During the text mode portion of the Windows 2000 setup, install the customized HAL.
B. After the text mode portion of Windows 2000 Setup is complete, use the Recovery Console to copy the customized HAL to the system32 folder on the boot partition, and then continue Windows 2000 Setup
C. After the text mode portion of windows 2000 Setup is complete, use the Emergency Repair process to replace the existing HAL with the customized HAL, and then continue the windows 2000 Setup.
D. After the Windows 2000 Setup is complete, use Device Manager to scan for Hardware changes. When prompted, install the customized HAL.
8. [单选题]You are the administrator of a Windows 2000 Server network. On each server, you format a separate system partition and a separate boot partition as NTFS.Several months later, you shut down one of the servers for the maintenance. When you try to restart the server, you receive the following error message "NTLDR is missing. Press any key to restart".
A. You want to install a new NTLDR file on the server, but you do not want to lose any settings you made since the original installation. What should you do?
B. Start the computer by using the Windows 2000 Server CD-ROM and choose to repair the installation. Select the Recovery Console and copy the NTLDR file on the CD-ROM to the root of the system volume.
C. Start the computer by using the Windows 2000 Server CD-ROM and choose to reinstall. When installation is complete, copy the NTLDR file to the root of the boot volume.
D. Start the computer by using a Windows 2000 bootable floppy disk. From the command prompt, run the sfc/scanboot command.
E. Start the computer by using a Windows 2000 bootable floppy disk. Run the File Signature Verification utility.
9. [多选题]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.
10. [多选题]You are installing Windows 2000 Server on a new computer that has a single 10-GB SCSI disk. The disk controller is not included on the current Hardware Compatibility List (HCL). You start the computer by using the Windows 2000 Server CD-ROM.When the computer restarts at the end of the text mode portion of Windows 2000 setup, you receive the following STOP error: "INACCESSIBLE_BOOT_DEVICE."
A. Which two actions should you take to eliminate the STOP error? (Choose Two)
B. Restart the Windows 2000 Setup by using the Windows 2000 Server CD-ROM.
C. Select Safe Mode from the Windows 2000 boot menu.
D. Remove the Windows 2000 Server CD-ROM from the CD-ROM drive.
E. Install a driver for the SCSI controller from a floppy disk.
F. Use Device Manager to update the driver for the SCSI controller.
