Microsoft Certification Questions

You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01.

The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication.

You want to add a page to your ASP.NET application to display inventory data from  FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?

You create an ASP.NET page that uses images to identify areas where a user can click to initiate actions. The users of the application use Internet Explorer.

You want to provide a pop-up window when the user moves the mouse pointer over an image. You want the pop-up window to display text that identifies the action that will be taken if the user clicks the image.

What should you do?

You are creating a new Word 2010 document which contains scientific information including formulas. One particular algebra formula contains the notation n squared plus 10. Which formatting style would help you represent the n squared part of the formula?

You want to monitor and configure your organization's removable media, including a tape library and optical discs. Which Windows 2000 tool can you use to do this?

You develop a Windows-based application that enables to enter product sales. You add a subroutine named XYZ.

You discover that XYZ sometimes raises an IOException during execution. To address this problem you create two additional subroutines named LogError and CleanUp. These subroutines are governed by the following rules:

• LogError must be called only when XYZ raises an exception.
• CleanUp must be called whenever XYZ is complete.

 You must ensure that your application adheres to these rules. Which code segment should you use?

Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). On a file server, you have a shared folder named Data. The Data folder has the permissions shown in the following table:

You need to ensure that members of a group named Sales can modify content in the Data share. Sales group members must only be allowed to delete files that they create. Which additional permission should you assign to the Sales group?

You are planning to install and configure network services for ineroperability on your Windows 2000 Server computer. You specifically want this server to maintain and advertise a list of services that use the NWLink IPX/SPX/NetBIOS Compatible Transport Protocol. What service should you install?

Someone has created a new document using Word 2010 and sent you a copy. The document is not protected and you have rights to view the content and even make changes. However, they have inserted a hyperlink to a company website but when you click the hyperlink nothing happens. What might be wrong?