1. [单选题]You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you configure web sharing on Reports. You name the share WebReports and allow Read permissions on the share.You test the web share by pointing to http://admin01/WebReports from another computer. You receive the following error message, 'You are not authorized to view this page.'
A. You need to be able to access the folder. What must you do?
B. Allow write permission on WebReports.
C. Allow directory browsing permissions on WebReports.
D. In the IIS console, enable anonymous access to WebReports.
E. In the IIS console, set the execute permissions option to script. and executables on WebReports.
2. [多选题]You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.The net-libraries on SQL2000 are configured as shown in the exhibit.
A. SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.
B. SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.
C. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
D. On SQL2000, enable the multiprotocol net library.
E. On SQL2000, select the force protocol encryption check box.
F. On SQL7, select the force protocol encryption check box.
G. On SQL2000, install a secure sockets layer (SSL) encryption certificate.
H. On SQL2000 and SQL7, enable multiprotocol encryption.
3. [单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:BULK INSERT finance.dbo.customers
A. FROM ‘di\bulk\accts143_10141000.txt’
B. WITH DATAFILETYPE = ‘char’,
C. FIELD/TERMINATOR = ‘\t’,
D. ROWTERMINATOR = ‘\n,’
E. TABLOCK
F. You want to ensure that response times do not slow when new account information is added to the database. What should you do?
G. Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
H. Remove the TABLOCK option from the BULK INSERT statement.
I. Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
J. Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
4. [单选题]You are the administrator of Ezonexam's Windows 2000 network.You need to store secured files for Ezonexam's accounting and legal departments on a Windows 2000 Professional computer. You create two shared folders named Accounting and Legal with the default NTFS and share permissions. You also create two groups named Accounting and Legal and add the appropriate user accounts into the appropriate groups.
A. To meet the security requirements for the shared folders the following criteria must be met:
B. 1. Users in both departments must be able to update their own files from the network.
C. 2. Users in the accounting department must be able to view the legal department's documents from the network.
D. 3. Users in the legal department must be prevented from being able to view the accounting department's documents from the network.
E. You want to ensure that all security requirements are met using the least amount of administrative effort.
F. What should you do?
G. Allow the Accounting groupReadpermission on the Accounting share and the Legal shared folder. Allow the Legal groupReadpermissions on the Legal shared folder.
H. Allow the Accounting groupFull Controlpermissions on the Accounting shared folder and the Legal shared folder. Allow the Legal groupFull Controlpermission on the Legal shared folder.
I. Deny the Everyone groupFull Controlpermissions on the Accounting shared folder.
J. Deny the Legal groupFull Controlpermission on the Accounting shared folder.
5. [单选题]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.
A. While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
B. You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?
C. Configure SQLAgentMail to use a valid MAPI profile
D. Configure SQL Mail to use a mailbox that delegates permissions to the operator
E. Use the net send notification method to send the operator e-mail messages
F. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts
