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

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

[单选题]server’s msdb database in an e-mail message to the administrator of another SQL Server computer.You create a job that contains the following steps:

正确答案 ：H

Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message

解析：解析：Explanation:Thecurrentjobfailssincethedetachmsdbstatementfails.Itfailsbecausedetachingadatabaserequiresthatnooneisusingthedatabase.ThemsdbdatabaseisusedbytheSQLServerAgentservice,whichperformsscheduledactivitiessuchasbackupsandreplicationtasks.Wewanttosendthemsdbdatabase.Themsdbdatabasecouldbedetachedifallprocessesthatuseitwhereterminated.Thenwecouldsendthedatabasefileandreattachthemsdbdatabase.Thiswouldstopscheduledtasksfrombeingrunduringthisperiod.Abetterapproachwouldtobetobackupthedatabaseandsendthetemporaryfileinstead.Note:AnewSQLServer2000installationautomaticallyincludessixdatabases:master,model,tempdb,pubs,Northwind,andmsdb.Themaster,model,andtempdbdatabasescannotbedetached.Incorrectanswers:A:TheproblemthattheSQLServiceAgentisusingthemsdbdatabase.ThisproblemwouldstillbethereevenuseraccountrunningtheSQLServerAgentserviceischanged.B:ThemsdbdatabaseisusedbytheSQLServerAgentserviceandthedatabasefilewouldbelocked.Itcannotbesentdirectlyinane-mailmessage.D:Themsdbdatabasecouldbedetachedifallprocessesthatuseitwhereterminated.Thenwecouldsendthedatabasefileandreattachthemsdbdatabase.Thiswouldstopscheduledtasksfrombeingrunduringthisperiod.

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