Your companys sales database has two related tables named Customer and SalesOrders.

You define two entities named Customer and SalesOrders in a Business Data Catalog (BDC) definition.

The metadata for the BDC definition contains the following XML fragment. (Line numbers are included for reference only.)

01 <Associations>
02 <Association>
03 <
04 Association
05 AssociationMethodEntityName=”Customer”
06 AssociationMethodName=”GetSalesOrdersForCustomer”
07 AssociationMethodReturnParameterName=”SalesOrders”

08 Name=”CustomerToSalesOrder”
09 IsCached=”true”
10 >
11 …

12 </Association>
13 </Associations>

You need to maintain the relationship between the entities.

Which XML fragment should you insert at line 11?

You create a Microsoft Office SharePoint Server 2007 site. The site contains a form library. A Microsoft Office InfoPath form from the form library must be converted to a Web page by using an existing InfoPath form converter. When you select the existing form converter, you receive a conversion error. You need to ensure that the document is converted without errors. What should you do?

You need to display the contents of a SharePoint list named “Assets” in a Microsoft Office Excel spreadsheet and then publish the spreadsheet to Excel Services.

What should you do?

You create a search center site for your Microsoft Office SharePoint Server 2007 portal. You need to display a new column named CompletionDate on a Search Core Results Web Part. Which two steps should you perform? (Each correct answer presents part of the solution. Choose two.)

You company uses an ASP.Net web site. You create a Microsoft Office InfoPath form named myForm. You are created a custom control that is derived from the XMLFormView class. The custom control will display myForm within the ASP.Net page on the web site. You need to ensure that myForm will be displayed within the ASP.Net page on the web site.

What should you do?

You have an external application defined in the BDC. The application definition contains an entity named Customers that comes from a table in a Microsoft SQL Server database. The table has a column that contains the customer name. You need to ensure that users can perform key word searches for data in the customer name field.

What should you create in the application definition file?

You have Microsoft Office SharePoint 2007 Server farm that has a Single Sign-On implementation. You plan to deploy a web part that will access data through a web service. The web service and the web part are in different web applications. The web service uses a custom authentication provider.

To ensure that users are not prompted to enter credentials when they access the web part, what should you do?

You need to create a web part that displays all users whose anniversaries are equal to the current date.

Which class of Microsoft Office Server profiles namespace should you use?

You plan to use a console application that accepts the login name as an argument and returns the first name of the user.
You write the code segment for the console application:

01: Dim profileServices as New UserProfile = ProfileServices() profileServices.UseDefaultCredentials = True
02: Dim userProps as UserProfile.PropertyInfo() =
profileServices.GetUserProfileSingle()
03: …
04: For Each currentProp as Object in userProps
05: If Direct Cast(currentProp, UserProfile.PropertyData).Name = “FirstName” Then
06: Console.WriteLine(Direct Cast(currentProp,
UserProfile.ProperData).Values(0).Value)
07: End If
08: Next

You need to pre-fill the userProps variable in line 4 to ensure the first name is returned.

Which method should you use at line 3?

You have a Line of Business application defined in a business data catalog. You create a web part to browse the data of the LOB application. You have the following query to interact with the LOB application and the web part:

01: Dim lobSystem As LOBSystem = ApplicationInRegistry.GetLOBSystem()(“lob1”)
02: Dim lobSystemInstance As LOBSystemInstance =
lobSystem.GetLOBSystemInstance()(“lob1Instance”)
03: Dim ent1Entity As Entity = lobSystem.GetEntities()(“DBOEntities”)
04: Dim fc As FilterCollection = ent1Entity.GetFinderFilters()
05:

You need to render the results of the query and the web part.

Which code segment should you add to line 5?