I have questions for you but I have only one suggestion for you ------ No need for anything just go for www.examcheets.com study material.

Try my questions too. 70-228.

1:- You are the administrator of a SQL Server 2000 computer. You configure a set of alerts on the server to notify you whenever certain operations fail or encounter errors. The notifications are sent to your Microsoft Windows 2000 Professional computer by using the net send command. You successfully test the alerts. After several days, however, you stop receiving notifications when operations fail or encounter an error. You verify that the SQL Server Agent service is started. You need to make sure that you continue to receive alert notifications. What should you do?

A.   Stop and restart the SQL Server Agent service.

B.   Clear the application log on the SQL server computer.

C.   Clear the system log on your Windows 2000 Professional computer.

D.   Install the SQL Server 2000 administrative tools on your Windows 2000 Professional computer.

Answer: B.

2:- You are the administrator of a SQL Server 2000 computer. The server is a member of a Windows NT domain and is configured for Windows authentication. The server contains a database that stores contact information for public officials in your region. These officials need to access the database by means of the Internet by using the guest login. However, some users report that they cannot connect to the server by means of the Internet. You need to allow anyone access to the server by means of the Internet. What should you do?

A.   Assign the guest login a blank password.

B.   Delete the guest login and create a new login that is mapped to the guest domain user account.

C.   Create a database user named Anonymous and assign the user the appropriate database permissions.

D.   Configure the server for mixed mode authentication.

Answer: D.

3:- You are the administrator of two SQL Server 2000 computers. Each server contains data for one of your company's two regional divisions. Company employees currently use a single data entry application on client computers.

After the new application is installed, query response times slow. You want to monitor server traffic during business hours to help diagnose this problem.

What should you do?

A.   Run SQL Profiler, and create one trace to monitor both servers. Configure the trace to include data from the new data entry application only.

B.   Run two instances of SQL Profiler, and create a trace to monitor each server. Configure the trace to include data from both data entry applications.

C.   Run the sqldiag utility from a command prompt. Write diagnostic data to a text file.

D.   Execute the sp_monitor stored procedure. Save the output to a text file.

Answer: D.

4:- You are the administrator of a new SQL Server 2000 computer. Your company has client computers that are running Microsoft Windows 2000 Professional. All client computers require access to the server.

According to company policy, passwords must be at least eight characters long and change every 30 days. You need to implement these policies and allow client computers to connect. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A.   Configure Mixed Mode authentication.

B.   Configure Windows Authentication.

C.   Create a SQL Server login for each user who will access the server.

D.   Create a login for the Domain Users group.

E.   Set the Windows 2000 domain policy for password expiration to 30 days.

F.   Set the Windows 2000 domain policy to require a password length of at least 8 characters.

Answer: B, D, E, F.