1. [单选题]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.
2. [单选题]Your Windows 2000 Server computer has a 10-GB hard disk with two partitions: Drive C and drive D. Windows 2000 Server is installed on Drive D. Both partitions are formatted as NTFS. Your office experiences a power failure that causes your Windows 2000 Server computer to restart.When the computer is restarting, you receive the following error message "NTLDR is missing. Press any key to restart".
A. What should you do?
B. Start the computer by using Windows 2000 Server computer 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 partition.
C. Start the computer in debugging mode. Copy the NTLDR file on the CD-ROM to the root of the system partition.
D. Start the computer by using the Windows 2000 bootable floppy disk. From a 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.
3. [多选题]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.
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 a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN.After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAIN\sqladmin user account, which is a member of the local administrators group on HQSQL5.
A. You can use the HQMAIN\sqladmin user account to log on the HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do?
B. Revoke Log on interactivity rights for the HQMAIN\sqladmin user account.
C. Add the HQMAIN\sqladmin user account to the HQMAIN\Domain Admins group.
D. Select the Password Never Expires check box for the HQMAIN\sqladmin user account.
E. Grant Log on as a service rights to the HQMAIN\sqladmin user account.
