You create a Microsoft Office SharePoint Server 2007 site.

You are creating a custom field control that displays a video.

The custom field must perform the following tasks:

Render the control properly when the page is in display mode.

Enable a user to select an appropriate video for display when the page is in edit mode.

You need to ensure that the custom field meets the outlined requirements.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You have two Microsoft Offce SharePoint Server 2007 site collections named Staging and Production. The Staging site collection runs on Server A. The Production site collection runs on Server B.

Server A and Server B are located on separate networks.

You need to write a script that replicates content from the Staging site collection to the Production site collection.

What should you do? (To answer, move the appropriate three actons from the list of actions to the answer area and arrange them in the correct order.)

You are creating a Microsoft Office SharePoint Server 2007 site.

The site has five audiences. A user might belong to more than one of the five audiences.

You need to obtain a list of audience names for the current user.

Which code segment should you use?

Your company uses an order management application that stores order information in a Microsoft SQL Server 2005 database. You are creating a Business Data Catalog (BDC) definition on a Microsoft Office SharePoint Server 2007 server. You need to ensure that the SharePoint server can index the order information. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You create a Microsoft Office SharePoint Server 2007 site. You also create a Business Data Catalog (BDC) definition. The BDC definition accesses a product database that is stored on a Microsoft SQL Server 2005 server. You need to ensure that users can filter the product data by the ProductType field from within the SharePoint server. What should you do?

Your organization has a department named product testing. You are creating a new membership named Product Testing. 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?

You are designing a Microsoft Office SharePoint Server 2007 solution. You need to implement a Single Sign On (SSO) provider to access a Business Data Catalog (BDC). What should you do?

You have a database that contains a table named Customers and a table named Orders. The Orders table contains a CustomerID foreign key. You need to create an association between the Customers entity and the Orders entity in the BDC.

What should you do?

You create a Windows Form application that accesses Excel web services and displays workbook data on the form by using the GetWorkbook method. You need to identify the items that the workbook author selected as viewable when he saved the workbook.

Which parameter should you pass to the GetWorkbook method?

You create an application that contains the following code:

01: Using site As New SPSite(“http://contoso.com”)
02: Dim sQuery As New KeywordQuery(site)
03: sQuery.QueryText = String.Format(“prop1:””open~0~”””,”value1″)
04:
05: sQuery.ResultType = ResultType.RelevantResults
06: Dim queryResults As QueryTableCollection = sQuery.Execute()
07: Dim queryResultsTable As ResultTable =
queryResults(ResultType.RelevantResults)
08: Dim queryDataTable As New DataTable()
09: queryDataTable.Load(queryResultsTable, LoadOption.OverwriteChanges)
10: End Using

The application performs a keyword query search on a managed property named Prop1 with a value of Value1. You need to ensure that the search result returns a managed property named Prop2.

Which line of code should you add at 04?