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

正确答案 ：D

Ensure that write caching disk controllers have battery backups.

解析：解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.

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

解析：解析：Explanation:Thehardwareabstractionlayer(HAL)isinstalledduringtheinstallationoftheoperatingsystem.UsuallytheoperatingsystemwilldetecttheHALandinstallastandardHAL.Toinstallthecustomizedhardwareabstractionlayer(HAL)designedforthecomputerthatthemanufacturerhasprovidedwemustpressF6whentheWindows2000setuppromptsustodoso.ThiswillallowustosupplythesetupprogramwiththecustomizedHALthatshouldbeinstalled.TosupplyaHALfiletoSetup,weshouldpressF5andspecifythetypeofcustomHardwareAbstractionLayer(HAL)tobeloadedbytheSetupLoaderandinstalledbytext-modeSetup.Incorrectanswers:B:TheRecoveryConsoleisnotusedtoinstalltheHAL.C:TheEmergencyRepairprocessisnotusedtoinstalltheHAL.D:DevicemanagercouldbeusedtoupgradetheHALformultiprocessorsupport.However,theHALisconfiguredduringtheWindows2000installationphase.

[单选题]You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

正确答案 ：F

On the server in Sydney, install an OLE DB provider for the mainframe. database.

解析：解析：Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company's mainframe. database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company's mainframe. database.

[单选题]You are upgrading a computer from Windows 98 to Windows 2000 Professional. The computer is a 400-Mhz Pentium III, and has 128 MB of RAM and a 10-GB hard disk. You are performing the installation by using the Windows 2000 Professional CD-ROM. After the text mode installation portion is complete, you restart the computer. The BIOS virus checker on your computer indicates you're your computer is infected with a Master Boot Record virus.What should you do before you continue the installation?

正确答案 ：B

Disable the BIOS virus checker and restart the computer.

解析：解析：Explanation: During the installation of Windows 2000, the setup program must make changes the boot sector. The BIOS virus checker interprets changes made to the boot sector as the result of a virus and prevents the computer from booting any further. You must therefore disable the BIOS virus checker.

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

正确答案 ：E

Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.

解析：解析：Explanation:WhenupgradingearlierversionsofWindowstoWindows2000wemustusewinnt32.exeandmustlaunchitfromwithintheWindowsenvironment.Incorrectanswers:A:Windows2000canbeinstalledorupgradedonadiskorpartitionthatisformattedwiththeFATfilesystem.ThereisthusnoneedtoconvertthefilesystemtoNTFS.B:TheAdvancedConfigurationandPowerInterfaceisusedforpowermanagementanddoesnotaffecttheinstallationorupgradeprocess.ItwouldthusnotbenecessarytodisableACPI.D:ThesetupfloppydisksuseWinnt.exetoinstallWindows2000.WehowevercanonlyusethesetupfloppydiskstoinstallacleancopyofWindows2000onthecomputer.WecannotupgradetheoperatingsystemtoWindows2000usingthesetupfloppydisks.Wemustusewinnt32.exetoupgradeearlierversionsofWindowstoWindows2000.

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

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

解析：解析：Explanation:InthisscenariowemustuseSetupManagertocreateawinnt.sif.Wemustthencopythisfiletoafloppy.ThenstarttheinstallationprocessfromtheCD-ROMandinsertthefloppydisk.Theinstallationprocesswillbeafullyautomatedunattendedinstallation.Incorrectanswers:A:The.SIFfileisusedtoperform.anunattendedinstallation.Makebt32.exeisusedtocreatefourinstallationstartupdisks.B:Thewinnt.execommandisrunfromtheCD-ROMnotfromthediskette.D:TheSIFfilemustresideonadiskettenotontheCD-ROM.

[单选题]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 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 a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)

正确答案 ：ABE

Apply a bulk update lock to the table.

Use separate client connections to load the files into the table simultaneously.

Specify the Bulk-Logged Recovery model for the database.

解析：解析：Explanation:

查看原题