You need to configure Excel Services

###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?

###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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *