Microsoft Advanced Solutions of Microsoft SharePoint Server 2013 - 70-332 Exam Practice Test
DRAG DROP
You need to meet the disaster recovery requirements.
What should you do? (To answer, drag the appropriate terms to the correct location or locations in the answer area.
Each term 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.)

You need to meet the disaster recovery requirements.
What should you do? (To answer, drag the appropriate terms to the correct location or locations in the answer area.
Each term 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.)

Correct Answer:

Note:
* From scenario:
/ Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the
disaster recovery site.
/ A hardware load-balancer is configured to balance traffic between PROD-WEB-01 and PROD-WEB-02. Both are
running SQL Server 2012.
/ The SharePoint 2013 Disaster Recovery farm topology consists of the servers listed in the following table.

/ Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the
disaster recovery site.
* SQL Server Log shipping allows you to automatically send transaction log backups from aprimary databaseon
aprimary serverinstance to one or moresecondary databaseson separatesecondary serverinstances. The transaction
log backups are applied to each of the secondary databases individually.
* Terms and Definitions
/ primary server
The instance of SQL Server that is your production server.
/ primary database
The database on the primary server that you want to back up to another server. All administration of the log shipping
configuration through SQL Server Management Studio is performed from the primary database.
/ secondary server The instance of SQL Server where you want to keep a warm standby copy of your primary
database.
/ secondary database The warm standby copy of the primary database. The secondary database may be in either the
RECOVERING state or the STANDBY state, which leaves the database available for limited read-only access.
You have a SharePoint Server 2013 server farm and a Microsoft Exchange Server 2013 organization.
You need to provide a compliance officer with the ability to locate content in both Exchange Server 2013 and
SharePoint Server 3013 based on keyword searches.
The compliance officer must be able to prevent the content from being deleted by users.
Which site template should you use?
You need to provide a compliance officer with the ability to locate content in both Exchange Server 2013 and
SharePoint Server 3013 based on keyword searches.
The compliance officer must be able to prevent the content from being deleted by users.
Which site template should you use?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
DRAG DROP
You manage a SharePoint farm.
The sales team would like to evaluate the Microsoft SQL Server 2012 Reporting Services (SSRS) Power View feature.
You need to install Reporting Services for SharePoint to support Power View.
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 manage a SharePoint farm.
The sales team would like to evaluate the Microsoft SQL Server 2012 Reporting Services (SSRS) Power View feature.
You need to install Reporting Services for SharePoint to support Power View.
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: Install and start the SSRS SharePoint service.
Box 2: Create an SSRS service application.
Box 3: Active the Power View site collection feature.
Note:
Step 1: Install Reporting Services Report Server in SharePoint mode
Step 2: Register and start the Reporting Services SharePoint Service
Step 3: Create a Reporting Services Service Application
Step 4: Activate the Power View Site Collection Feature.
Reference: Install Reporting Services SharePoint Mode for SharePoint 2013
Box 2: Create an SSRS service application.
Box 3: Active the Power View site collection feature.
Note:
Step 1: Install Reporting Services Report Server in SharePoint mode
Step 2: Register and start the Reporting Services SharePoint Service
Step 3: Create a Reporting Services Service Application
Step 4: Activate the Power View Site Collection Feature.
Reference: Install Reporting Services SharePoint Mode for SharePoint 2013
DRAG DROP
A SharePoint 2010 environment contains the site collections described in the following table.

You plan to migrate the environment to SharePoint 2013. You create a SharePoint 2013 site at the URL
http://testIntranet.contoso.com. You restore the database backups from the 2010 environment to the 2013
environment.
You test the migration plan by migrating the Intranet.Content database to the new site.
You need to verify that the test migration succeeds.
Which Windows PowerShell cmdlets should you run? (To answer, drag the appropriate cmdlets to the correct location
or locations in the answer area. Each cmdlet 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.)

A SharePoint 2010 environment contains the site collections described in the following table.

You plan to migrate the environment to SharePoint 2013. You create a SharePoint 2013 site at the URL
http://testIntranet.contoso.com. You restore the database backups from the 2010 environment to the 2013
environment.
You test the migration plan by migrating the Intranet.Content database to the new site.
You need to verify that the test migration succeeds.
Which Windows PowerShell cmdlets should you run? (To answer, drag the appropriate cmdlets to the correct location
or locations in the answer area. Each cmdlet 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.)

Correct Answer:

