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://webappl.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.




Before you upgrade the web application, you need to validate that customizations will continue to function. Which Windows PowerShell cmdlet should you run?


  1. Test-SPSite -Identity http://webapp1.contoso.com.

  2. Test-SPContentDatabase -Identity HQDB -WebApplication http://webapp1.contoso.com.

  3. Test-SPSite -Identity http://webapp2.contoso.com.

  4. Test-SPContentDatabase -Identity DEPTDB -WebApplication http:// webapp2.contoso.com.

  5. Get-SPUpgradeActions -AssignmentCollection spweb.


Correct Answer: B




You need to comply with the requirements of the legal department. Which two Windows PowerShell cmdlets should you run? (Each correct answer presents part of the solution. Choose two.)


  1. Mount-SPContentDatabase

  2. Restore-SPFarm

  3. Export-SPWeb

  4. Get-SPContentDatabase

  5. Backup-WebConfiguration


Correct Answer: BC




You need to ensure that users can edit the appropriate documents by using Office Web Apps.

Which Windows PowerShell cmdlet should you run?


  1. Set-SPWebApplication -Identity “https://webapp2.contoso.com”

-AdditionalClaimProvider Force

  1. Set-SPWebApplication -Identity “https://webapp1.contoso.com”

-AdditionalClaimProvider Force

  1. Convert-SPWebApplication -Identity “https://webapp2.contoso.com”

-To Claims -Retain Permissions

  1. Convert-SPWebApplication -Identity “https://webapp1.contoso.com”

-To Claims -Retain Permissions


Correct Answer: D




You need to configure authentication for the WebApp1 application pool account. What should you do?


  1. Add the application pool account to the db_owner fixed database role in the Master database.

  2. Add the application pool account to a contained database.

  3. Copy the application pool account from the primary replica databases to the secondary replica databases.

  4. Re-create the application pool account in SharePoint Server 2013.


Correct Answer: D





You are configuring service applications to support access to the company data warehouse. You need to assign permissions. Which two service applications should you configure?


To answer, select the appropriate service applications in the answer area.


Hot Area:



Correct Answer:





You need to configure the required level of access to the SharePoint 2010 farm prior to the migration. What should you do?


  1. In the corporate farm, run the ALTER DATABASE Transact-SQL statement.

  2. In the corporate farm, run the CONFIG DATABASE Transact-SQL statement.

  3. In the product support farm, run the CONFIG DATABASE Transact-SQL statement.

  4. In the product support farm, run the ALTER DATABASE Transact-SQL statement.


Correct Answer: A





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.


Select and Place:



Correct Answer:



You need to choose a backup solution. Which solution should you choose?


  1. SharePoint backup from the Central Administration console.

  2. SQL Server backup by using SQL Server Management Studio.

  3. Windows Server Backup in Windows Server 2012.

  4. SharePoint backup by using Data Protection Manager (DPM).


Correct Answer: B





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.


Select and Place:



Correct Answer:





Instant Access to Download Latest Complete Collection of Microsoft MCSE Share Point 2013 70-332 Real Exam

Try Microsoft MCSE Share Point 2013 70-332 Free Demo



Comments are closed.