###BeginCaseStudy###
Case Study: 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 microblogging, 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 frontend 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###

DRAG DROP
You need to configure authentication for the Tailspin360.TailspinToys.com site.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* Step 1:
/ Target Application Type. By default, SharePoint Online uses type Group Restricted.
/ In the Members section, enter a list of users or SharePoint Online groups of users who need to
access the target application. Or, you can use the Browse button to search for the name of a group
that you want to map to the Target Application.
* Step 2:
In the Credential Fields section, enter the Field Names and Field Types for the credentials that are
required to access data in the Target Application. These fields determine how you will map identity
in the Secure Store Service. By default, the Credential Fields list the Windows User Name and
Windows Password with matching Field Types (User Name and Password), and specifies that the
password is masked.
* Step 3:
If you are using Excel Services, use the procedures in this section to complete the necessary
configuration steps.
If the Unattended Service Account has not already been configured for Excel Services, follow these
steps to configure it.
To configure the Unattended Service Account
On the SharePoint Central Administration home page, under Application Management, click Manage
Service Applications.
Click the Excel Services service application.
Click Global Settings.
In the External Data section, choose the Use an existing Unattended Service Account option, and
then type the name of the target application that you created for the Unattended Service Account in
the Target Application ID text box.
Click OK.
* From scenario:
/ The site must be accessible only to members of the Sales team.
/ 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.
* The Secure Store Service is designed to create a background mapping between a group of users in
SharePoint, and a single user known to the external data system. When the Secure Store Service is
properly configured, the following occurs:
* A user authenticates through Internet Information Services (the web server technology underlying
SharePoint technologies) to SharePoint Online via valid credentials.
* Inside SharePoint Online, the Secure Store Service uses mapped credentials known to the external
business application to render any necessary external data on the site for the authenticated user.
Create or edit a Secure Store Target Application