You are creating a Microsoft Office SharePoint Server 2007 Report Center Web site. Your company stores product data in a Microsoft SQL Server 2005 database named Product Management. You need to ensure that the product data is available for use in Microsoft Office Excel 2007 reports. What should you do?

You plan to create a custom application that automatically creates key word best bets.

You write the following code:

01: Dim site As New SPSite(“http://internet”)
02: Dim searchContext_1 as SearchContext = SearchContext.getContext(site)
03: Dim keyWords as new KeyWord(searchContext_1, newURI(“http://internet”))
04: Dim currentKeyWord as keyWords = KeyWords.AllKeywords.Create(“AKeyWord”, DateTime.Now)
05:

You need to add a best bet to the current keyword. Which code segment should you use on line 5?

You have an audience for the Marketing Department. You plan to target all web parts on the default.aspx web page to the Marketing Department. You write the following code segment.

01: Using wpm as SPLimitedWebPartManager = objSite.GetLimitedWebPartManager (“default.aspx”, System.Web.UI.WebControls.WebPart.PersonalizationScope.[Shared])
02: Dim AM as New AudienceManager(ServerContext.Current)
03: For Each currentWP as WebPart in wpm.WebParts
04: currentWP.AuthorizationFilter = String.Format
(“~0~”,AM.GetAudiences(“Marketing”).AudienceID)
05:
06: Next
07:
08: End Using

You notice that all users still have access to the web parts on the default.aspx web page. You need to ensure that only users in the Marketing Audience can see the web part on default.aspx.

What should you do?

Your company uses an older application management system that stores information on a Microsoft SQLServer 2005 database. You are creating a Business Data Catalog definition on a Microsoft Office SharePoint Server 2007 server. You need to ensure that the SharePoint server can index order information.

Which two action should you perform? (Each answer represents part of the solution, choose two.)

A. Define a Finder method in the BDC definition
B. Define an IDEnumerator method in the BDC definition
C. Define a ViewAccessors method in the BDC definition
D. Define a SpecificFinder method in the BDC definition

You have a Microsoft Office SharePoint Server 2007 server that contains an application definition file. You modify the file. You attempt to upload the modified file by using the Shared Service Provider. The upload fails. You need to ensure the modified file by using the Shared Service Provider.

What should you do?

You are deploying a Microsoft Office SharePoint Server 2007 hierarch of sites from a development environment to a staging environment on the same server farm. The development site hierarchy contains a corporate intranet site and a departmental site. Each departmental site contains subsites. You need to re-create the hierarchy of the development sites in the staging environment.

What should you do?

You create an audience that meets the following requirements:

Contains all users that have:

The Title property set to Administrator
The Manager property set to <sitename>/Administrator
The IsAdministrator Property set to True

Which Audience object constructor should you call?

You manage a SharePoint 2007 Server site that contains a site group named HR. You create an audience that consists of members of the HR group. The HR group does not have design permission levels on the web part gallery of the site. You need to target a list item to HR employees.

What should you modify?

You have a web part named Web1. Web1 modifies the content of a published Microsoft Office Excel workbook by using Excel web services. You need to open a new Excel Calculation Service session in Web1.

Which method should you use?

You create an audience by using the SharePoint Object Model. You need to ensure that the audience is compiled.

Which method should you use?