Most IT Boot Camps In America - MCTS: Office SharePoint Server 2007

Username Password
Lost your Password?
No account yet? Register

MCTS: Office SharePoint Server 2007 - Application Development

Preparation Guide for Exam 70-542

TS: Microsoft Office SharePoint Server 2007 - Application Development

Exam News

The Technology Specialist (TS) Exam 70-542: TS: Microsoft Office SharePoint Server 2007 - Application Development was released in March 2007.

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)

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

Credit Toward Certification

When you pass this exam, you earn credit toward the following certifications: MCTS: Microsoft Office SharePoint Server 2007: Application Development.

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

Preparation Tools and Resources

We make a wealth of preparation tools and resources available to you, including courses, books, practice tests, and Microsoft Web sites. When you are ready to prepare for this exam, here's where you should start.

Microsoft certified practice tests

•	MeasureUp: Visit the MeasureUp Web site to take a practice test.
•	Self Test Software: Visit the Self Test Software Web site to take a practice test.

Microsoft Online Resources

•	MSDN: The Microsoft Developer Network (MSDN) is a reference for developers that features code samples, technical articles, newsgroups, chats, and more.
•	Training and certification newsgroups: A newsgroup exists for every Microsoft certification. By participating in the ongoing dialogue, you take advantage of a unique opportunity to exchange ideas with and ask questions of others, including more than 750 Microsoft Most Valuable Professionals (MVPs) worldwide.

Skills Being Measured

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

Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which Microsoft Official Curriculum courses may 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.