You are designing an asset management solution using SharePoint 2010. You need to
design a solution that meets the following requirements: ·Binary large objects (BLOBs)
cannot be stored in Microsoft SQL Server. .There can be no custom development or
third-party products. Which approach should you recommend?

You need to specify the correct artifacts to use in a SharePoint 2010 application for a school
district. The school district’s administrator needs to be able to search for student information
on an intranet SharePoint 2010 portal. Student information is currently available in another
database, which supports an Open Database Connectivity (ODBC) driver. You need to
design the solution to meet the following requirements: ·Provide a user interface to search
for a student based on name. .Enable the administrator to select the correct student name
from the search results. .Provide a student header section that displays the primary student
identity information, which will enable the administrator to correlate any new information with
the correct student. .Provide additional data entry pages to add or update additional student
information. Which approach should you recommend?

You are designing a SharePoint 2010 site. You need to design the site to meet all the
following requirements: ·Your business requires a consistent structure to manage sales
proposal documents across all account teams. .The sales director must ensure that all sales
documents conform to the same template. .All sales proposals must be reviewed and
approved by the sales manager. .Every site must be created with a document library, a list
of the account team members, and the account status. Which approach should you
recommend?

You are designing a solution that includes a custom list on a SharePoint 2010 site. You
need to design the solution to meet the following requirements: ·The solution needs to add
customized files to the site as part of the list provisioning. .The list should only be
provisioned in the sites of the site collection where it is specifically needed. .The files must
no longer remain provisioned in the site if the custom list is removed. Which approach
should you take?

You are designing a SharePoint 2010 solution for a large sales force. You have the
following requirements: ·Each sales region must have its own site within the solution with
lists to track the current sales data of the sales executives. .These lists must contain
information about the status of sales opportunities, the estimated price, the expected close
date, and contact information for the potential sale. .The welcome page for the root site
must display a current summary for all regions, including the percentage of sales expected

to close within the next month and total expected revenue over time. You need to design the
solution to meet all these requirements. What approach should you recommend?

You are designing a SharePoint 2010 solution to manage statements of work. You need to
design the solution according to the following requirements: ·Store the customer ID,
purchase order number, estimated completion date, and other fields associated with specific
documents as they are uploaded. .The information must be created so that it can be set
within the Microsoft Word document information panel. .Programmatically execute a series
of tasks, including assigning tasks to validate the information and creating team sites, based
on information related to each document. .These tasks must run to completion, even if the
server is rebooted. Which approach should you recommend?

You are designing a SharePoint 2010 solution. You need to design the solution to meet the
following requirements: ·All sites must have a consistent structure when initially created. .All
sites must include a document library that contains Word documents with searchable
properties. .Site users must be able to generate a spreadsheet detailing the properties of
the document library contents. Which approach should you recommend?

You are designing a SharePoint 2010 application. You need to ensure that a custom list
named Phone Numbers is automatically created and added to the site whenever a new
Team Site is created. Which approach should you recommend?

You are designing a custom SharePoint 2010 solution package. It will include a feature that
contains a Web Part, which requires a custom assembly for its functionality. You need to
design the feature based on the following requirements: ·The Web Part must be a partial
trust application and support a custom Code Access Security (CAS) policy. .The solution
package must be deployed without the need of farm-level administrator permissions. Which
approach should you recommend?

A SharePoint 2010 server farm has a custom feature installed that provides specialized
business logic for a SharePoint solution package. The solution package is being updated to
include additional functionality. Your job is to specify a deployment method for the updates
that will: ·Add the additional application business logic to the solution package. .Provide the
least downtime for the application. .Automate the application upgrade a much as possible
You need to update the solution package with additional business logic and meet all these

requirements. Which approach should you recommend?