[多选题]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.

正确答案 ：CF

Implement snapshot replication.

Schedule replication to run during off-peak hours.

解析：解析：Explanation:

[多选题]The network consists of a single domain named Ezonexam.com that includes 20 Windows NT workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers. You install Terminal Services on one of the Windows Server computers and Terminal Services Client on the 20 Windows NT Workstation 4.0 client computers. You create a system policy on the server that is configured as the terminal server. This system policy denies access to Network Neighborhood. You find that the users of the terminal server can still browse the network when they open My Network Places from Windows 2000 Professional computer or when they open Network Neighborhood from Windows NT Workstation 4.0 computers.You want to prevent all users from browsing the network.

正确答案 ：BD

Create a Windows Group Policy that denies user access to My Network Places.

Create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator.

解析：解析：Explanation: The primary domain controller (PDC) is the server that maintains the master copy of the domain's user-accounts database and that validates logon requests. Prior to Windows 2000 every Windows NT network domain was required to have one, and only one, PDC. If you want to deny users of the terminal server browsing ability of the Network Neighborhood, you should create a group policy that denies access to My Network Places. (Microsoft is colloquially stuck with Network Neighborhood for My Network Places.)

[单选题]You have 17GB of private files on drive D on your Windows 2000 Professional computer. You have shared the files as private_files. You do not want other users to see this share name in the browse list.You want all other share names to continue to appear in the browser list.What should you do?

正确答案 ：C

Change the share name to private_files$.

解析：解析：Explanation: By appending a dollar sign to the end of the share name, the share is hidden and the folder will not be shown in any browse list. Only users who know the folder name can gain access to it if they also possess the proper permissions to it.

[单选题]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.

解析：解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.

[单选题]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?

正确答案 ：C

Remove Paul from any other group that has been explicitly denied access to the Sales folder.

解析：解析：Explanation: The Sales group, which Paul is a member of, has permission to access the files. However, Paul still cannot access the files. It would seem that Paul has a permissions conflict. A user can be granted file permissions in a number of contexts: as a user or as a member of a user group. When a user has different file permissions in multiple contexts, the most restrictive permission is applied. Furthermore, the deny permission overrides all other permissions. As Paul does not have access to the file you must therefore assume Paul has explicitly been denied access to the file in some context, as member of one or more groups that have been denied access to the file. You would thus have to remove Paul from such a group so that the restriction is not applied to Paul.

[单选题]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.

正确答案 ：C

Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.

解析：解析：Explanation: Windows 2000 Professional uses the NTFS 5.0 file system while Windows NT Workstation 4.0 uses the NTFS 4.0 file system. Windows NT Workstation requires Service Pack 4 or later to be able to use the NTFS 5.0 file system.

[单选题]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?

正确答案 ：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.

解析：解析：Explanation: The ALTER COLUMN clause of the ALTER TABLE statement can be used to change the definition of a column and can be used to alter the precision and scale values of the data types. The destination precision should be changed so no data would be lost. The transformation to a data type with higher precision is automatic and would not require any coding.

[单选题]You want to configure a multiboot system with Windows NT Workstation and Windows 2000 Professional.What should you do?

正确答案 ：C

Install service pack four or later in Windows NT Workstation.

解析：解析：Explanation: In this scenario a computer should be configured for a dual boot between Windows NT Workstation and Windows 2000 Professional. Windows 2000 Professional uses the NTFS 5.0 file system while Windows NT Workstation 4.0 uses the NTFS 4.0 file system. Windows NT Workstation requires Service Pack 4 or later to be able to use the NTFS 5.0 file system.

[单选题]You are upgrading computer1 and computer2 from Windows NT Workstation 4.0 to Windows 2000 Professional. You successfully upgrade computer1. During the upgrade of computer2, a series of power outages interrupts the upgrade.You discover that the upgrade of computer2 is incomplete. Furthermore, you find that computer2 can no longer run Windows NT workstation 4.0. Computer2 does not support booting from the Windows 2000 Professional CD-ROM. You decide to use computer1 to help recover the failed upgrade.

正确答案 ：D

On the computer1, run Makebt32.exe from the Bootdisk folder on the Windows 2000 Professional CD-ROM. On computer2, restart the upgrade by using the newly created floppy disks.

解析：解析：Explanation: You can create the four setup boot disks by using either makeboot.exe or makebt32.exe. Both are located in the \Bootdisk directory on the Windows 2000 installation CD. These disks can be used to restart the installation process on computer2.

[单选题]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

正确答案 ：D

Perform. an unattended installation by running the winnt32 command and specify the use of a .txt file and a uniqueness database file.

解析：解析：Explanation: Performing an unattended installation from a distribution server will work since the upgrade must be done in non-business hours.

查看原题 点击获取本科目所有试题