###BeginCaseStudy###
Topic 1, Tailspin Toys
Background
You are planning a SharePoint deployment. The new farm will host several business solutions including:
www.TailspinToys.com
Tailspin360.TaiIspinToys.com
MyTailspin.TailspinToys.com
All employees have Active Directory Domain Service (AD DS) accounts. Members of the SalesUsers AD DS
security group are the only users with permissions to create My Sites sites.
Business Requirements
www.TailspinToys.com
www.TailspinToys.com is an Internet business site that will provide eCommerce capabilities including a product
catalog, a shopping cart, and an account settings page.
Tailspin360.TailspinToys.com
Tailspin360.TailspinToys.com provides a business intelligence (BI) solution for the Sales team. It must allow
users to share Microsoft Excel workbooks and build dashboards.
Tailspin360.TailspinToys.com accesses data that is located in various repositories including Microsoft SQL
Server.
MyTailspin.TailspinToys.com
MyTailspin.TailspinToys.com is a social collaboration environment that provides micro-blogging, file and video
sharing, and the ability to create personal blogs and wikis for Tailspin Toys employees.
Technical Requirements
General
The farm must be made fault tolerant by using virtualization.
The farm must include two front-end web servers.
Page requests must be distributed equally across the front-end web servers.
All content must remain available to users if one of the front-end web servers becomes unavailable.
All Sales department employees are members of the SalesUsers group.
All customer, order, and product information will be stored in tables in a Microsoft SQL Server database.
The User Profile service application is provisioned but not configured.
www.TailspinToys.com
You must create a version of the site that provides an optimized experience for Windows Phone devices.
You have created a device channel that detects the user-agent.
The website must support English (United States), Spanish (Mexico), and German (Germany). All content is
authored in English and then translated into Spanish and German by an outside vendor. Translations are
performed by humans.
Tailspin360.TailspinToys.com
The site must be accessible only to members of the Sales team.
Users must be able to access order information that is stored in a SQL Server database.
Developers must be able to import Business Connectivity Services (BCS) models by using Central
Administration.
The salesAccess shared domain account has permissions to read data from the database.
Excel workbooks published to a document library app must be opened in a browser. Excel workbooks in
other locations must open in Excel.
MyTailspin.TailspinToys.com
You need to provision a SharePoint environment that supports My Sites for an enterprise.
You need to ensure the SharePoint Server configuration supports the ability to create individual site
collections the first time a user accesses the My Site page.All users need permissions to create My Sites sites.
###EndCaseStudy###
You need to configure Excel Services.
What should you do?
A.
Add a trusted file location to the Tailspin360 site.
B.
Add each user as a Viewer.
C.
Add each user as a Contributor.
D.
Add a trusted data connection library to the Tailspin360 site.
Explanation:
Introduction to Trusted File Locations for Excel Services
Excel Services automatically creates a default trusted file location (http://) which trusts the whole SharePoint
Server farm. This default trusted location enables any file to be loaded from the SharePoint Server farm or
stand-alone deployment by using Excel Services.
Trusting the whole SharePoint farm by default enables easier setup for administrators.
Administrators can define new trusted file locations to expand workbook capabilities and tighten security.
Excel Services administrators can add new trusted file locations as needed. Trusted file locations are either
SharePoint sites, UNC paths, or HTTP Web sites from which a server that is running Excel Services is
permitted to access workbooks.
To make sure that only trusted users have access to workbooks stored in trusted locations, it is important to
enforce ACLs on all trusted file locations.
There are three core scenarios to deploy Excel Services: enterprise, small department, and custom.
In an enterprise deployment, consider the following guidelines:
Do not configure support for user-defined functions.
Do not enable workbooks to use embedded data connections to directly access external data sources.
Limit the use of data connection libraries for external data source access from workbooks.
Restrict the size of workbooks that can be opened in Excel Services.
Selectively trust specific file locations and do not enable Trust Children for trusted sites and directories.
http://technet.microsoft.com/en-us/library/jj219565.aspx
Add a trusted file location
Use the following procedure to add a trusted file location in Excel Services.
To add a trusted file location
1. On the SharePoint Central Administration website home page, in the Application Management section, click
Manage service applications.
2. On the Manage service applications page, click the Excel Services service application that you want to
configure.
3. On the Manage Excel Services Application page, click Trusted File Locations.
4. On the Excel Services Application Trusted File Locations page, click Add Trusted File Location.
5. Configure the settings for the trusted file location as described in Configure a trusted file location, below.
Configure a trusted file location
Use the following procedure to configure a trusted file location.
1. On the SharePoint Central Administration websitehome page, in the Application Management section, click
Manage service applications.
2. On the Manage service applications page, click the Excel Services service application that you want to
configure.
3. On the Manage Excel Services Application page, click Trusted File Locations.
4. In the Address column, click the trusted file location that you want to configure.5. Configure the settings as described in the following table:
http://technet.microsoft.com/en-us/library/jj219699.aspx
Kong (US, 17.06.13): Answer D.
http://technet.microsoft.com/en-us/library/dn198294.aspx.