###BeginCaseStudy##
Case Study: 2
World Wide Importers
Background
General Background
Wide World Importers plans to upgrade from SharePoint 2010 to SharePoint 2013 to
take advantage of additional business intelligence (BI) services, including
PerformancePoint Services, PowerPivot for Excel, and SQL Server Reporting
Services 2012 (SSRS). All users are members of an Active Directory Domain
Services (AD DS) domain.
Technical Background
The current environment integrates with a stand-alone instance of Microsoft SQL
Server 2008 R2 Analysis Services (SSAS). Wide World Importers has acquired SQL
Server 2012 licenses for the purpose of upgrading all the SQL Server instances to
SQL Server 2012.
Business Requirements
The SharePoint 2013 environment and supporting back-end servers that run SQL
Server must be highly available and redundant in the case of unplanned downtime or
a disaster.
Technical Environment
SharePoint 2013 Production Farm Topology
The SharePoint 2013 production farm topology consists of the servers listed in the following table.
The Wide World Importers SharePoint 2013 environment has the following
characteristics:
A hardware load-balancer is configured to balance traffic between PROD-WEB-01
and PROD-WEB-02.
SSRS is installed on PROD-APP-01 in SharePoint integrated mode.
SSRS report databases are stored on PROD-DB-01.
A site collection named Report Center has been created at http://
reports.wideworldimporters.com.
All SharePoint content and configuration databases are stored on PROD-DB-01.
All site collections have been migrated to a single content database named
WSS_Content.
A content database named WSS_TempContent has been restored to PROD-DB01,
but not attached to the SharePoint 2013 farm.
An
AD DS domain user account named PPS_SVC has been created.
SharePoint 2013 Disaster Recovery Site
The SharePoint 2013 Disaster Recovery farm topology consists of the servers listed in the following table.
Technical Requirements
Log shipping must be used to send transaction log backups to the instance of SQL
Server that is running in the disaster recovery site.
Discrete sets of SharePoint content databases must be configured to automatically
failover together.
An additional SQL Server 2012 Report Server must be added to the SharePoint
2013 environment. The server must be configured to use SharePoint integrated
mode.
Additional SQL Server 2012 Report Servers must not be installed on machines that
are running SharePoint as a front-end web server.
Site Collection administrators must not have the ability to upgrade site collections.
Site Collection upgrade jobs must be throttled to a maximum of five site collections at
a time.
A daily backup schedule must be created to perform SQL Server backups of all
SharePoint content and configuration databases.
The PPS_SVC AD DS user account must be used for the PerformancePoint service
application.
Farm administrators must be able to recover content from WSS_TempContent
without attaching the database to the farm.
All content databases within the production farm must be set to read-only when
patching and upgrading the farm.
Farm administrators must be able to determine which sites were missed or skipped
during the upgrade process and must be able to monitor any future upgrades.
###EndCaseStudy###
You need to meet the security requirement for site collection upgrades. Which two Windows
PowerShell cmdlets should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
$reports.AllowSelfServiceUpgrade = false
B.
$reports = Get-SPSite “http://reports.wideworldimporters.com”
C.
$reports.AllowSelfServiceUpgrade
D.
$reports = Get-SPWebApplication “http://reports.wideworldimporters.com”
E.
Sreports.AllowSelfServiceUpgrade = true
Explanation:
* At the Windows PowerShell command prompt, type the following command to view the
self-service upgrade setting for a site collection:$site=Get-SPSite <URL>
$site.AllowSelfServiceUpgrade=<Value>
Where:
<URL> is URL for the site collection that you want to affect.
<Value> is either ‘true’ to allow site collection administrators to upgrade the site, or ‘false’ to
not show them the notification and not allow them to upgrade.
* Get-SPSite Returns all site collections that match the specified criteria.
Note:
* From scenario:
/ A site collection named Report Center has been created at
http://reports.wideworldimporters.com.
/ Site Collection administrators must not have the ability to upgrade site collections.
/ Site Collection upgrade jobs must be throttled to a maximum of five site collections at a
time.
Incorrect:
D: Get-SPWebApplication Returns all Web applications that match the given criteria. The
Get-SPWebApplication cmdlet returns all Web applications that match the scope given by
the Identity parameter. The Identity can be the name of the name, URL, or GUID of the Web
application. If no Identity is specified, all Web applications are returned. The Central
Administration Web application is only returned if its exact identity is provided or the
IncludeCentralAdministration flag is provided. Reference: Manage site collection upgrades to
SharePoint 2013