Exams > Search for an Exam

Preparation Guide for Exam 70-542

TS: Microsoft Office SharePoint Server 2007 – Application Development

Updated: April 30, 2008
Related Links
•Register for this exam
•Take a practice test
•Join an MCP newsgroup
•Find a course
•Buy a Microsoft Press book
On This Page
Exam newsExam news
Exam topics coveredExam topics covered
Audience profileAudience profile
Credit toward certificationCredit toward certification
Code languagesCode languages
Preparation tools and resourcesPreparation tools and resources
Skills measuredSkills measured

Exam news

The Technology Specialist (TS) Exam 70-542: TS: Microsoft Office SharePoint Server 2007 – Application Development was released in March 2007. This exam is available in English, Chinese [Simplified], French, German, Japanese, and Spanish.

Top of pageTop of page

Exam topics covered

The following list includes the topic areas covered on this exam. The percentage indicates the portion of the exam that addresses a particular skill.

•

Managing Enterprise Content (15 percent)

•

Creating Business Intelligence Solutions by Using Office SharePoint Server 2007 (15 percent)

•

Integrating Business Data with Office SharePoint Server 2007 by Using the Business Data Catalog (BDC) (15 percent)

•

Accessing Office SharePoint Server Application Platform Services (14 percent)

•

Searching Data by Using the Search Service (17 percent)

•

Targeting Content Based on Audience Membership (13 percent)

•

Customizing Functionality by Using Profiles (11 percent)

Top of pageTop of page

Audience profile

Candidates for this exam are consultants who provide consulting services for Microsoft Office SharePoint Server 2007 and corporate developers who use Microsoft Office SharePoint Server 2007. Candidates have the following experience or knowledge:

•

Six months to one year of experience developing applications by using Microsoft Office SharePoint Server 2007

•

Experience using the following related technologies:

1.

The Microsoft .NET Framework at least six months with ASP.NET 2.0)

2.

Windows SharePoint Services development (six months to one year)

•

Experience working with XML documents

•

Experience with XML Web services development and consumption

•

Working knowledge of Windows WorkFlow Foundation

•

Working knowledge of IIS 6

Top of pageTop of page

Credit toward certification

When you pass this exam, you earn credit toward the following certification:

•MCTS: Microsoft Office SharePoint Server 2007: Application Development
Top of pageTop of page

Code languages

When the exam begins, you can choose the programming language in which the code segments will appear. The available code languages for this exam are:

•

Microsoft Visual Basic 2005

•

Microsoft Visual C# 2005

Top of pageTop of page

Preparation tools and resources

To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills measured" section.

Classroom trainingMicrosoft E-LearningMicrosoft Press booksPractice tests

There is no classroom training currently available.

Collection 6071: Visual Studio 2008 Connected Systems: Windows Workflow Foundation (12 hours) (Available May 2008)

There are no Microsoft Press products currently available.

MeasureUp (Measureup.com)

Self Test Software (Selftestsoftware.com)

Microsoft online resources

•

Learning Plan: Get started by creating a step-by-step study guide that is based on recommended resources for this exam.

•

Microsoft Learning Community: Join newsgroups and visit community forums to connect with peers for suggestions on training resources and advice on your certification path and studies.

•

TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, and technical resources.

•

MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats.

Top of pageTop of page

Skills measured

This certification exam measures your ability to build Web portals and integrate business applications by using Microsoft Office SharePoint Server 2007.

Before taking the exam, you should be proficient in the job skills listed in the following table. The table lists Official Microsoft Learning Products that can help you reach competency in the skills being tested in the exam.

Skills measured by Exam 70-542
Managing Enterprise Content

Enforce document storage business rules by using Document Policy.

•

Create a custom document policy.

•

Deploy a document policy by using a policy feature.

•

Specify logic for a document policy by using a policy resource.

•

Manage document retention rules by using the expiration feature policy.

•

Launch a workflow when a document expires.

Audit Windows SharePoint Services content by using a custom policy.

Manage records by using Office SharePoint Server 2007 record management features.

•

Create a custom file plan.

•

