You create a Microsoft Office SharePoint Server 2007 site. The site is configured to use a Shared Services Provider (SSP) that manages user profiles. The user profiles contain user contact information. You need to retrieve the telephone number of a user. What should you do?

Your company uses an ASP.NET Web site. You create a Microsoft Office
InfoPath form named MyForm. You are creating a custom control that is derived from the
XMLFormView class. The custom control will display MyForm within an ASP.NET page on the Web
site. You need to ensure that MyForm can be displayed within an ASP.NET page on the Web site.

What should you do?

You create a Microsoft Office InfoPath workflow task form for users. The form contains all the details of each task. You need to store the value of the Comments field in a variable named UserInput when each user submits the form. Which code segment should you use?

Your company stores employee details in a Microsoft SQL Server database.

You are creating a Report Center site on a Microsoft Office SharePoint Server 2007 server. You need to ensure that a report on employee details can be generated in the Report Center site. What should you do?

You are developing a Microsoft Office SharePoint Server 2007 solution that integrates with Microsoft SQL Server 2005 Reporting Services. You need to configure the SharePoint solution to allow storage of reports in SharePoint document libraries. What should you do?

You implement a custom function as a user-defined function (UDF) in Excel Services in Microsoft Office SharePoint Server 2007. A Microsoft Office Excel 2007 workbook uses the custom function to generate a random number between 100 and 500. You need to generate a new random number each time you load the workbook. Which code segment should you use?

You have a document library that contains .docx documents. You need to create a web part that allows users with the ability to convert documents to .aspx pages by using the default document converter. You write the following code segment:

01: Public Sub ConvertFileOpen(ByVal file as SPFile)
02: Dim pubWeb as PublishingWeb =
PublishingWeb.GetPublishingWeb(SPContext.Current.Web)
03: Dim pages as PublishingWebCollection = pubWeb.GetPublishingPages()
04: Dim title[String] = GUID.NewGUID().toString() & “.aspx”
05: Dim converterID as new GUID(“1234………7890”)
06:
07: End Sub

Which code segment should you add at line 6?

Your organization has a department named product testing. You are creating a new membership named ProductTesting. You are adding a distribution list to the new membership. You need to ensure that the membership is displayed only to managers.

What should you do?

Your company stores product information in a SQL Server 2005 database. You create a BDC definition to search for product information within the database. You need to ensure that incremental crawls can be performed in the database for indexing.

What should you do?

You have a Records Center site. You need to create a custom file plan for documents based on their content type.

What should you do?