What should you recommend?
###BeginCaseStudy###
Case Study: 7
Trey Research
Server Configurations
The SharePoint Server 2007 environment includes the servers configured as shown in the
following table.
The current environment does not use Excel Services, InfoPath Forms Services, or the
Business Data Catalog.
The SharePoint sites are accessed via a hardware load balancer.
Business Continuity Requirements
Business critical SharePoint lists must be backed up and restored independently of other
SharePoint content. Restored lists must retain their list views and alerts.
SharePoint patches and service packs must be tested before they are deployed to the
production environment.
Departmental Requirements
Trey Research has the following departmental requirements for the planned SharePoint
Server
2010 deployment:
Human resources department documents must only be accessible to users in the human
resources department.
Accounting department documents must only be accessible to users in the accounting
department.
Users in each department must be able to create and use their own search scopes.
Users in each department must be able to manage their own search keywords.
User Requirements
Trey Research uses a custom content type for its research department documents. Research
department documents must be created across multiple site collections. You must be able
to use the same content type across multiple site collections. You must use the minimum
amount of administrative effort to move content to the SharePoint Server 2010
environment. Users must be able to search all of the SharePoint content from a single Web
Part. Searches must include results from Bing.com.
###EndCaseStudy###
You are a SharePoint administrator for Trey Research. You plan to upgrade the existing Microsoft
Office SharePoint Server 2007 environment to SharePoint Server 2010 Service Pack 1 (SP1). You
need to recommend a SharePoint migration strategy that meets the company’s requirements. What
should you recommend?
What should you recommend?
###BeginCaseStudy###
Case Study: 7
Trey Research
Server Configurations
The SharePoint Server 2007 environment includes the servers configured as shown in the
following table.
The current environment does not use Excel Services, InfoPath Forms Services, or the
Business Data Catalog.
The SharePoint sites are accessed via a hardware load balancer.
Business Continuity Requirements
Business critical SharePoint lists must be backed up and restored independently of other
SharePoint content. Restored lists must retain their list views and alerts.
SharePoint patches and service packs must be tested before they are deployed to the
production environment.
Departmental Requirements
Trey Research has the following departmental requirements for the planned SharePoint
Server
2010 deployment:
Human resources department documents must only be accessible to users in the human
resources department.
Accounting department documents must only be accessible to users in the accounting
department.
Users in each department must be able to create and use their own search scopes.
Users in each department must be able to manage their own search keywords.
User Requirements
Trey Research uses a custom content type for its research department documents. Research
department documents must be created across multiple site collections. You must be able
to use the same content type across multiple site collections. You must use the minimum
amount of administrative effort to move content to the SharePoint Server 2010
environment. Users must be able to search all of the SharePoint content from a single Web
Part. Searches must include results from Bing.com.
###EndCaseStudy###
You are a SharePoint administrator for Trey Research. Vow plan to upgrade the existing Microsoft
Office SharePoint Server 2007 environment to SharePoint Server 2010 Service Pack 1 (SP1). You
need to recommend a solution to back up the business critical lists. You must restore the lists in the
minimum amount of time. What should you recommend?
What should you include in the solution?
###BeginCaseStudy###
Case Study: 8
Tailspin Toys
Network Configurations
The network contains a perimeter network and an internal network. The internal network
and the perimeter network are separated by a firewall.
The perimeter network contains two SharePoint Server 2010 servers named Serverl and
Server2.
The internal network contains two servers named Server3 and Server4 that run Microsoft
SQL Server 2008.
Server3 hosts a SharePoint content database named SQL_SharePoint . Server4 hosts two
non-SharePoint databases named SQL_Toys and SQL_Customers .
Database Configurations
SQL_Toys contains detailed information about the products that Tailspin Toys sells. Each
product is assigned a property named Category that is stored in SQL_Toys . The products are
classified in SQL_Toys by Category.
SQL_Customers contains the credentials that will be used by the customers.
User Access Requirements
The Tailspin Toys Web site must meet the following user access requirements:
Support anonymous access.
Ensure that users can search for products by using SharePoint search.
Ensure that users can filter searches based on product category.
Provide customers with access to a secure site named
https://www.tailspintoys.com/pricing.
Provide access to a site named http://www.tailspintoys.com/products that displays detailed
product information.
Technical Requirements
The Tailspin Toys Web site must meet the following technical requirements:
Server2 must be used to index content.
Server1 must be used for user searches.
Content from the SQL_Toys database must be accessible from the SharePoint sites.
Search results from http://www.tailspintoys.com/products must display at the top of the
page.
Security Requirements
The Tailspin Toys Web site must meet the following security requirements:
Encrypt all access to pricing information.
Ensure that the SQL Servers are on the internal network.
Ensure that all access to the SQL_Toys database is performed by a SQL Server login that uses
SQL Server Authentication.
###EndCaseStudy###
You are a SharePoint administrator for Tailspin Toys.
The company has a main office. The main office is located in London.
The company has 1,000 employees and 1,000 customers.
You plan to create a product information Web site by using SharePoint technologies named
www.tailspintoys.com.
You need to recommend a solution to filter the search results based on product category.
What should you include in the solution?
What should you include in the solution?
###BeginCaseStudy###
Case Study: 8
Tailspin Toys
Network Configurations
The network contains a perimeter network and an internal network. The internal network
and the perimeter network are separated by a firewall.
The perimeter network contains two SharePoint Server 2010 servers named Serverl and
Server2.
The internal network contains two servers named Server3 and Server4 that run Microsoft
SQL Server 2008.
Server3 hosts a SharePoint content database named SQL_SharePoint . Server4 hosts two
non-SharePoint databases named SQL_Toys and SQL_Customers .
Database Configurations
SQL_Toys contains detailed information about the products that Tailspin Toys sells. Each
product is assigned a property named Category that is stored in SQL_Toys . The products are
classified in SQL_Toys by Category.
SQL_Customers contains the credentials that will be used by the customers.
User Access Requirements
The Tailspin Toys Web site must meet the following user access requirements:
Support anonymous access.
Ensure that users can search for products by using SharePoint search.
Ensure that users can filter searches based on product category.
Provide customers with access to a secure site named
https://www.tailspintoys.com/pricing.
Provide access to a site named http://www.tailspintoys.com/products that displays detailed
product information.
Technical Requirements
The Tailspin Toys Web site must meet the following technical requirements:
Server2 must be used to index content.
Server1 must be used for user searches.
Content from the SQL_Toys database must be accessible from the SharePoint sites.
Search results from http://www.tailspintoys.com/products must display at the top of the
page.
Security Requirements
The Tailspin Toys Web site must meet the following security requirements:
Encrypt all access to pricing information.
Ensure that the SQL Servers are on the internal network.
Ensure that all access to the SQL_Toys database is performed by a SQL Server login that uses
SQL Server Authentication.
###EndCaseStudy###
You are a SharePoint administrator for Tailspin Toys.
The company has a main office. The main office is located in London.
The company has 1,000 employees and 1,000 customers.
You plan to create a product information Web site by using SharePoint technologies named
www.tailspintoys.com.
You need to recommend a solution to display the company’s product information on the SharePoint
Web site.
What should you include in the solution?
What should you include in the solution?
###BeginCaseStudy###
Case Study: 8
Tailspin Toys
Network Configurations
The network contains a perimeter network and an internal network. The internal network
and the perimeter network are separated by a firewall.
The perimeter network contains two SharePoint Server 2010 servers named Serverl and
Server2.
The internal network contains two servers named Server3 and Server4 that run Microsoft
SQL Server 2008.
Server3 hosts a SharePoint content database named SQL_SharePoint . Server4 hosts two
non-SharePoint databases named SQL_Toys and SQL_Customers .
Database Configurations
SQL_Toys contains detailed information about the products that Tailspin Toys sells. Each
product is assigned a property named Category that is stored in SQL_Toys . The products are
classified in SQL_Toys by Category.
SQL_Customers contains the credentials that will be used by the customers.
User Access Requirements
The Tailspin Toys Web site must meet the following user access requirements:
Support anonymous access.
Ensure that users can search for products by using SharePoint search.
Ensure that users can filter searches based on product category.
Provide customers with access to a secure site named
https://www.tailspintoys.com/pricing.
Provide access to a site named http://www.tailspintoys.com/products that displays detailed
product information.
Technical Requirements
The Tailspin Toys Web site must meet the following technical requirements:
Server2 must be used to index content.
Server1 must be used for user searches.
Content from the SQL_Toys database must be accessible from the SharePoint sites.
Search results from http://www.tailspintoys.com/products must display at the top of the
page.
Security Requirements
The Tailspin Toys Web site must meet the following security requirements:
Encrypt all access to pricing information.
Ensure that the SQL Servers are on the internal network.
Ensure that all access to the SQL_Toys database is performed by a SQL Server login that uses
SQL Server Authentication.
###EndCaseStudy###
You are a SharePoint administrator for Tailspin Toys.
The company has a main office. The main office is located in London.
The company has 1,000 employees and 1,000 customers.
You plan to create a product information Web site by using SharePoint technologies named
www.tailspintoys.com.
You need to recommend a solution to rank the search results that meets the company’s
requirements.
What should you include in the solution?
What should you implement?
###BeginCaseStudy###
Case Study: 8
Tailspin Toys
Network Configurations
The network contains a perimeter network and an internal network. The internal network
and the perimeter network are separated by a firewall.
The perimeter network contains two SharePoint Server 2010 servers named Serverl and
Server2.
The internal network contains two servers named Server3 and Server4 that run Microsoft
SQL Server 2008.
Server3 hosts a SharePoint content database named SQL_SharePoint . Server4 hosts two
non-SharePoint databases named SQL_Toys and SQL_Customers .
Database Configurations
SQL_Toys contains detailed information about the products that Tailspin Toys sells. Each
product is assigned a property named Category that is stored in SQL_Toys . The products are
classified in SQL_Toys by Category.
SQL_Customers contains the credentials that will be used by the customers.
User Access Requirements
The Tailspin Toys Web site must meet the following user access requirements:
Support anonymous access.
Ensure that users can search for products by using SharePoint search.
Ensure that users can filter searches based on product category.
Provide customers with access to a secure site named
https://www.tailspintoys.com/pricing.
Provide access to a site named http://www.tailspintoys.com/products that displays detailed
product information.
Technical Requirements
The Tailspin Toys Web site must meet the following technical requirements:
Server2 must be used to index content.
Server1 must be used for user searches.
Content from the SQL_Toys database must be accessible from the SharePoint sites.
Search results from http://www.tailspintoys.com/products must display at the top of the
page.
Security Requirements
The Tailspin Toys Web site must meet the following security requirements:
Encrypt all access to pricing information.
Ensure that the SQL Servers are on the internal network.
Ensure that all access to the SQL_Toys database is performed by a SQL Server login that uses
SQL Server Authentication.
###EndCaseStudy###
You are a SharePoint administrator for Tailspin Toys.
The company has a main office. The main office is located in London.
The company has 1,000 employees and 1,000 customers.
You plan to create a product information Web site by using SharePoint technologies named
www.tailspintoys.com.
You need to plan the search topology for the Web site.
What should you implement?
What should you include in the solution?
###BeginCaseStudy###
Case Study: 8
Tailspin Toys
Network Configurations
The network contains a perimeter network and an internal network. The internal network
and the perimeter network are separated by a firewall.
The perimeter network contains two SharePoint Server 2010 servers named Serverl and
Server2.
The internal network contains two servers named Server3 and Server4 that run Microsoft
SQL Server 2008.
Server3 hosts a SharePoint content database named SQL_SharePoint . Server4 hosts two
non-SharePoint databases named SQL_Toys and SQL_Customers .
Database Configurations
SQL_Toys contains detailed information about the products that Tailspin Toys sells. Each
product is assigned a property named Category that is stored in SQL_Toys . The products are
classified in SQL_Toys by Category.
SQL_Customers contains the credentials that will be used by the customers.
User Access Requirements
The Tailspin Toys Web site must meet the following user access requirements:
Support anonymous access.
Ensure that users can search for products by using SharePoint search.
Ensure that users can filter searches based on product category.
Provide customers with access to a secure site named
https://www.tailspintoys.com/pricing.
Provide access to a site named http://www.tailspintoys.com/products that displays detailed
product information.
Technical Requirements
The Tailspin Toys Web site must meet the following technical requirements:
Server2 must be used to index content.
Server1 must be used for user searches.
Content from the SQL_Toys database must be accessible from the SharePoint sites.
Search results from http://www.tailspintoys.com/products must display at the top of the
page.
Security Requirements
The Tailspin Toys Web site must meet the following security requirements:
Encrypt all access to pricing information.
Ensure that the SQL Servers are on the internal network.
Ensure that all access to the SQL_Toys database is performed by a SQL Server login that uses
SQL Server Authentication.
###EndCaseStudy###
You are a SharePoint administrator for Tailspin Toys.
The company has a main office. The main office is located in London.
The company has 1,000 employees and 1,000 customers.
You plan to create a product information Web site by using SharePoint technologies named
www.tailspintoys.com.
You need to recommend a solution that provides customers with access to the company’s pricing
information. What should you include in the solution?
Which port or ports should you identify?
###BeginCaseStudy###
Case Study: 8
Tailspin Toys
Network Configurations
The network contains a perimeter network and an internal network. The internal network
and the perimeter network are separated by a firewall.
The perimeter network contains two SharePoint Server 2010 servers named Serverl and
Server2.
The internal network contains two servers named Server3 and Server4 that run Microsoft
SQL Server 2008.
Server3 hosts a SharePoint content database named SQL_SharePoint . Server4 hosts two
non-SharePoint databases named SQL_Toys and SQL_Customers .
Database Configurations
SQL_Toys contains detailed information about the products that Tailspin Toys sells. Each
product is assigned a property named Category that is stored in SQL_Toys . The products are
classified in SQL_Toys by Category.
SQL_Customers contains the credentials that will be used by the customers.
User Access Requirements
The Tailspin Toys Web site must meet the following user access requirements:
Support anonymous access.
Ensure that users can search for products by using SharePoint search.
Ensure that users can filter searches based on product category.
Provide customers with access to a secure site named
https://www.tailspintoys.com/pricing.
Provide access to a site named http://www.tailspintoys.com/products that displays detailed
product information.
Technical Requirements
The Tailspin Toys Web site must meet the following technical requirements:
Server2 must be used to index content.
Server1 must be used for user searches.
Content from the SQL_Toys database must be accessible from the SharePoint sites.
Search results from http://www.tailspintoys.com/products must display at the top of the
page.
Security Requirements
The Tailspin Toys Web site must meet the following security requirements:
Encrypt all access to pricing information.
Ensure that the SQL Servers are on the internal network.
Ensure that all access to the SQL_Toys database is performed by a SQL Server login that uses
SQL Server Authentication.
###EndCaseStudy###
The company’s security team reports that the firewall has too many open ports. You need to identify
the port or ports required by SharePoint to access Server4.
Which port or ports should you identify?
What should you include in the solution?
###BeginCaseStudy###
Case Study: 9
Adventure Works
Network Configuration
The company has an internal network and a perimeter network.
Technical Requirements
Adventure Works has the following technical requirements for the planned SharePoint
Server 2010 deployment:
The public Web site must be available if a single server fails.
E-mail enabled document libraries must not be used on the public Web site.
E-mail-enabled document libraries must be used internally for content collaboration.
Internal users must be able to search both internal content and public site content from a
single Web Part.
A denial-of-service attack on the public site must not prevent internal users from
collaborating on content.
Internal users must be able to search new content on the SharePoint servers within IS
minutes of the content being added to the server, even if a single server fails.
Security Requirements
Adventure Works has the following security requirements for the planned SharePoint Server
2010 deployment:
SharePoint user solutions must not be deployed on the public site.
Users who connect to the public site must be denied access to the company’s internal
resources.
SharePoint solutions used for internal collaboration and SharePoint solutions used for the
public site must have separate solution stores.
Business Process
Adventure Works plans to implement the following business processes for the SharePoint
Server 2010 deployment:
Only Web administrators will be able to modify content on the public site. All content must
be approved by the legal department before it is made available to the public.
Internal users will use Microsoft Office Word to create travel catalogs. The catalogs will be
available in the internal collaboration environment. Catalogs must be available as Web
pages.
Managers will use scorecards to help measure and monitor key performance indicators
(KPIs). The managers must use the KPIs to calculate business metrics.
###EndCaseStudy###
You are a SharePoint administrator for Adventure Works. You plan to deploy SharePoint Server 2010
to improve internal collaboration for the company. You also plan to use SharePoint Server 2010 as
the platform for the company’s public Web site. You need to recommend a solution to convert the
catalogs. What should you include in the solution?
What should you include in the design?
###BeginCaseStudy###
Case Study: 9
Adventure Works
Network Configuration
The company has an internal network and a perimeter network.
Technical Requirements
Adventure Works has the following technical requirements for the planned SharePoint
Server 2010 deployment:
The public Web site must be available if a single server fails.
E-mail enabled document libraries must not be used on the public Web site.
E-mail-enabled document libraries must be used internally for content collaboration.
Internal users must be able to search both internal content and public site content from a
single Web Part.
A denial-of-service attack on the public site must not prevent internal users from
collaborating on content.
Internal users must be able to search new content on the SharePoint servers within IS
minutes of the content being added to the server, even if a single server fails.
Security Requirements
Adventure Works has the following security requirements for the planned SharePoint Server
2010 deployment:
SharePoint user solutions must not be deployed on the public site.
Users who connect to the public site must be denied access to the company’s internal
resources.
SharePoint solutions used for internal collaboration and SharePoint solutions used for the
public site must have separate solution stores.
Business Process
Adventure Works plans to implement the following business processes for the SharePoint
Server 2010 deployment:
Only Web administrators will be able to modify content on the public site. All content must
be approved by the legal department before it is made available to the public.
Internal users will use Microsoft Office Word to create travel catalogs. The catalogs will be
available in the internal collaboration environment. Catalogs must be available as Web
pages.
Managers will use scorecards to help measure and monitor key performance indicators
(KPIs). The managers must use the KPIs to calculate business metrics.
###EndCaseStudy###
You are a SharePoint administrator for Adventure Works. You plan to deploy SharePoint Server 2010
to improve internal collaboration for the company. You also plan to use SharePoint Server 2010 as
the platform for the company’s public Web site. You need to design the server farm deployment.
Your solution must minimize costs. What should you include in the design?