[单选题]Your Windows 2000 Professional computer has 10 shared folders that are available to other network users. A user reports that he cannot access a shared folder named Share
正确答案 ：F
Use System Tools in Computer Management to display the file paths of your shared folders.
解析：解析：Explanation: The System Tools component of the Computer Management console can be used to locate shared folders. The Computer Management console can be accessed through the Administrative Tools applet in the Control Panel. In the Computer Management console, expand System Tools, expand Shared Folders and then open Shares to display all shared folders.
[单选题]You need to install Windows 2000 Professional on 30 new computers. You also need to deploy a Windows 2000 Professional service pack during the installation.First, you create a network distribution folder named InstallFiles. You copy the i386 folder from the Windows 2000 Professional CD to the InstallFiles folder.
正确答案 ：E
From an existing client computer, run theUpdate -s:InstallFilescommand from the service pack to the InstallFiles folder.
解析：解析：Explanation: Service pack slipstreaming refers to a service pack being integrated with an updated version of Windows 2000 on a CD-ROM or on a network share. When Windows 2000 is installed from either source, the appropriate files from the service pack are installed without having to manually apply the service pack after the installation. To apply a new service pack, run Update.exe with the -s:distribution_folder switch, where distribution_folder is the name of the folder that contains the Windows 2000 installation files.
[单选题]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 a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
正确答案 ：C
Configure SQLAgentMail to use a valid MAPI profile
解析：解析：Explanation:SQLAgentMailmustbeusedwhenmailstoredproceduresareusedtosendnotificationstooperatorsbye-mailorpager.InordertouseSQLAgentMail,amailprofilemustbeconfiguredforSQLServerAgenttousetoconnecttothemailserverandthemailservermustbeextendedMAPI-compliant.IncorrectAnswers:B:SQLMailprovidesawaytoreceivee-mailmessagesgeneratedbySQLServer2000.Messagescanbetriggeredtoprovideinformationaboutthestatusofajoborawarningcausedbyanalert.SQLMailcanincludearesultsetinareplytoe-mailmessagesthatcontainqueriesandallowsSQLServertosendandreceivee-mailbyestablishingaclientconnectionwithamailserver.However,SQLMailmusthaveamailprofilecreatedinthesameuserdomainaccountorcontextthatisusedtostartaninstanceofSQLServer2000asitlooksforthedefinedmailprofileinthedomainaccountthattriggeredthee-malmessage.C:Netsendisusedtosendsmessagestootherusers,computers,ormessagingnamesacrossanetwork.TheMessengerservicemustberunningtoreceivemessages.Itisnotusedfore-mailorpagingpurposes.D:Thexp_startmailstoredprocedureisusedtostartaSQLMailclientsession.Ifthereisanexistingmailsession,xp_startmaildoesnotstartanewone.IfmailisbeingusedonthesamecomputeronwhichSQLServerisalsorunning,themailclientmustbestartedeitherbeforexp_startmailisexecuted,orbeforeSQLServerisstartedifSQLMailisconfiguredtoautomaticallystartwhenSQLServerstarts.
[单选题]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.
正确答案 ：F
Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
解析：解析：Explanation:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.IncorrectAnswers:A:ItisnotnecessarytouninstallSQLServer7.0.JustinstallSQLServer2000asthedefaultinstance.WecannotruntheSQLServerupgradewizardunlessSQLServer2000isinstalled.B:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.C:WewanttoensurethattheSQLServer6.5databasesarelistedintheSQLServer2000installationwizard.TocreateDTStransformationpackagesthatupgradeSQLServer6.5databaseestoSQLServer2000databaseswemustinstallSQLServer2000first.
[单选题]You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.What should you do?
正确答案 ：A
Configure an ADM template and add the template to the GPO.
解析：解析：Explanation: It is recommended that we should use the supplied Administrative Templates where possible. Administrative Templates propagate registry settings to a large number of computers without requiring us to have detailed knowledge of the registry. However, the administrator can create custom .adm files if the supplied templates are inadequate. In Windows 2000, we use Group Policy to set registry-based policies. In Windows NT 4.0, we used the System Policy Editor (Poledit.exe) to set System Policy.
[多选题]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:
[单选题]You are the administrator of a Windows NT 4.0 Terminal Server Edition computer. The server has one hard disk, which is divided into two partitions The first partition contains the Windows NT 4.0 system files and is formatted as FAT. The second partition contains application data and user data. This second partition is formatted as NTFS. The server currently has Service Pack 3 installed.You need to upgrade the server to Windows 2000 Server. You want to ensure that no application data or user data is lost during the upgrade. You also want to perform. the minimum number of steps necessary to complete the upgrade.
正确答案 ：C
Install service pack4 or later on the server.
解析：解析：Explanation: To ensure that no application data or user data is lost during the upgrade the following two steps will be taken:
[单选题]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 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.
正确答案 ：D
Add cohovineyard.com to the Domain Suffix Search Order on the computers.
解析：解析：Explanation: ServerA is located in the domain cohovineyard.com. If you add cohovineyard.com to the domain suffix then http://ServerA will translate to http://ServerA.cohovineyard.com, which would resolve this problem. This configuration can be done by opening TCP/IP properties, selecting the Advanced button, selecting the DNS tab, selecting 'Append these DNS Suffixes (inorder)', selecting Add, and entering cohovineyard.com
查看原题
