You need to configure the BCS model to access data

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

You need to configure the BCS model to access data.
What should you do?

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

You need to configure the BCS model to access data.
What should you do?

A.
Create an external content type and enter the target application friendly name in the Secure Store
Application ID field.

B.
Create an external content type and enter the target application ID in the Secure Store Application
ID field.

C.
Create an external content type and choose the Connect with impersonated custom identity
option. Enter the target application friendly name of the Secure Store target application.

D.
Create an external content type and choose the Connect with user’s identity option.



Leave a Reply 2

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


Bruce Wayne

Bruce Wayne

I agree with this answer.