1. [单选题]You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use the
A. SQL_Latin1_General_CP1_CI_AS collation.
B. You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.
C. What should you do?
D. Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.
E. Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.
F. Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.
G. Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
2. [单选题]You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.
A. You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.
B. What should you do?
C. Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
D. Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
E. Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
F. Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
3. [单选题]You are configuring 5 computers to use both Windows NT workstation 4.0 and Windows 2000 Professional. Each computer has an 8GB hard disk. You configure that hard disk on each computer to have two 4GB partitions. Windows NT workstation is installed on drive C. Windows 2000 Professional is installed on drive D. In Windows 2000 Professional you configure a disk quota on drive D to prevent users from saving work files on the disk. You restart the computer and load Windows NT workstation.You notice that users can still save files to drive D.
A. You want to prevent users from saving files to drive D in either operating system. You also want to ensure that users can access both drives using either operating system. What should you do on each computer?
B. Use Windows 2000 Professional to configure drive D as a dynamic volume.
C. Use Windows 2000 Professional to enable Encrypting File System (EFS) on drive D．
D. Use Windows NT workstation to configure NTFS permission on drive D to deny the users write permission.
E. Reinstall Windows NT workstation after configuring the disk code task.
4. [多选题]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.
5. [单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:BULK INSERT finance.dbo.customers
A. FROM ‘di\bulk\accts143_10141000.txt’
B. WITH DATAFILETYPE = ‘char’,
C. FIELD/TERMINATOR = ‘\t’,
D. ROWTERMINATOR = ‘\n,’
E. TABLOCK
F. You want to ensure that response times do not slow when new account information is added to the database. What should you do?
G. Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
H. Remove the TABLOCK option from the BULK INSERT statement.
I. Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
J. Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
6. [单选题]You want to upgrade 400 computers from Windows 95 to Windows 2000 Professional. Most of the computers in your company use the same hardware. However, several different peripheral devices are used throughout the company.You want to verify that the hardware in use is compatible with Windows 2000 Professional. You want to accomplish this with least amount of administrative effort.
A. What should you do?
B. Create several different computer configurations. Install Windows 2000 Professional and enable driver signing.
C. Create a bootable floppy disk that contains and automatically runsWinNT32.exe/CheckUpgradeOnlyQ. Send the floppy disk to each user on the network.
D. Copy the contents of Windows 2000 Professional CD-ROM to a network share. From the network, modify your network logon scripts to runWinNT32.exe/Unattended:ReportOnly.
E. Use Setup Manager to create a Setup.inf file. Add the entryReportOnly=Yes to the [Win9xUpg] section of the answer file. RunWinnt32.exe /Unattended:Setup.infon all of the different computer configurations.
7. [多选题]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.
8. [单选题]On a Windows 2000 Professional computer, you run a shipping application that prints packing labels to a laser printer for every outgoing shipment, 24 hours per day. During peak hours, your company ships more than 1,000 packages per hour.You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer.
A. What must you do next?
B. Enable bi-directional support.
C. Enable printer pooling.
D. Configure print spooling.
E. Configure print sharing.
9. [单选题]You are the administrator of a Windows 2000 Active Directory network. The network consists of a single domain. The domain includes 20 Windows NT Workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers.You create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator. This default user policy denies access to Network Neighborhood. You then install Terminal Services on one of the servers and Terminal Services Client on the 20 Windows NT Workstation client computers.
A. You find that the users of the Terminal Server can still browse the network when they open My Network Places. You want to prevent all users from browsing the network.
B. What should you do?
C. Modify the Windows NT policy template file so that you can restrict access to both My Network Places and Network Neighborhood. Save the policy file on the Terminal Server.
D. Copy the Windows NT policy file to the 20 Windows NT Workstation computers.
E. Create a Windows 2000 Group Policy that denies user access to My Network Places.
F. Edit the local registry on the Windows NT Workstation computers to deny access to Entire Network in Network Neighborhood.
10. [单选题]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.