Create a custom audit report.

•

Create a custom file submission.

•

Create a custom legal hold.

Create content by using the Office SharePoint Server 2007 Web content management features.

•

Extend the Page Authoring toolbar.

•

Create pages dynamically.

•

Modify page layout by using content placeholders.

•

Create a custom field control.

•

Localize a site by using resource lists.

Deploy content between servers.

Provide variations of Web content.

•

Redirect a user to a variation based on profile settings.

•

Launch a workflow when an event occurs in a primary variation.

Provision multiple sites in a hierarchy.

Creating Business Intelligence Solutions by Using Office SharePoint Server 2007

Display data from a Microsoft Excel workbook by using Excel Services.

Create a trusted workbook location by using the Stsadm.exe command-line tool.

Implement business logic by using an Excel Services user-defined function.

•

Process enterprise data from a Windows SharePoint Services list.

•

Troubleshoot a user-defined function.

Filter data in a workbook by using Excel Services.

Provide parameters to a Report Viewer Web Part from a custom Web Part.

Expose a data source by adding a data connection to a Report Center Web Site.

Create a key performance indicator (KPI) Web Part by using data from a report data source.

Integrating Business Data with Office SharePoint Server 2007 by Using the Business Data Catalog (BDC)

Create a BDC Application Definition.

•

Create a line of business (LOB) system.

Describe an external application in the BDC Application Definition.

•

Create an LOB system instance.

•

Create an entity.

Display data from an external data source.

•

Create a Finder method.

Enable indexing of data stored in an external data source.

•

Create an IDEnumerator.

Enable searching on a BDC Application Definition.

•

Enable a single item query by creating identifiers for entities.

•

Enable a single item query by creating a SpecificFinder method.

•

Add input and output parameters to a SpecificFinder method.

•

Create a filter descriptor.

Create a custom action on an entity.

Create an association between two entities.

Create a Web Part to browse data.

•

Return an LOB system instance.

•

Return an entity.

•

Execute a finder on an entity.

•

Execute a method on an entity.

•

Execute a SpecificFinder on an entity.

•

Execute a wildcard filter on an entity.

Accessing Office SharePoint Server 2007 Application Platform Services

Process InfoPath data from within a workflow.

Display an InfoPath Form from within an ASP.NET page by using the Form Services control.

Automate Office Forms Server administration tasks.

•

Activate a previously uploaded form template.

Manage credentials by using the single sign-on (SSO) credential store.

•

Create a custom SSO provider for use by the BDC.

•

Apply credentials to a Web service call by using SSO.

Convert documents by using the document converter.

•

Convert a document from a document library by using an existing document converter.

•

Increase the priority of a document in the conversion process.

•

Transform a custom document format into another format.

•

Publish a page by using the document converter.

Display a user profile retrieved from an Office SharePoint Server 2007 Web service.

Searching Data by Using the Search Service

Programmatically enhance the search service.

•

Access the search context for the Shared Services Provider (SSP).

•

Associate a search term by creating a Best Bet.

Add a custom search page for searching the BDC.

•

Extend the user interface by adding a tab to the search page.

Provide custom search capabilities by creating an enterprise search Web Part.

Customize the display of search results by modifying the Search Core Results XSLT.

Display results from a Windows SharePoint Services search Web service.

Display the results of a keyword query.

Targeting Content Based on Audience Membership

Create an audience.

Specify conditions for audience membership by using rules.

Target a list item to an audience.

Target a Web Part to an audience by using filters.

Display all audiences to which a user belongs.

Display all users in a given audience.

Customizing Functionality by Using Profiles

Import users into the user profile store from an LDAP store.

Create a profile in the user profile store.

Manipulate profile properties.

•

Add a profile property to the user profile store.

•

Store a user's attributes in the user profile store by creating a multivalue property.

•

Retrieve a specific property from a user profile.

•

Map a BDC data item to a user profile property.

•

Set the privacy policy for a user profile property.

Display all colleagues for a given user.

Add a distribution list to a new membership.

Display results from the user profile change log.

Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

•Learn more and download samples

Top of pageTop of page