1. [单选题]You copy the contents of the Windows 2000 Professional CD to a shared network folder named \\Server1\Win2000p. You use the shared folder to perform. over-the-network installations of Windows 2000 Professional on new computers purchased by your company.You receive a Windows 2000 Service Pack CD. You apply the Service Pack to Server1 and to the \\Server1\Win2000p folder.
A. You discover that the Service Pack contains several files that are incompatible with the new computers.
B. You want to make sure that the Service Pack files are not installed on any new computers until the problem has been corrected. What can you do?
C. Use Update.exe from the Service Pack CD on server1.
D. Select the Uninstall option.
E. Copy the contents of the Windows 2000 Professional CD to \\Server1\Win2000p again, allowing the operating system to overwrite newer files while copying.
F. Run\\Server1\Win2000p\WinNT32.exe/uon the new computer.
G. RunUpdate.exe/s:\\Server1\Win2000p/ufrom the Service Pack CD on Server1.
2. [单选题]You are the administrator of Ezonexam's network. You want to deploy a Windows 2000 Professional service pack to 10 computers in the Development organizational unit.You create a Windows 2000 installer package file for the service pack. You use the package file to successfully install the service pack to other computers in the domain. You assign the package file to the Development organizational unit. After the installation, you notice that the service pack was not installed on any of the 10 computers.
A. You want to ensure that the service pack is successfully installed on the computers in the Development organizational unit. What should you do?
B. Use Computer Management to start the Windows installer service on all the computers in the Development organizational unit
C. Use the local administrator account to log on to the computers in the Development organizational unit. Then redeploy the service pack to the computers in the Development organizational unit.
D. Run Windows Installer to repair the package file. Then redeploy the service pack to the computers in the Development organizational unit.
E. Add the user accounts from the Development organizational unit to a DACL. Grant the user accounts read permission to the service pack deployment directory.
3. [单选题]From your Windows 2000 Professional computer, you need to map drive G to the default administrative share on drive C of a server named AppSrv.What can you do to map the drive?
A. Run thenet share C$=G:\command.
B. Run thenet use G: \\AppSrv\C$command.
C. Browse to AppSrv in Windows Explorer, and map drive G to the C$ share.
D. Browse to AppSrv in My Network Places, and map drive G to the C$ share.
4. [单选题]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.
5. [单选题]You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.
A. You cancel the SQL Server upgrade wizard.
B. You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?
C. Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
D. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
E. Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
F. Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
6. [单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?
A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
C. Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
7. [单选题]You want to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. The system partition uses the FAT file system.You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM.
A. However, you receive the following error message, "You chose to install Windows 2000 on a partition that contains another operating system. Installing Windows 2000 on this partition might cause the operating system to function improperly".
B. You are unable to perform. the upgrade. What should you do to resolve the problem?
C. Convert the system partition to NTFS.
D. Disable Advanced Configuration and Power Interface (ACPI) support for the computer.
E. Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.
F. Remove the Windows 2000 Server CD-ROM and restart the computer by using the setup floppy disks.
8. [多选题]You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.
A. You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
B. Implement merge replication.
C. Implement snapshot replication.
D. Implement transactional replication.
E. Schedule replication to run continuously.
F. Schedule replication to run during off-peak hours.
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 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.
