Exam 70-542:

TS: Microsoft Office SharePoint Server 2007 - Application Development

Published:March 26, 2007
Language(s):English, French, German, Japanese, Spanish, Chinese (Simplified)
Technology:Microsoft Office SharePoint Server 2007
Type:Proctored Exam

How To Get It: Schedule your exam through the following exam provider:

Take exam

Preparing for an Exam
This exam is scheduled to retire on January 31, 2013.
The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam. Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration ,preparation ,scoring ,and policies , including:
  • The most effective way to prepare to take an exam.
  • The relationship between Microsoft training materials and exam content.
  • Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
  • Exam question types and formats.
  • Exam time limits and number of questions asked.
We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.
Exam Topics Covered
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
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:
    • The Microsoft .NET Framework at least six months with ASP.NET 2.0)
    • 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
Credit Toward CertificationExam 70-542: TS: Microsoft Office SharePoint Server 2007 - Application Development: counts as credit toward the following certification(s):
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.
Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.The higher the percentage, the more questions you are likely to see on that content area on the exam.

The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.
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.
Preparation Tools and ResourcesTo 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" tab.
Learning Plans and Classroom Training
Microsoft E-Learning
Microsoft Press Books There are no Microsoft Press books currently available.
Practice Tests
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 as a reference for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, newsgroups, chats, and more.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site: