MCSE-Microsoft Certified Solutions Expert Questions

You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?

What protocol is required by Internet Information Services(IIS), the indexing Service, and Certificate Services?

Which authentication method provides the highest level of security?

For most large companies, in terms of ease of network administration, what is the optimum number of Active Directory domains to use on their Windows 2000 network?

Which Event Viewer log can you use to view the results of auditing?

You want to configure a static IP address on a Windows 2000 Server  computer on which you want to install the DNS Server service and Active Directory. What tool should you use to configure the static IP address?

You want to add an additional paging file to your Windows 2000 Server computer. Which tool should you use?