1. [多选题]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)
A. Add Maria's user account to the System group.
B. Add Maria's user account to the Interactive group.
C. Add Maria's user account to the Power Users group.
D. Add Maria's user account to the Administrators group.
E. Add Maria's user account to the Backup Operators group.
2. [多选题]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.
A. You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
B. Implement merge replication.
C. Implement snapshot replication.
D. Implement transactional replication.
E. Schedule replication to run continuously.
F. Schedule replication to run during off-peak hours.
3. [单选题]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:
A. --Detach the msdb database
B. --Send the database to the administrator in an e-mail message
C. --Reattach the msdb database
D. You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.
E. What should you do?
F. Ensure that the SQLServerAgent service is running under a user account that has database owner access to the msdb database
G. Delete the first and last steps in the job
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
I. Insert a new job step before the first step. Configure the new step to terminate all processes that use the msdb database
