You need to configure the database servers for high availability
DRAG DROP
###BeginCaseStudy###
Case Study: 5
Contoso Ltd
Background
A company named Contoso, Ltd. has offices in Seattle and Toronto. Each office has
a data center and a region-specific site in a single Active Directory Domain Services
(AD DS) domain named contoso.com. The database servers run Microsoft SQL
Server 2008 R2. Database servers are installed in each data center and are
members of the region-specific sites. The WAN connection between the data centers
is a dedicated T3 connection.
Existing Corporate Farm
Contoso has a SharePoint farm named HQ-SP10. The SharePoint servers in the
farm run SharePoint Server 2010 on Windows Server 2008 R2.
HQ-SP10 hosts many web applications that require unique service accounts. A
SharePoint 2010 web application named WebApp1 is located at
https://webapp1.contoso.com.
WebApp1 references a custom knowledge base module in HQ-SP10 and the content
is stored in the SharePoint database HQDB. Employees authenticate to WebApp1
by using classic mode authentication.
Users in both offices make frequent updates to SharePoint content. Administrators
make only minimal changes to the SharePoint farm settings and web applications.
Existing Product Support Farm
The product support department hosts a SharePoint farm named DEPT-SP13. The
SharePoint servers in the farm run SharePoint Server 2013 and are members of a
domain named PrdSupport.contoso.com.
DEPT-SP13 hosts two service applications:
A built-in service application provides access to a business data model connected to
the company’s data warehouse.
A custom service application named SvcApp1 provides access to data in a legacy
system.
Users in the product support department access the service applications by using a
local web application named WebApp2. WebApp2 is located at
webapp2.contoso.com and is stored in the SharePoint database DEPTDB. Users in
other departments access the service applications by using WebApp1.
Technical Challenges
You are upgrading HQ-SP10 and the web applications hosted in the farm to a new
SharePoint Server 2013 farm named HQ-SP13. When upgrading the content
database to SharePoint Server 2013, you receive the following error message:
Business Requirements
The SharePoint 2010 environment must meet the following business requirements:
HQ-SP10 must provide read-only access to users during the migration.
All customizations in HQ-SP10 must be migrated to HQ-SP13.
The SharePoint 2013 environment must meet the following business requirements:
HQ-SP13 and the web applications must remain available if one of the SharePoint
servers or database servers is offline.
Users’ documents stored in HQ-SP13 must be available if all the servers in a region are offline.
Shared resources in SvcApp1 must be available to other SharePoint farms in the company.
All customizations in HQ-SP13 must be verified after the farm upgrade.
Periodically, you must provide an offline copy of site content from HQ-SP13 to the
legal department.
Technical Requirements
You have the following technical requirements:
All users must be able to access the business data model for the company data warehouse.
Backup administrators must be able to restore HQ-SP13, WebApp1, and SvcApp1
separately.
The SharePoint 2013 environment for HQ-SP13 must meet the following technical
requirements:
The database servers must run Microsoft SQL Server 2012.
The databases must belong to a SQL Server AlwaysOn Availability Group and use
the WAN connection for database replication between the sites.
The database servers must be configured with the Enable Contained Databases
property.
Application pools for the web applications require unique service accounts.
After the upgrade, users in the accounting department who connect to WebApp1
must be able to access shared resources in SvcApp1.
###EndCaseStudy###
You need to configure the database servers for high availability. What should you do? (To
answer, drag the appropriate elements to the correct target or targets in the answer area.
Each element may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)
Which solution should you choose?
###BeginCaseStudy###
Case Study: 5
Contoso Ltd
Background
A company named Contoso, Ltd. has offices in Seattle and Toronto. Each office has
a data center and a region-specific site in a single Active Directory Domain Services
(AD DS) domain named contoso.com. The database servers run Microsoft SQL
Server 2008 R2. Database servers are installed in each data center and are
members of the region-specific sites. The WAN connection between the data centers
is a dedicated T3 connection.
Existing Corporate Farm
Contoso has a SharePoint farm named HQ-SP10. The SharePoint servers in the
farm run SharePoint Server 2010 on Windows Server 2008 R2.
HQ-SP10 hosts many web applications that require unique service accounts. A
SharePoint 2010 web application named WebApp1 is located at
https://webapp1.contoso.com.
WebApp1 references a custom knowledge base module in HQ-SP10 and the content
is stored in the SharePoint database HQDB. Employees authenticate to WebApp1
by using classic mode authentication.
Users in both offices make frequent updates to SharePoint content. Administrators
make only minimal changes to the SharePoint farm settings and web applications.
Existing Product Support Farm
The product support department hosts a SharePoint farm named DEPT-SP13. The
SharePoint servers in the farm run SharePoint Server 2013 and are members of a
domain named PrdSupport.contoso.com.
DEPT-SP13 hosts two service applications:
A built-in service application provides access to a business data model connected to
the company’s data warehouse.
A custom service application named SvcApp1 provides access to data in a legacy
system.
Users in the product support department access the service applications by using a
local web application named WebApp2. WebApp2 is located at
webapp2.contoso.com and is stored in the SharePoint database DEPTDB. Users in
other departments access the service applications by using WebApp1.
Technical Challenges
You are upgrading HQ-SP10 and the web applications hosted in the farm to a new
SharePoint Server 2013 farm named HQ-SP13. When upgrading the content
database to SharePoint Server 2013, you receive the following error message:
Business Requirements
The SharePoint 2010 environment must meet the following business requirements:
HQ-SP10 must provide read-only access to users during the migration.
All customizations in HQ-SP10 must be migrated to HQ-SP13.
The SharePoint 2013 environment must meet the following business requirements:
HQ-SP13 and the web applications must remain available if one of the SharePoint
servers or database servers is offline.
Users’ documents stored in HQ-SP13 must be available if all the servers in a region are offline.
Shared resources in SvcApp1 must be available to other SharePoint farms in the company.
All customizations in HQ-SP13 must be verified after the farm upgrade.
Periodically, you must provide an offline copy of site content from HQ-SP13 to the
legal department.
Technical Requirements
You have the following technical requirements:
All users must be able to access the business data model for the company data warehouse.
Backup administrators must be able to restore HQ-SP13, WebApp1, and SvcApp1
separately.
The SharePoint 2013 environment for HQ-SP13 must meet the following technical
requirements:
The database servers must run Microsoft SQL Server 2012.
The databases must belong to a SQL Server AlwaysOn Availability Group and use
the WAN connection for database replication between the sites.
The database servers must be configured with the Enable Contained Databases
property.
Application pools for the web applications require unique service accounts.
After the upgrade, users in the accounting department who connect to WebApp1
must be able to access shared resources in SvcApp1.
###EndCaseStudy###
You need to choose a backup solution.
Which solution should you choose?
Which four actions should you perform in sequence?
DRAG DROP
###BeginCaseStudy###
Case Study: 5
Contoso Ltd
Background
A company named Contoso, Ltd. has offices in Seattle and Toronto. Each office has
a data center and a region-specific site in a single Active Directory Domain Services
(AD DS) domain named contoso.com. The database servers run Microsoft SQL
Server 2008 R2. Database servers are installed in each data center and are
members of the region-specific sites. The WAN connection between the data centers
is a dedicated T3 connection.
Existing Corporate Farm
Contoso has a SharePoint farm named HQ-SP10. The SharePoint servers in the
farm run SharePoint Server 2010 on Windows Server 2008 R2.
HQ-SP10 hosts many web applications that require unique service accounts. A
SharePoint 2010 web application named WebApp1 is located at
https://webapp1.contoso.com.
WebApp1 references a custom knowledge base module in HQ-SP10 and the content
is stored in the SharePoint database HQDB. Employees authenticate to WebApp1
by using classic mode authentication.
Users in both offices make frequent updates to SharePoint content. Administrators
make only minimal changes to the SharePoint farm settings and web applications.
Existing Product Support Farm
The product support department hosts a SharePoint farm named DEPT-SP13. The
SharePoint servers in the farm run SharePoint Server 2013 and are members of a
domain named PrdSupport.contoso.com.
DEPT-SP13 hosts two service applications:
A built-in service application provides access to a business data model connected to
the company’s data warehouse.
A custom service application named SvcApp1 provides access to data in a legacy
system.
Users in the product support department access the service applications by using a
local web application named WebApp2. WebApp2 is located at
webapp2.contoso.com and is stored in the SharePoint database DEPTDB. Users in
other departments access the service applications by using WebApp1.
Technical Challenges
You are upgrading HQ-SP10 and the web applications hosted in the farm to a new
SharePoint Server 2013 farm named HQ-SP13. When upgrading the content
database to SharePoint Server 2013, you receive the following error message:
Business Requirements
The SharePoint 2010 environment must meet the following business requirements:
HQ-SP10 must provide read-only access to users during the migration.
All customizations in HQ-SP10 must be migrated to HQ-SP13.
The SharePoint 2013 environment must meet the following business requirements:
HQ-SP13 and the web applications must remain available if one of the SharePoint
servers or database servers is offline.
Users’ documents stored in HQ-SP13 must be available if all the servers in a region are offline.
Shared resources in SvcApp1 must be available to other SharePoint farms in the company.
All customizations in HQ-SP13 must be verified after the farm upgrade.
Periodically, you must provide an offline copy of site content from HQ-SP13 to the
legal department.
Technical Requirements
You have the following technical requirements:
All users must be able to access the business data model for the company data warehouse.
Backup administrators must be able to restore HQ-SP13, WebApp1, and SvcApp1
separately.
The SharePoint 2013 environment for HQ-SP13 must meet the following technical
requirements:
The database servers must run Microsoft SQL Server 2012.
The databases must belong to a SQL Server AlwaysOn Availability Group and use
the WAN connection for database replication between the sites.
The database servers must be configured with the Enable Contained Databases
property.
Application pools for the web applications require unique service accounts.
After the upgrade, users in the accounting department who connect to WebApp1
must be able to access shared resources in SvcApp1.
###EndCaseStudy###
You need to make the required resources available for users in the accounting department.
Which four 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.)
You need to resolve the SharePoint database error
###BeginCaseStudy###
Case Study: 5
Contoso Ltd
Background
A company named Contoso, Ltd. has offices in Seattle and Toronto. Each office has
a data center and a region-specific site in a single Active Directory Domain Services
(AD DS) domain named contoso.com. The database servers run Microsoft SQL
Server 2008 R2. Database servers are installed in each data center and are
members of the region-specific sites. The WAN connection between the data centers
is a dedicated T3 connection.
Existing Corporate Farm
Contoso has a SharePoint farm named HQ-SP10. The SharePoint servers in the
farm run SharePoint Server 2010 on Windows Server 2008 R2.
HQ-SP10 hosts many web applications that require unique service accounts. A
SharePoint 2010 web application named WebApp1 is located at
https://webapp1.contoso.com.
WebApp1 references a custom knowledge base module in HQ-SP10 and the content
is stored in the SharePoint database HQDB. Employees authenticate to WebApp1
by using classic mode authentication.
Users in both offices make frequent updates to SharePoint content. Administrators
make only minimal changes to the SharePoint farm settings and web applications.
Existing Product Support Farm
The product support department hosts a SharePoint farm named DEPT-SP13. The
SharePoint servers in the farm run SharePoint Server 2013 and are members of a
domain named PrdSupport.contoso.com.
DEPT-SP13 hosts two service applications:
A built-in service application provides access to a business data model connected to
the company’s data warehouse.
A custom service application named SvcApp1 provides access to data in a legacy
system.
Users in the product support department access the service applications by using a
local web application named WebApp2. WebApp2 is located at
webapp2.contoso.com and is stored in the SharePoint database DEPTDB. Users in
other departments access the service applications by using WebApp1.
Technical Challenges
You are upgrading HQ-SP10 and the web applications hosted in the farm to a new
SharePoint Server 2013 farm named HQ-SP13. When upgrading the content
database to SharePoint Server 2013, you receive the following error message:
Business Requirements
The SharePoint 2010 environment must meet the following business requirements:
HQ-SP10 must provide read-only access to users during the migration.
All customizations in HQ-SP10 must be migrated to HQ-SP13.
The SharePoint 2013 environment must meet the following business requirements:
HQ-SP13 and the web applications must remain available if one of the SharePoint
servers or database servers is offline.
Users’ documents stored in HQ-SP13 must be available if all the servers in a region are offline.
Shared resources in SvcApp1 must be available to other SharePoint farms in the company.
All customizations in HQ-SP13 must be verified after the farm upgrade.
Periodically, you must provide an offline copy of site content from HQ-SP13 to the
legal department.
Technical Requirements
You have the following technical requirements:
All users must be able to access the business data model for the company data warehouse.
Backup administrators must be able to restore HQ-SP13, WebApp1, and SvcApp1
separately.
The SharePoint 2013 environment for HQ-SP13 must meet the following technical
requirements:
The database servers must run Microsoft SQL Server 2012.
The databases must belong to a SQL Server AlwaysOn Availability Group and use
the WAN connection for database replication between the sites.
The database servers must be configured with the Enable Contained Databases
property.
Application pools for the web applications require unique service accounts.
After the upgrade, users in the accounting department who connect to WebApp1
must be able to access shared resources in SvcApp1.
###EndCaseStudy###
You need to resolve the SharePoint database error.
What should you do?
You need to install PowerPivot for SharePoint
You are configuring SharePoint 2013 to support business intelligence. You need to install
PowerPivot for SharePoint. What should you do?
You need to implement a solution that meets the requirements
You are configuring a SharePoint farm.
You have the following requirements:
Implement an enterprise resource pool.
Enable tasks to be assigned to users.
Implement a resource breakdown structure.
You need to implement a solution that meets the requirements.
What should you do?
You need to ensure that all web applications in the farm support SAML-based claims authentication
You are implementing a claims-based authentication solution for a SharePoint farm in an
Active Directory Domain Services domain. You install and configure Active Directory
Federation Services (AD FS). You need to ensure that all web applications in the farm
support SAML-based claims authentication. What should you do? (Each correct answer
presents part of the solution. Choose all that apply.)
You need to ensure that all customizations from the source farm are available in the destination farm
You are moving a customized SharePoint site collection to a new farm. You attach and
mount the source content database in the destination farm. You need to ensure that all
customizations from the source farm are available in the destination farm.
What should you do?
You need to ensure that you can perform verification testing without impacting the current user experience
An organization upgrades a SharePoint 2010 environment to SharePoint 2013. A site
collection is running in SharePoint 2010 compatibility mode.
You must verify that the following features will function correctly when the site collection is
upgraded to SharePoint 2013 native mode:
List views
Custom web parts
Content query web parts
Subsites
You need to ensure that you can perform verification testing without impacting the current
user experience.
What should you do?
Which three Windows PowerShell cmdlets should you run in sequence?
DRAG DROP
An organization migrates a SharePoint environment from SharePoint 2010 to SharePoint
2013. The organization has a web application at http://intranet.contoso.com. A corporate
governance policy states that users of the web application must be able to create sites only
with a compatibility level of SharePoint 2013. You need to implement the governance policy.
Which three Windows PowerShell cmdlets should you run in sequence? (To answer, move
the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the
correct order.)