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. [单选题]You are the administrator of the Coho Vineyard network. The network consists of 10 Windows 2000 Advanced Server computers and 250 Windows 2000 Professional computers.Your company has two domains cohovineyard.com and westcoastsales.com.
A. ServerA is in the cohovineyard.com domain and is running Internet Information Services (IIS) and Microsoft Proxy Server 2.0
B. You want to configure the Windows 2000 Professional computers in the westcoastsales.com domain to access the intranet site. You want users to be able to connect to the intranet site by using the URL http://serverA rather than its fully qualified domain name.
C. What should you do?
D. Add cohovineyard.com to the Domain Suffix Search Order on the computers.
E. Add westcoastsales.com to the Domain Suffix Search Order on the computers.
F. Add westcoastsales.com to the exceptions list in the proxy server settings on the computers.
G. Configure the proxy server settings on the computers to bypass the proxy server for intranet addresses.
3. [单选题]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.
4. [单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
A. What should you do?
B. Enable the torn page detection database option for each database.
C. Disable write caching on all disk controllers.
D. Ensure that write caching disk controllers have battery backups.
E. Create a database maintenance plan to check database integrity and make repairs each night.
5. [单选题]You are the network administrator for Ezonexam.com.You are planning to upgrade 10 Windows NT Server 4.0 computers to Windows 2000 Server. You want to perform. the upgrades by means of a distribution folder. You have used the distribution folder to successfully upgrade other Windows NT Server 4.0 computers to Windows 2000. For these 10 new upgrades you wan to include a new service pack.
A. You need to include the new service pack in the distribution folder so that the service pack is automatically installed during the upgrade process.
B. What should you do?
C. Create a sub folder named $OEM$\$C\SP under the i386 folder. Copy the new service pack to that subfolder.
D. Create a subfolder named $OEM$\$$\SP under the i386 folder. Copy the new service pack to that subfolder.
E. Run Update.exe from the new service pack and specify the -s option.
F. Run winnt32 on the Windows NT Server 4.0 computers and specify the /u option
6. [单选题]You are the administrator of a Windows 2000 Server network. On each server, you format a separate system partition and a separate boot partition as NTFS.Several months later, you shut down one of the servers for the maintenance. When you try to restart the server, you receive the following error message "NTLDR is missing. Press any key to restart".
A. You want to install a new NTLDR file on the server, but you do not want to lose any settings you made since the original installation. What should you do?
B. Start the computer by using the Windows 2000 Server 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 volume.
C. Start the computer by using the Windows 2000 Server CD-ROM and choose to reinstall. When installation is complete, copy the NTLDR file to the root of the boot volume.
D. Start the computer by using a Windows 2000 bootable floppy disk. From the 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.
7. [单选题]Ezonexam.com's network contains two domain controllers and approximately 500 client computers. The domain controllers run Windows 2000 Server. The client computers run Windows 2000 Professional. The majority of users have mobile computers. Users in Ezonexam often travel with their mobile computer for extended periods of time and do not have remote access to Ezonexam.com's network.You want to configure the domain controllers so that DNS only contains entries for computers that are active on the network. You also want to ensure that when users return you do not have to manually create or delete DNS entries.
A. How should you configure the DNS servers?
B. Configure both domain controllers with Active Directory integrated primary zones for the domain and enable secure dynamic updates for the zone.
C. Configure both domain controllers with Active Directory integrated primary zones for the domain and the secure cache against pollution option for the zone.
D. Configure both domain controllers with Active Directory integrated primary zones for the domain and enable scavenging and dynamic updates for the zone.
E. Configure both domain controllers with standard primary zones for the domain and enable scavenging for the zone.
F. Configure one server with a standard primary zone for the domain, and configure at least one server with an Active Directory integrated primary zone.
8. [多选题]You have stored confidential financial data in a shared folder named AccSecured on your Windows 2000 Professional computer. Your company hires an intern named Richard. You create a subfolder named intern, which Richard needs to access. You want to allow Richard access to the intern subfolder only.You create a user account named intern. You want to allow the intern user account the ability to update, create, and delete files within the intern folder. You need to prevent Richard from accessing any other files or folders within the AccSecured folder.
A. What should you do? (Choose all that apply)
B. Map a network drive to the AccSecured\intern folder from Richard's computer.
C. Map a network drive to the AccSecured shared folder from Richard's computer.
D. Allow the intern user account modify permissions on the intern subfolder.
E. Allow the intern user account traverse folder/execute file permission on the AccSecured folder.
F. Allow the intern user account list folder content permission on the AccSecured folder. Remove read extended attributes and read permissions.
9. [单选题]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.
10. [单选题]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.
