You are creating two user-defined functions (UDFs) of Excel Services in Microsoft Office SharePoint Server 2007.

You write the following code segment.

public class Class1
{
public double MyDouble (double d)
{
return d * 9;
}
public DateTime ReturnDateTimeToday ()
{
return ( DateTime.Today );
}
}

You need to ensure that the MyDouble method and the ReturnDateTimeToday method are recognized as UDFs of Excel Services. What should you do?

You are designing a Microsoft Office SharePoint Server 2007 solution. A Microsoft SQL Server 2005 Analysis Services cube stores key performance indicators (KPIs). You need to display details of a KPI in a Web Part. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You create a service center site for a SharePoint portal. You need to display a new column named “Completion Date” on a Search Core Results Web Part.

Which two steps should you perform? (Each answer represents part of the solution, select two)

You need to activate a Microsoft Office 2007 form template named SalesTemplate in a site collection. You write the following code segment:

01: Dim siteColl As New SPSite(“http://companysite”)
02: Dim services As SPServiceCollection = SPFarm.Local.Services
03: For Each service As SPService in services
04: Dim formService As FormService = DirectCast(service, formService)
05:
06: Next

Which code segment should you add at line 05?

You create a SharePoint Server 2007 application. The application contains a user named UserA. You need to write a code segment to add the user to the user profile store.

Which code segment should you use?

You have a web part that contains the following code segment:

01: Using site as New SPSite(“http://internet”)
02: Dim context as ServerContext = ServerContext.GetContext(site)
03: Dim profileManager as New UserProfileManager(context)
04: Dim changeQuery as New UserProfileChangeQuery()
05: changeQuery.ChangeTokenStart = New
UserProfileChangeToken(DateTimeStamp.UTCNow.Subtract(TimeSpan.FromDays(10)))
06: …
07: End Using

You need to retrieve all of the department changes for your colleagues’ profiles for the last 10 days.

Which line of code should you insert at line 6?

You create an audience named Sales. You need to create a custom web part that displays a control to members of the Sales audience only.

Which code segment should you use?

You have a Microsoft Office SharePoint 2007 Server farm. You have a security policy in your companies programs that uses Single SignOn. You are creating a BDC application definition for an external business application on a SharePoint 2007 server. The external business application is accessed through a web service. The server and the business application are on different computers. Kerbrose delegation is not enabled on the domain. You need to define a line of business (LOB) systems for the external business application in the BDC application file.

Which authentication method should you specify?

You have a Publishing site. You customize the default edit page toolbar. You need to add a new button to the toolbar.

Which class should you implement?

You create a Microsoft WinForms application that allows you to search within a Microsoft Office SharePoint Server 2007 site collection.

You write the following code segment.

SPSSearchWS.QueryService searchWS = new
SPSSearchWS.QueryService();
string query = “My_Query”;

You need to bind a DataGridView control directly to a query result set.

Which code segment should you use?