[单选题]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 recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professional. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.What should you do to accomplish these goals? (Choose all that apply)

正确答案 ：CE

Add Maria's user account to the Power Users group.

Add Maria's user account to the Backup Operators group.

解析：解析：Explanation: By adding Maria's user account to the Power Users group Maria will inherit the ability to share resources and install programs on the computer. To grant Maria the ability to backup files she must be added to the Backup Operators group, which has the permissions to backup files. As a member of this group Maria will be able to backup files as she will inherit those rights by virtue of being a member of that group. Maria will not have permissions to read the users' files as neither the Power Users group nor the Backup Operators group have the permissions to read other users' files.

[单选题]Your Windows 2000 Professional computer contains a single hard disk configured as a single partition.You want to move a folder named Sales under a folder named Corp on your computer.

正确答案 ：D

Backup the Sales folder. Move the Sales folder to the Corp folder.

解析：解析：Explanation: The contents of the Sales folder should be backed up so that files would be recoverable in case of disk problems. You could move the Sales folder to the CORP folder, as the files will remain compressed since the folder is moved within a single partition. The general rules on copying and moving compressed files and folder are: files and folders copied within a NTFS volume and between NTFS volumes inherit the compression state of the target folder; files and folders moved between NTFS volumes inherit the compression state of the target folder; and files and folders moved within an NTFS volume retain the original compression state of the file or folder.

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

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

查看原题 查看所有试题