1. [单选题]You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
A. How should you configure SQL1?
B. Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
C. Add SQL2 as remote server.
D. Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
E. Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
2. [单选题]The company is buying 50 identical computers to run Windows 2000 Server in these offices. These servers must be installed to the company's standard configuration. You create a setup information file (SIF) that specifies the company's standard configuration.You want to automate the installation process as much as possible in the least possible amount of time.
A. What should you do?
B. Use Makebt32.exe to create four installation startup disks and add the SIF to the first disk. Instruct an employee at each office to start the installation by using these disks.
C. Create an MS-DOS boot disk that contains CD ROM drivers and the SIF and that runs the Winnt/S: D:\i386 command. Instruct an employee at each office to start the installation by using this disk.
D. Create a floppy disk that contains only the SIF. Instruct an employee at each office to start the installation by using the Windows 2000 Server CD-ROM, with the floppy disk inserted.
E. Create a Windows 2000 folder on a hard disk. Copy the Windows 2000 Server CD-ROM to the folder. Add the SIF to the folder. Copy the folder to a writable C Instruct an employee at each office to start the installation by using this C
3. [单选题]You are the administrator of a Windows NT 4.0 Terminal Server Edition computer. The server has one hard disk, which is divided into two partitions The first partition contains the Windows NT 4.0 system files and is formatted as FAT. The second partition contains application data and user data. This second partition is formatted as NTFS. The server currently has Service Pack 3 installed.You need to upgrade the server to Windows 2000 Server. You want to ensure that no application data or user data is lost during the upgrade. You also want to perform. the minimum number of steps necessary to complete the upgrade.
A. What should you do? (Choose all that apply)
B. Convert the system partition to NTFS.
C. Install service pack4 or later on the server.
D. Use a Windows 2000 Server CD to start the server. In setup, select the option to upgrade.
E. Replace the Terminal Server installation with a standard Windows NT server 4.0 installation.
4. [单选题]You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.
A. What should you do?
B. Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
C. Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.
D. Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
E. Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.
5. [单选题]You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
A. The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
B. You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
C. What should you do?
D. Create an UPDATE trigger that sends an e-mail message.
E. Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
F. Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
G. Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
6. [单选题]You are the network administrator for Ezonexam.com. Your computer has a CD-ROM drive attached to a SCSI adapter. You plan to upgrade your computer from Windows NT Workstation 4.0 to Windows 2000 Professional. You determine that the SCSI adapter is not included on the current Hardware Compatibility List (HCL) and that the original SCSI drivers that you used for Windows NT are not compatible with Windows 2000 Professional.You want to upgrade your computer to Windows 2000 Professional.
A. What should you do?
B. Replace the SCSI adapter card with a Windows 2000 Professional compatible SCSI adapter. Start the installation from the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
C. Obtain Windows 2000 drivers from the SCSI adapter manufacturer. Copy the drivers to C:\Winnt folder. Start the installation from the Windows 2000 Professional CD-ROM.
D. Obtain Windows 2000 drivers from the SCSI adapter manufacturer. Start the installation by using the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
E. Modify Config.sys to use your existing SCSI adapter and existing CD-ROM drive. Using Windows NT 4.0, start the installation by running Winnt32.exe from the I386 folder on the Windows 2000 Professional CD-ROM.
7. [单选题]You want to install Windows 2000 Professional on 30 PXE-compliant computers and 35 non-PXE-compliant computers. All 65 computers are included on the current hardware compatibility list (HCL). You create a RIS image. You load the image on the RIS server. You then start the 65 computers.You find that the 30 PXE-Compliant computers can connect to the RIS server.
A. However, the 35 non-PXE-compliant computers fail to connect to the RIS server. What should you do?
B. Run Rbfg.exe to create a Non-PXE-compliant startup disk.
C. Run Riprep.exe to create a Non-PXE complaint startup disk.
D. Grant the Everyone group NTFS Read permission for the RIS image.
E. Grant the Administrators group NTFS Read permission for the RIS image.
8. [单选题]You want to install Windows 2000 Professional on 45 new computers on your company's network. You first install Windows 2000 Professional on one of the new computers.You log on to the computer by using the local Administrator account. You install Microsoft Office 97, a virus scanner, and other company-standard applications. You then create a RIS image of the computer you configured.
A. You want to configure the RIS image so that the standard applications will be accessible to the user when the user first logs on to the network. What should you do?
B. Run Rbfg.exe before installing the standard applications.
C. Run RIPrep.exe before installing the standard applications.
D. Copy the All Users profile to the Default Users profile.
E. Copy the local Administrator account profile to the Default Users profile
9. [单选题]You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.What should you do?
A. Configure an ADM template and add the template to the GPO.
B. Configure an INF policy and add the policy to the GPO.
C. Configure a Microsoft Windows installer package and add the package to the GPO.
D. Configure RIS to include the registry entry.
10. [单选题]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.
