1. [多选题]You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.
A. You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
B. Perform. a combination of full database and filegroup backups.
C. Perform. a combination of full database and file backups.
D. Perform. a combination of full database, differential, and transaction log backups.
E. Back up the data to a local tape drive.
F. Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.
2. [单选题]You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?
A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C. Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
3. [单选题]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.
4. [单选题]You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.
A. You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.
B. You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.
C. You want to enable the server in Sydney to connect to the mainframe. database. What should you do?
D. Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.
E. Modify the workflow in the DTS package so that the server in Sydney is included.
F. On the server in Sydney, install an OLE DB provider for the mainframe. database.
G. On the server in Sydney, delete and then re-create the DTS package.
5. [单选题]You are the administrator of Ezonexam.com's Windows 2000 network.Your computer is configured to use both Windows 2000 Professional and Windows NT Workstation 4.0 Service Pack 3. Your computer has three hard disks: Disk 0, Disk1, and Disk2. Windows NT Workstation 4.0 is installed on Disk 0. Windows 2000 Professional is installed on Disk1. You want to store your project files on Disk2. You configure Disk2 as a basic volume and format the volume as NTFS in Windows 2000 Professional. You then start Windows NT Workstation 4.0. You find that you cannot access your project files.
A. You want to be able to access your project files when using either of the operating systems.
B. What should you do?
C. Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.
D. Configure Disk 2 as a dynamic volume then format as an NTFS partition.
E. Configure Disk 2 to use Encrypting File System (EFS).
F. Configure Disk 2 as a basic volume and format the volume as FAT32.
6. [单选题]You are preparing to install Windows 2000 Server on a new computer. The computer is connected to a network that includes Windows 98 computers and Windows 2000 Server computers.You want to install Windows 2000 Server from source files that are located on a server on the network.
A. What should you do?
B. Start the new computer by using a Windows 98 network boot disk. Connect to the network server. Run Winnt32.exe.
C. Start the new computer by using Windows 98 network boot disk. Connect to the network server. Run Winnt.exe.
D. On a Windows 2000 Server computer, use Makebt32.exe to create installation startup disk. Start the new computer by using the first disk.
E. On a Windows 2000 computer, format a floppy disk. Copy NTLDR, boot.ini, Ntdetect.com, Ntbootdd.sys to this disk. Start the new computer by using the disk.
7. [单选题]Your Windows 2000 Professional computer has 10 shared folders that are available to other network users. A user reports that he cannot access a shared folder named Share
A. You want to respond to the user's problem as quickly as possible by using an administrative tool.
B. What should you do?
C. Use Windows Explorer to display the file paths of your shared folders.
D. Use Storage in Computer Management to view logical drive properties.
E. Use Event Viewer in Computer Management to search for shared folder error messages.
F. Use System Tools in Computer Management to display the file paths of your shared folders.
8. [多选题]You want to upgrade a Windows NT Server 4.0 computer named Server34 to Windows 2000 Server. Server34 is a member server in a Windows 2000 domain named marketing.fabrikam.local. The domain runs in native mode.You want to change the role of Server34 from a member server to a domain controller in the same domain. What should you do? (Choose Two)
A. Reinstall Windows NT Server 4.0 on Server34 in the same WINNT folder, and make Server34 a B
B. D
C. in the marketing domain.
D. Use Server Manager on Server34 and promote Server34 to a PDC for the marketing domain.
9. [单选题]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.
10. [单选题]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
