You have a SharePoint solution that contains a custom site column and a custom content type.

You need to add the custom site column as a lookup field for the custom content type.

What should you create?

You create a Web Part that updates a list.

You need to ensure that users can use the Web Part to update the list, regardless of the users’ permissions to the list.

What should you use in the Web Part?

You need to create a custom Web Part that meets the following requirements:

* Includes all of the functionalities of the Search Results Web Part
* Includes additional filters based on the current user department

What should you do?

You create a SharePoint site by using the Document Center site template.

You need to ensure that all documents added to the site have a document ID. The document ID must include the date that the document was added to the site.

What should you do?

You need to delete the previous versions of all documents in a document library.

The deleted versions of the documents must be retained in the SharePoint Recycle Bin.

What should you do?

You need to create a Microsoft .NET Framework console application that queries a list by using the SharePoint client object model.

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

You create two custom lists named Offices and Rooms.

Rooms has the following columns:

* Title
* Capacity
* Equipment

Offices has the following columns:

* Title
* Rooms (a lookup to the Title column in the Rooms list)
* Rooms: Capacity
* Rooms: Equipment

You need to perform a Representational State Transfer (REST) query that returns a list of all the offices that have rooms with a capacity of 10. The query results must include the room titles and the equipment in each room.

Which URL should you choose?

You create a custom list named Products.

You need to perform a Representational State Transfer (REST) query that returns the first product in the list.

Which URL should you use?

You create a custom list named Products.

You need to perform a Representational State Transfer (REST) query that returns products 30 to 39.

Which URL should you use?

You are creating an application for SharePoint Server 2010.

The application will run on a remote computer.

You need to identify a data access method to query lists in the application.

Strongly-typed access to columns must be provided from within Microsoft Visual Studio 2010.

Which method should you use?