Microsoft-PRO Designing and Developing Microsoft SharePoint 2010 Applications Set 1

You are helping an organization's executive team to design an automated approval process to standardize certain documents. You have the following requirements: The documents must be reviewed and approved by multiple teams in the approval chain. Each reviewer must provide feedback as part of completing a review. Each reviewer must either approve or reject the documents. After review, the document status must be changed; an e-mail must be generated to the document author and the next reviewer in the approval chain; and a task should be created for the next reviewer in the approval chain. You must design a custom workflow solution for the document approval process on a SharePoint 2010 site. What should the solution include?

You are designing a SharePoint 2010 feature. The feature includes a feature receiver that executes code on activation and deactivation. The feature receiver code interacts with a Web Service, which could cause errors beyond your control. You need to ensure that the feature does not activate or deactivate if the Web Service causes an error. Which approach should you recommend?

You are designing a SharePoint 2010 information architecture plan for a client that specifies the mechanics of implementing content type change control. The requirements for the change control plan specify that: Site managers can create site-specific content types based on the content types in the parent site. Content types must not be overwritten when changes are made to parent site content types. Site managers can change child site content types. You need to specify a content type change control plan that meets all these requirements. Which approach should you recommend?

You are designing a SharePoint 2010 application to store 50 GB of digital assets, including audio and video files that are up to 20 MB in size. You have the following requirements: The disk storage system must use standard hard drives and must be configured to optimize read performance. The SharePoint 2010 database uses Microsoft SQL Server Express 2008. The application must leverage standard SharePoint 2010 components to limit the requirement for custom development. You need to design a storage solution that meets all of these requirements. Which approach should you recommend?

You are designing a SharePoint 2010 application that stores information about each machine in a factory. This information includes an inventory of parts, the machine's maintenance history, and a document library of repair manuals for each machine in Microsoft Word format. The application must: Establish links between the factory machine data, the machine part inventory, the maintenance history, and the repair manuals to allow the display of additional fields from the other lists. Enforce relational integrity between the data to create custom views for various business users. Allow non-technical users to update the individual list data and views, as well as to update the manuals. Enforce relationships that allow cascade deletes of items from the machine parts list when items are deleted from the machine list, but prevent data in the machine parts list from being orphaned. You need to design a data access plan that meets all these requirements and allows all data to be managed within the SharePoint 2010 system. Which plan should you recommend?

You are designing a SharePoint 2010 solution that allows users to enter address information for contacts into a list named Address. You have the following requirements: Ensure that users enter full nine-digit zip codes for the address information. Display a custom message indicating that a zip code is invalid if the entered zip code does not match the full nine-digit requirements. You need to ensure that the application is designed to meet these requirements. Which approach should you recommend?

You are designing a SharePoint 2010 solution that stores employee information in a list named Employees and company information in a list named Company. Each company has one or more employees. You need to recommend that a developer add a new column so that a one-to-many relationship is created between the Company list and Employees list. Which approach should you recommend?

You are using Business Connectivity Services to design a SharePoint 2010 application that connects to an external database. The database users have accounts for authentication that are different from their Active Directory accounts. You have a requirement to allow users to connect to the external database without prompting the user for credentials. You need to store user credentials and use these credentials when connecting to the external database. Which approach should you recommend?

You are designing an external binary large object (BLOB) store provider by implementing the ISP External Binary Provider interface. The farm has existing sites that contain content. Your implementation has been verified to be working correctly. You need to ensure that content within existing sites is moved using the external BLOB store provider. You also must ensure that the solution does not require further custom coding. Which approach should you recommend?

You are designing a SharePoint 2010 application that includes a Task list. You have the following requirements: For each task, allow users to specify one of three values for an item named Phase using a drop-down menu. Allow contributors to add new values for the Phase item. You need to design this application without using custom code. Which approach should you recommend?