Microsoft Advanced Solutions of Microsoft SharePoint Server 2013 - 070-332 Exam Practice Test
Question 1
You are the administrator of your company's SharePoint environment.
The company plans to use Excel Services. A file share is designated to contain all the files that are used by Excel
Services.
You need to configure Excel Services to use the file share.
What should you do?
The company plans to use Excel Services. A file share is designated to contain all the files that are used by Excel
Services.
You need to configure Excel Services to use the file share.
What should you do?
Correct Answer: D
Question 2
You are creating a SharePoint site that will be accessed remotely.
You need to optimize the SharePoint experience for all mobile devices.
What should you configure?
You need to optimize the SharePoint experience for all mobile devices.
What should you configure?
Correct Answer: A
Question 3
You are the administrator of a SharePoint environment. The SharePoint environment uses Azure Infrastructure
Services for disaster recovery.
You must create a disaster recovery plan that includes warm failover to Azure Infrastructure Services.
You need to identify which service databases must be restored.
Which two service databases must you restore? Each correct answer presents part of the solution.
Services for disaster recovery.
You must create a disaster recovery plan that includes warm failover to Azure Infrastructure Services.
You need to identify which service databases must be restored.
Which two service databases must you restore? Each correct answer presents part of the solution.
Correct Answer: C,D
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 4
DRAG DROP
A company plans to upgrade a SharePoint 2010 farm to SharePoint Server 2013. The site collection administrators will
upgrade the SharePoint sites.
The SharePoint 2013 environment contains a web application dedicated to the upgrade process.
You need to migrate SharePoint 2010 content to the SharePoint 2013 environment. Before completing the upgrade
process, you must ensure that all required customizations have been deployed.
Which three 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.)
A company plans to upgrade a SharePoint 2010 farm to SharePoint Server 2013. The site collection administrators will
upgrade the SharePoint sites.
The SharePoint 2013 environment contains a web application dedicated to the upgrade process.
You need to migrate SharePoint 2010 content to the SharePoint 2013 environment. Before completing the upgrade
process, you must ensure that all required customizations have been deployed.
Which three 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.)
Correct Answer:
Box 1: In the SharePoint 2013 farm, restore the SharePoint Server 2010 databases.
Box 2: Run the Mount-SpContentDatabase Windows PowerShell cmdlet.
Box 3: Run the Test-SPContentDatabase Windows PowerShell cmdlet.
Note:
* You must use the Mount-SPContentDatabasecmdlet to attach a content database to a web application.
* (incorrect) Using the SharePoint Central Administration pages to attach a content database is not supported for
upgrading.
* This is the fourth phase in the process to upgrade SharePoint 2010 Products data and sites to SharePoint 2013. The
process includes the following phases that must be completed in order:
1.Create the SharePoint 2013 farm for a database attach upgrade
2.Copy databases to the new farm for upgrade to SharePoint 2013
3.Upgrade service applications to SharePoint 2013
4.Upgrade content databases to SharePoint 2013 (this phase)
5.Upgrade site collections to SharePoint 2013
* Test-SPContentDatabase
Tests a content database.
Use the Test-SPContentDatabasecmdlet to test a content database against a Web application to verify all
customizations referenced within the content database are also installed in the web application. This cmdlet can be
issued against a content database currently attached to the farm, or a content database that is not connected to the
farm. It can be used to test content databases from SharePoint 2010 Products and from SharePoint Products and
Technologies.
* (incorrect) There is no method Move-SPWebApplication
Reference: Upgrade content databases to SharePoint 2013
Box 2: Run the Mount-SpContentDatabase Windows PowerShell cmdlet.
Box 3: Run the Test-SPContentDatabase Windows PowerShell cmdlet.
Note:
* You must use the Mount-SPContentDatabasecmdlet to attach a content database to a web application.
* (incorrect) Using the SharePoint Central Administration pages to attach a content database is not supported for
upgrading.
* This is the fourth phase in the process to upgrade SharePoint 2010 Products data and sites to SharePoint 2013. The
process includes the following phases that must be completed in order:
1.Create the SharePoint 2013 farm for a database attach upgrade
2.Copy databases to the new farm for upgrade to SharePoint 2013
3.Upgrade service applications to SharePoint 2013
4.Upgrade content databases to SharePoint 2013 (this phase)
5.Upgrade site collections to SharePoint 2013
* Test-SPContentDatabase
Tests a content database.
Use the Test-SPContentDatabasecmdlet to test a content database against a Web application to verify all
customizations referenced within the content database are also installed in the web application. This cmdlet can be
issued against a content database currently attached to the farm, or a content database that is not connected to the
farm. It can be used to test content databases from SharePoint 2010 Products and from SharePoint Products and
Technologies.
* (incorrect) There is no method Move-SPWebApplication
Reference: Upgrade content databases to SharePoint 2013
Question 5
An organization has created graphic designs that will be used for branding in a SharePoint farm.
You need to develop the supporting assets required to implement the design in the minimum amount of time.
What should you use?
You need to develop the supporting assets required to implement the design in the minimum amount of time.
What should you use?
Correct Answer: A
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 6
DRAG DROP
You are configuring the ProseWeb site.
You need to create the root site collection on the web application.
Which three 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 are configuring the ProseWeb site.
You need to create the root site collection on the web application.
Which three 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.)
Correct Answer:
Box 1:
Box 2:
Box 3:
Note:
* Add-SPSolution uploads a SharePoint solution package to the farm.
* The Install-SPSolutioncmdlet deploys an installed SharePoint solution in the farm. Use the Add-SPSolutioncmdlet to
install a SharePoint solution package in the farm.
Box 2:
Box 3:
Note:
* Add-SPSolution uploads a SharePoint solution package to the farm.
* The Install-SPSolutioncmdlet deploys an installed SharePoint solution in the farm. Use the Add-SPSolutioncmdlet to
install a SharePoint solution package in the farm.
Question 7
A company has a SharePoint environment that contains multiple site collections.
The company purchases an app.
You need to ensure that the app is available in all site collections.
Which Windows PowerShell cmdlets should you run?
The company purchases an app.
You need to ensure that the app is available in all site collections.
Which Windows PowerShell cmdlets should you run?
Correct Answer: C
Question 8
HOTSPOT
You need to back up the HR site collection.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
You need to back up the HR site collection.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
Correct Answer:
Note:
* SQL Server: The content database is stored in SQL Server.
/ From Scenario: The farm currently uses SPS-DB01 as its primary database instance.
* Windows Scheduled task to set a reoccurring task.
* Backup-SPSite Performs a backup of a site collection.
* Daily
From scenario: The Site Owner of the HR site collection requires that the HR Site Collection be backed up in full on a
daily basis.
Question 9
You need to meet the site availability requirements.
What should you do?
What should you do?
Correct Answer: C
Question 10
DRAG DROP
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 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.)
Correct Answer:
Box 1: Set the permission for SvcApp1 to full Control on DEPT-Sp13.
Box 2: Exchange trust certificates between HQ-Sp13 and DEPT-Sp13.
Box 3: Connect to SvcApp1 on HQ-SP13. Add SvcApp1 to WebApp1.
Box 4: Publish SvcApp1 on HQ-Sp13.
Note:
* From scenario:
/ After the upgrade, users in the accounting department who connect to WebApp1 must be able to access shared
resources in SvcApp1
/ A custom service application named SvcApp1 provides access to data in a legacy system.
/ Shared resources in SvcApp1 must be available to other SharePoint farms in the company.
/ 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.
/ DEPT-Sp13 is the old server. HQ-Sp13 is the new server.
/ Current scenario:
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.
Box 2: Exchange trust certificates between HQ-Sp13 and DEPT-Sp13.
Box 3: Connect to SvcApp1 on HQ-SP13. Add SvcApp1 to WebApp1.
Box 4: Publish SvcApp1 on HQ-Sp13.
Note:
* From scenario:
/ After the upgrade, users in the accounting department who connect to WebApp1 must be able to access shared
resources in SvcApp1
/ A custom service application named SvcApp1 provides access to data in a legacy system.
/ Shared resources in SvcApp1 must be available to other SharePoint farms in the company.
/ 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.
/ DEPT-Sp13 is the old server. HQ-Sp13 is the new server.
/ Current scenario:
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.
Question 11
You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?
You need to install PowerPivot for SharePoint.
What should you do?
Correct Answer: D
Question 12
DRAG DROP
You are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections.
Three site collections are available only inside the company network. The fourth site collection is available to an
external partner company by using forms-based authentication. The external site collection is used to store contracts
and purchase orders. Every site collection has its own content database.
Contoso purchases an Office 365 subscription for external partner employees. Contoso plans to move the external site
collection to SharePoint Online. You have the following requirements:
Upgrade the external partner site collection to SharePoint Online.
Upgrade the on-premises farm to SharePoint 2013.
Minimize downtime for the upgrade.
Ensure the sites are read-only during the upgrade.
You need to plan the upgrade for the extranet site.
Which three 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 are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections.
Three site collections are available only inside the company network. The fourth site collection is available to an
external partner company by using forms-based authentication. The external site collection is used to store contracts
and purchase orders. Every site collection has its own content database.
Contoso purchases an Office 365 subscription for external partner employees. Contoso plans to move the external site
collection to SharePoint Online. You have the following requirements:
Upgrade the external partner site collection to SharePoint Online.
Upgrade the on-premises farm to SharePoint 2013.
Minimize downtime for the upgrade.
Ensure the sites are read-only during the upgrade.
You need to plan the upgrade for the extranet site.
Which three 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.
Correct Answer:
