1. [多选题]You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
A. Save the DTS package so that it has an owner password.
B. Save the DTS package so that it has a user password.
C. Encrypt the DTS package details in the command line of the dtsrun utility.
D. Store the DTS package in the Meta. Data Services repository.
E. Store the DTS package as a Microsoft Visual Basic file.
2. [单选题]You configure a Group Policy Object for the Marketing organizational unit (OU) to prevent users from accessing My Network Places and from running System in Control Panel. You want the Managers domain local group to be able to access My Network Places, but you still want to prevent them from running System in Control Panel.What should you do?
A. Add the managers group to the access control list of the GPO. Disable the permission of the managers group to read and apply the group policy.
B. Add the managers group to the access control list of the GPO. Deny the permission of the managers group to read and apply the group policy.
C. Create a second GPO in the OU. Add the managers group to the access control list. Allow the managers group to apply the group policy. Deny the authenticated users group permission to read and apply group policy. Configure the new GPO to deny the ability to run System in Control Panel. Give the original GPO a higher priority than the new GPO.
D. Create a second GPO in the OU. Add the managers group to the access control list. Allow the managers group to read and apply the group policy. Disable the permission of the authenticated user group to read and apply the group policy. Configure the new GPO to allow access to My Network Places. Give the new GPO a higher priority than the original GPO.
3. [单选题]You are the network administrator for Ezonexam. You are planning to upgrade 35 Windows NT Server 4.0 computers to Windows 2000 Server. You want to accomplish the upgrades by using a distribution server. The Windows NT Server 4.0 computers support a tight production schedule that requires them to be online from 8:00
A. M. to midnight, seven days a week. You schedule the upgrade to run during non-business hours. Because of the limited amount of time the upgrades must be performed as quickly as possible.You want to complete the upgrades before production begins in the morning.
B. What should you do?
C. Perform. an unattended installation by running the winnt32 command and the /cmdcons switch.
D. Perform. an unattended installation by running the winnt32 command and specify the use of a .txt file and a uniqueness database file.
E. Perform. an unattended installation by running the winnt command and specify the use of a .txt file and a uniqueness database file.
F. Perform. an unattended installation by using a Winnt.sif file with a commands section that initiates the Update.exe command in quiet mode.
4. [单选题]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.
5. [单选题]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.
6. [单选题]You are the administrator of a network that includes Windows NT Server 4.0 computers, Windows NT Workstation 4.0 computers, and UNIX computers. The network consists of a single Windows NT domain.You are upgrading a Windows NT Server computer named Server1 to Windows 2000 Server. Server1 is a BDC in the domain. The existing DNS server is a UNIX computer that supports SRV (service) records and is configured to accept dynamic updates. The existing WINS server is another Windows NT Server computer.
A. You want to configure Server1 as a domain controller in a New Active Directory forest. You want the existing Windows NT domain accounts to be upgraded to Active Directory. You plan to upgrade the other domain controllers in the domain to Windows 2000 after the upgrade of Server1 is complete.
B. You want to perform. the upgrade of Server1 with the least possible impact on other computers on the network. What should you do?
C. Promote Server1 to the PDC of the domain. Run Windows 2000 Setup on Server1.
D. Run Windows 2000 Setup on Server1. At the end of Setup, configure Server1 as a DNS server and a WINS server.
E. Add a static mapping for Server1 on the WINS server. On the DNS server, create an SRV record for the LDAP service on Server1. Run Windows 2000 Setup on Server1.
F. Install the Microsoft DNS service on an existing Windows NT server. Apply Windows NT 4.0 service pack 4 or later to the server. Run Windows 2000 Setup on Server1.
7. [多选题]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.
8. [单选题]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.
9. [单选题]You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.
A. After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.
B. You need to make the New York City server a target server instead of a master server. What should you do?
C. On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.
D. On the JobMaster server, enlist all other servers as target servers.
E. On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.
F. On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.
10. [单选题]You want to upgrade 400 computers from Windows 95 to Windows 2000 Professional. Most of the computers in your company use the same hardware. However, several different peripheral devices are used throughout the company.You want to verify that the hardware in use is compatible with Windows 2000 Professional. You want to accomplish this with least amount of administrative effort.
A. What should you do?
B. Create several different computer configurations. Install Windows 2000 Professional and enable driver signing.
C. Create a bootable floppy disk that contains and automatically runsWinNT32.exe/CheckUpgradeOnlyQ. Send the floppy disk to each user on the network.
D. Copy the contents of Windows 2000 Professional CD-ROM to a network share. From the network, modify your network logon scripts to runWinNT32.exe/Unattended:ReportOnly.
E. Use Setup Manager to create a Setup.inf file. Add the entryReportOnly=Yes to the [Win9xUpg] section of the answer file. RunWinnt32.exe /Unattended:Setup.infon all of the different computer configurations.