微软认证 - 网络工程师考试辅导

网络工程师考试辅导

不定项选择题

You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit. The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log. You want to optimize database performance. What should you do？

Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
B. Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
C. Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive F
D. Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E

查看答案

不定项选择题

You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN. After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAIN\sqladmin user account, which is a member of the local administrators group on HQSQL5. You can use the HQMAIN\sqladmin user account to log on the HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do？

A. Revoke Log on interactivity rights for the HQMAIN\sqladmin user account.
B. Add the HQMAIN\sqladmin user account to the HQMAIN\Domain Admins group.
C. Select the Password Never Expires check box for the HQMAIN\sqladmin user account.
D. Grant Log on as a service rights to the HQMAIN\sqladmin user account.

查看答案

不定项选择题

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company. The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers. How should you configure the database？

A. Configure the database on the two servers as a SQL Server 2000 cluster.
B. Configure the database on one server, and then configure a standby database on the second server.
Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
D. Configure the database as a federated database, and then partition half the data on each server.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers. Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month. You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication？ (Each correct answer presents part of the solution. Choose two)

A. Store the snapshot in the default folder on the Publisher/Distributor.
B. Store the snapshot in an alternative folder on the Publisher/Distributor.
C. Store the snapshot in a shared folder on a file server.
D. Create pull subscriptions.
E. Create push subscriptions.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of Oracle relational database management system (RDBMS) server. This server is used to store your company’s financial information. The financial information is updated frequently throughout the day. You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day. You want to create reports on the SQL Server computer by using the minimum amount of disk space. What should you do？

A. Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.
B. Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C. Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.
D. Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

查看答案

不定项选择题

You want the package to execute automatically each evening at 8:00 P.M. What should you do？

A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.

查看答案

不定项选择题

You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit. You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space. What should you do？

Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B. Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C. Rebuild all clustered indexes so that they have a fill factor of 100.
D. Compress drive D.

查看答案

不定项选择题

You are preparing to install Windows 2000 Server on a new computer. The computer is connected to a network that includes Windows 98 computers and Windows 2000 Server computers. You want to install Windows 2000 Server from source files that are located on a server on the network. What should you do？

A. Start the new computer by using a Windows 98 network boot disk. Connect to the network server. Run Winnt32.exe.
B. Start the new computer by using Windows 98 network boot disk. Connect to the network server. Run Winnt.exe.
C. On a Windows 2000 Server computer, use Makebt32.exe to create installation startup disk. Start the new computer by using the first disk.
D. On a Windows 2000 computer, format a floppy disk. Copy NTLDR, boot.ini, Ntdetect.com, Ntbootdd.sys to this disk. Start the new computer by using the disk.

查看答案

不定项选择题

You are the network administrator for Ezonexam.com. 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. What should you do？

A. Change the priority of the Executive printer to 99. Change the priority of the Admin printer to 1.
B. Deny the Everyone group the Manage Printers permission.
Change the printer configuration to Not Shared.
D. Clear the List in the Directory check box in the printer configuration.

查看答案

不定项选择题

You are the network administrator for Ezonexam.com. The file server for the accounting department is a Windows 2000 Server computer named Ezonexam1. You have created a folder named Payments on the system partition of Ezonexam1. Payments is shared on the network as Payments with the default share permissions. The owner of the Payments folder is domain Admins. The NTFS permissions are shown in the following table. NTFS Permissions Domain Admins: Allow Read Accounting: Allow Full Control There is a file called review.doc in the Payment folder. The owner of review.doc is a user named Paul who is on a temporary leave of absence. The NTFS permissions for the file list only Paul on the access control list, with Full Control permission. You want to remove Paul's access to review.doc and grant the Modify permission for a user named Lily Loo. You open the Security properties of review.doc and discover that you are unable to modify the permissions of the file. You want to be able to remove Paul's access and grant Lily Loo the Modify permission on review.doc. What should you do？

A. Take ownership of the file.
B. Take ownership of the Payments folder.
C. Grant Domain Admins Full control of the Payments shared folder.
D. Grant Domain Admins Change for the Payments shared folder.

查看答案