You create a Microsoft Office SharePoint Server 2007 site. A document library named CompanyWorkbooks on the site contains Microsoft Office Excel workbooks. You need to ensure that users can access the workbooks in the CompanyWorkbooks document library by using Excel Services in Microsoft Office SharePoint Server 2007. What should you do?

You are creating a Microsoft Office SharePoint Server 2007 application that uses the Search service. You need to ensure that the search results are based on an existing keyword.

Which code segment should you use?

You are creating a Microsoft Office SharePoint Server 2007 site. A document library contains documents on new products. The documents must contain a label that denotes the product status. You need to add a label to all documents in the library. What should you do?

You create a Microsoft Office SharePoint Server 2007 portal site. The site contains a document retention policy for request for proposal (RFP) documents. You need to customize the policy to ensure that a notification is sent to each project manager when the RFP date expires. What should you do?

You are creating a Microsoft Office SharePoint Server 2007 application. The
application reads data from the Microsoft Office Excel 2007 workbook named SalesGoals.xls.

SalesGoals.xls is located in a document library. The first sheet of the SalesGoals.xls workbook contains
the following information.

You need to retrieve the values for 2008 from within your application.

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

You create a custom field type and a corresponding custom field control. You need to ensure that the field type is available to users when they create list columns.

What should you do?

You have an external line of business application. The LOB application data is exposed to a web service. You plan to use the BDC catalog to access the LOB application. You create the following type descriptor for the data row in the BDC application file:

<TypeDescriptor TypeName=”System.String” Name=”LastName” />

You attempt to import the application definition file to the BDC and receive the following error:

“Could not create profile page for entity filtered contact. The error is profile page creation for the entity filtered contact skipped. Entity filtered contact has no identifiers defined in the specific finder view.”

You need to ensure that you can import the application definition file to the BDC.

What should you do?

You create a Microsoft Office SharePoint Server 2007 site. You also create a BDC definition. The BDC definition accesses a product database that is stored on a SQL Server 2005 server. You need to ensure that users can filter the product data by the product type field from within the SharePoint server.

What should you do?

You are designing a MOSS 2007 solution. You need to implement a Single Sign-On (SSO) provider to access a Business Data Catalog (BDC).

What should you do?

You plan to create an application definition file for a SQL Server database. You need to distribute the credentials used to connect the SharePoint site that are also used to connect to the SQL Server database.

Which authentication method should you specify in the application definition file?