You are the administrator of a SQL Server 2000 computer. You

【名词&注释】

布丁学网发布"You are the administrator of a SQL Server 2000 computer. You"考试试题下载及答案，更多微软认证的考试试题下载及答案考试题库请访问布丁学网计算机类考试频道。

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

查看答案&解析查看所有试题

学习资料：

[单选题]Your network includes Windows 2000 Professional client computers, Windows NT Workstation 4.0 client computers, Windows 95 client computers and UNIX client computers. Users of the Windows operating systems send print jobs to shared printers on a Windows 2000 Server computer named PrintServ. The UNIX client computers support the LPR printing protocol.You want to make the shared printers on PrintServ available to the UNIX computers. What should you do?

A. Configure each of the printers to use an LPR port.
B. Install Microsoft Print Services for UNIX on PrintServ.
C. Configure each of the printers to support TCP/IP printing.
D. Use the SRVANY utility from the Windows NT Resource Kit to run the LPR program as a service.

[单选题]You create two shared printers on a Windows 2000 Server computer in Ezonexam.com Ezonexam. One printer is shared as Admin, and the other printer is shared as Executive. Both printers are connected to the same print device. You set the priority of the Admin printer to 90 and the priority of the Executive printer to 50.You want all users at the Ezonexam network to be able to send print jobs to either printer. However, you do not want the Executive printer to appear in the browse list when employees other than executives and administrative assistants create a new printer connection on their client computers.

A. What should you do?
B. Change the priority of the Executive printer to 99. Change the priority of the Admin printer to 10.
C. Change the share name of the Executive printer to Executive$. Manually reconfigure client computers that are already connected to the Executive printer.
D. Deny the Everyone group permission to access the Executive printer. Allow access to the users who are allowed to include the printer in their browse lists.
E. Install separate device drivers for the Executive printer. Configure NTFS permissions on the device driver files to allow access only to the System account and to users who are allowed to include the printer in their browse lists.

[单选题]You are the administrator of Ezonexam.com's network.You want to connect your Windows 2000 Professional computer to a new TCP/IP based laser print device. The print device is Plug and Play compliant and is included on the current Hardware Compatibility List (HCL). When you attempt to create a new TCP/IP printer port you receive the following error message:

A. "Specified Port cannot be added. The port already exists."
B. You want to be able to use the new TCP/IP printer.
C. What should you do?
D. Modify the properties of the existing printer port to use the new print device.
E. Change the LPT port setting to bidirectional in the BIOS on your computer.
F. Change the LPT port setting to enable legacy Plug and Play detection on your computer.
G. Obtain and install the WDM-compliant device drivers and printing software for the printer.

[单选题]You are the network administrator for Ezonexam.com.You are planning to install 10 new Windows 2000 Server computers. Ezonexam has a tight production schedule that requires no changes be made to the Active Directory except during scheduled outages. You schedule the installations during an upcoming network outage which will occur betweenmidnight and 8:00

A. M.
B. You want to complete the installations before production begins in the morning.
C. What should you do?
D. Perform. the installations by using four floppy disks create with the Makebt32.exe utility.
E. Perform. the installations by using four floppy disks create with the Makeboot.exe utility.
F. Perform. the installations by using the Windows 2000 Installation compact disc.
G. Perform. the installations by using the Windows 2000 Installation compact disc and a floppy disk containing a Winnt.sif file.

[多选题]You have stored confidential financial data in a shared folder named AccSecured on your Windows 2000 Professional computer. Your company hires an intern named Richard. You create a subfolder named intern, which Richard needs to access. You want to allow Richard access to the intern subfolder only.You create a user account named intern. You want to allow the intern user account the ability to update, create, and delete files within the intern folder. You need to prevent Richard from accessing any other files or folders within the AccSecured folder.

A. What should you do? (Choose all that apply)
B. Map a network drive to the AccSecured\intern folder from Richard's computer.
C. Map a network drive to the AccSecured shared folder from Richard's computer.
D. Allow the intern user account modify permissions on the intern subfolder.
E. Allow the intern user account traverse folder/execute file permission on the AccSecured folder.
F. Allow the intern user account list folder content permission on the AccSecured folder. Remove read extended attributes and read permissions.

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

A. Apply a bulk update lock to the table.
B. Use separate client connections to load the files into the table simultaneously.
C. Create a clustered index on the table.
D. Specify the Full Recovery model for the database.
E. Specify the Bulk-Logged Recovery model for the database.

[单选题]You are the administrator of Ezonexam.com's network.Ezonexam has several branch offices. Each branch office has a Windows 2000 Server computer with Service Pack 2 installed. Each branch office also has a technical support department. You want to configure the remote Windows 2000 Server computers so that whenever a new driver becomes available from Microsoft, the branch offices are notified automatically when the administrator logs on to the server.

A. What should you do?
B. Install Windows Update
C. Install the Windows 2000 Resource Kit.
D. Configure System File Checker to notify the branch offices.
E. Configure Window File Protection to notify the branch offices.

[单选题]You are the administrator of your company's network. An employee named Mark is leaving the company. A new employee named Eric has been hired to replace him.Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer.

A. You want Eric to have the same rights and permissions that Mark has. You want to ensure that Mark will no longer have access to the files and folders. You want to accomplish this with least administrative effort.
B. What should you do?
C. Rename Mark's user account to Eric and change the account password.
D. Create Eric's account by copying Mark's profile to Eric's account. Delete Mark's account.
E. Create Eric's account by copying Marks account. Delete Mark's account.
F. Delete Mark's account. Add Eric's account. Add Eric to the same groups to which Mark belonged. Grant Eric to all the individual user rights and permissions that Mark had.

本文链接：https://www.51ksbd.net/show/ng3wgl.html