1. [单选题]You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.You want to prevent any loss of data during the import operations. What should you do?
A. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.
B. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.
C. Set a flag on each DTS transformation to require an exact match between source and destination columns.
D. Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.
E. Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.
2. [单选题]You are the administrator of your company's network. A user named Paul in the service department has a Windows 2000 Professional computer. Paul needs to access the files that are in a shared folder on his computer. A local group named Sales has permissions to access the data. Paul is a member of the Sales local group but he cannot access the file he needs.What should you do?
A. Grant Paul NTFS permission so that he can access any parent folder to files in the shared folder.
B. Share the Sales folder and grant Paul shared folder permission to access the shared Sales folder.
C. Remove Paul from any other group that has been explicitly denied access to the Sales folder.
D. Delete the Sales local group and recreate it. Add individual user accounts from the Sales department back into Sales local group.
3. [单选题]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.
4. [单选题]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
5. [多选题]You need to install Windows 2000 Server on one of your older Windows NT Server 4.0 computers. The server has dual processors, 2 GB of RAM, a RAID controller with five SCSI hard disks in an array, and a generic 10/100-MB network adapter. You begin the server installation by updating the SCSI firmware.You then start the installation of the Windows 2000 Server operating system. During the next portion of the installation, you receive an error message indicating that no hard disks can be found.
A. You want to successfully install Windows 2000 Server on the computer.
B. What should you do? (Each correct answer presents part of the solution. Choose two)
C. Restart the installation by using the Windows 2000 Installation CD-ROM. Press F3 during the text-mode setup.
D. Restart the installation by using the Windows 2000 Installation CD-ROM. Press F6 during the text-mode setup.
E. Restart the installation by using a MS-DOS boot disk with a CD-ROM driver.
F. Insert a disk with the original SCSI firmware.
G. Insert a disk with the OEM SCSI driver.
6. [单选题]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.
7. [单选题]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.
8. [多选题]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.
9. [单选题]You need to install Windows 2000 Professional on a new computer in your network. You use the setup manager wizard to configure a fully automated installation script. file. You begin an unattended installation and leave the office.When you return, the installation has reached the GUI-mode setup and you see the following error message "Unattended setup is unable to continue because a setup parameter specified by your system administrator or computer manufacturer is missing or invalid."
A. You need to complete the installation. What must you do?
B. In the unattended section of the answer file, set theOemPreinstallproperty to Yes.
C. In the NetBinding section of the answer file, specify theEnablevariable.
D. In the UserData section of the answer file, specify theProductIDvariable
E. In the GUIUnattended section of the answer file set theOemSkipWelcomeproperty to 1.
10. [单选题]You are upgrading a computer from Windows 98 to Windows 2000 Professional. The computer is a 400-Mhz Pentium III, and has 128 MB of RAM and a 10-GB hard disk. You are performing the installation by using the Windows 2000 Professional CD-ROM. After the text mode installation portion is complete, you restart the computer. The BIOS virus checker on your computer indicates you're your computer is infected with a Master Boot Record virus.What should you do before you continue the installation?
A. Remove the virus checker in Windows 98.
B. Disable the BIOS virus checker and restart the computer.
C. Run Fixmbr.Exe from the Windows 2000 Professional CD-ROM.
D. Modify the Boot.ini file to include a signature parameter on the ARC path of the system partition.