Note:
* Test -SPContentDatabase
Use the Test-SPContentDatabase cmdlet 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.
* The Mount-SPContentDatabase cmdlet attaches an existing content database to the farm. If the database being
mounted requires an upgrade, this cmdlet will cause the database to be upgraded.
Example:
ExAMPLE
Mount-SPContentDatabase "MyDatabase" -DatabaseServer "MyServer" -WebApplication http://sitename
This example mounts an existing database to the sitename web application. If upgrades are required, it triggers
database schema upgrade and then performs only build-to-build upgrade actions on existing site collections if
required.
DRAG DROP
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.)

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.)

Correct Answer:

Note:
* The content database should be placed on the database servers.
* The configuration database can replicated synchronously locally on the Seattle site.
* From scenario:
/ The databases must belong to a SQL Server AlwaysOn Availability Group and use the WAN connection for database
replication between the sites.
This implies an Asynchronous commit Commit Replica Type.
You are the administrator for a company's SharePoint environment.
All SharePoint installations must use SQL aliases.
You need to complete the configuration.
Which tool should you use?
All SharePoint installations must use SQL aliases.
You need to complete the configuration.
Which tool should you use?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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.)
Which two Windows PowerShell cmdlets should you run? (Each correct answer presents part of the solution. Choose
two.)
Correct Answer: C,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
DRAG DROP
You are the administrator of a company's SharePoint environment.
Company policy requires that social guidelines are established for new users of the SharePoint environment.
You need to implement Yammer.
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 the administrator of a company's SharePoint environment.
Company policy requires that social guidelines are established for new users of the SharePoint environment.
You need to implement Yammer.
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: Update SharePoint 2013 to Service Pack1.
Box 2: Disable default SharePoint 2013 social features.
Box 3: Install and configure Yammer Directory Sync.
Note:
* You can replace the Newsfeed link with a Yammer link on the top navigation bar for SharePoint. This functionality is
included in Service Pack 1 (SP1) for SharePoint Server.
* The new Yammer app for SharePoint lets you embed Yammer feeds into on-premises SharePoint Server 2013 sites
to make them more social and engaging. Before you can do that, you have to do the following steps:
Remove the Newsfeed Web Parts from My Sites and Team Sites.
Hide the user interface controls that provide social features.
Install the Yammer app for SharePoint.
Add the Yammer feeds to your sites.
* By using directory synchronization, your organization can use existing on-premises user accounts. Your organization
can also significantly reduce operational costs and give its employees safer and easier access to Yammer.
Reference: Hide SharePoint Server 2013 social features
https://technet.microsoft.com/en-us/library/dn659293.aspx
Integrate Yammer with on-premises SharePoint 2013 environments
https://technet.microsoft.com/en-us/library/dn270535.aspx
Box 2: Disable default SharePoint 2013 social features.
Box 3: Install and configure Yammer Directory Sync.
Note:
* You can replace the Newsfeed link with a Yammer link on the top navigation bar for SharePoint. This functionality is
included in Service Pack 1 (SP1) for SharePoint Server.
* The new Yammer app for SharePoint lets you embed Yammer feeds into on-premises SharePoint Server 2013 sites
to make them more social and engaging. Before you can do that, you have to do the following steps:
Remove the Newsfeed Web Parts from My Sites and Team Sites.
Hide the user interface controls that provide social features.
Install the Yammer app for SharePoint.
Add the Yammer feeds to your sites.
* By using directory synchronization, your organization can use existing on-premises user accounts. Your organization
can also significantly reduce operational costs and give its employees safer and easier access to Yammer.
Reference: Hide SharePoint Server 2013 social features
https://technet.microsoft.com/en-us/library/dn659293.aspx
Integrate Yammer with on-premises SharePoint 2013 environments
https://technet.microsoft.com/en-us/library/dn270535.aspx
You need to ensure that app developers have the necessary permission to submit apps for deployment.
Which permission level should you grant to the SharePoint_App_Dev group?
Which permission level should you grant to the SharePoint_App_Dev group?
Correct Answer: A
Vote an answer
You deploy SharePoint Server 2013.
You need to install a SharePoint hosted app named App1 in a site.
Which Windows PowerShell cmdlet should you run?
You need to install a SharePoint hosted app named App1 in a site.
Which Windows PowerShell cmdlet should you run?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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
You are the administrator for your company's SharePoint environment. Company policy requires that you use
Windows PowerShell to deploy farm solutions.
You need to deploy a SharePoint solution to the farm. The solution is named solution.wsp and is located at
c:\solution.wsp.
Which Windows PowerShell command should you run?
Windows PowerShell to deploy farm solutions.
You need to deploy a SharePoint solution to the farm. The solution is named solution.wsp and is located at
c:\solution.wsp.
Which Windows PowerShell command should you run?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).