1. [多选题]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.
2. [单选题]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.
3. [单选题]You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
A. While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
B. You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?
C. Configure SQLAgentMail to use a valid MAPI profile
D. Configure SQL Mail to use a mailbox that delegates permissions to the operator
E. Use the net send notification method to send the operator e-mail messages
F. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts
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. [单选题]Your network includes Windows 98 computers and Windows 2000 Server computers. You are adding a new computer to the network, and you plan to install Windows 2000 Server on the new computer. The computer has one 20-GB hard disk with no partitions defined.The Windows 2000 Server CD-ROM is unavailable. You want install Windows 2000 Server from source files that are located on a server on the network. You also want the entire hard disk of the new computer to be used for the system partition.
A. What should you do?
B. On another Windows 2000 computer, use Makebt32.exe to create installation startup disks. Start the new computer by using the first disk.
C. On another 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.
D. Start the new computer by using a Windows 98 network boot disk. Connect to the network server. Run Dsclient.exe. Create and format a 20-GB FAT32 partition.
E. Start the new computer by using a Windows 98 network boot disk. Create and format a single FAT32 partition. Connect to the network server. Run Winnt.exe.
F. Start the computer by using a Windows 98 network boot disk. Create and format a single FAT32 partition. Start the new computer by using a Windows 2000 Emergency Repair Disk.
