Microsoft Advanced Solutions of Microsoft SharePoint Server 2013 (070-332) Free Practice Test
Question 1
HOTSPOT
You have a SharePoint Server 2013 server farm.
You discover that many site collection administrators deploy a solution named Soil that contains a feature named
Feature1. The administrators do not have farm administrator rights.
You discover that Feature1 has a memory leak.
You need to prevent Feature1 from being used in the farm.
Which link should you use? (To answer, select the appropriate link in the answer area.)

You have a SharePoint Server 2013 server farm.
You discover that many site collection administrators deploy a solution named Soil that contains a feature named
Feature1. The administrators do not have farm administrator rights.
You discover that Feature1 has a memory leak.
You need to prevent Feature1 from being used in the farm.
Which link should you use? (To answer, select the appropriate link in the answer area.)

Correct Answer:

Note:
Manage User solutions
The administrator can control blocked solutions and load balancing by selecting System Settings\Manage User
Solutions. On this page, the farm administrator can browse to solution packages that should be blocked and add them
to the blocked list. Blocked solutions are not allowed to execute on the farm.
Question 2
DRAG DROP
You need to design the architecture of the farm.
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 design the architecture of the farm.
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:
The farm must be made fault tolerant by using virtualization.
The farm must include two front-end web servers.
All content must remain available to users if one of the front-end web servers becomes unavailable. (Not put them on
the same Hyper-V host)
Page requests must be distributed equally across the front-end web servers.
All customer, order, and product information will be stored in tables in a Microsoft SQL Server database.
Need to use Microsoft SQL Server.
Question 3
HOTSPOT
A company uses SharePoint Server to manage document templates. Each department stores its templates in a
department-specific site collection.
All templates use a content type named Corporate Templates. Templates are stored in document library apps with
other types of files.
The Search service application must meet the following requirements:
Users can search from a single location across all department site collections.
Search results include content from all site collections that contain templates.
You need to configure the Search service application to meet the requirements.
On the Search Administration page, which search feature should you configure? (To answer, select the appropriate
feature in the answer area.)

A company uses SharePoint Server to manage document templates. Each department stores its templates in a
department-specific site collection.
All templates use a content type named Corporate Templates. Templates are stored in document library apps with
other types of files.
The Search service application must meet the following requirements:
Users can search from a single location across all department site collections.
Search results include content from all site collections that contain templates.
You need to configure the Search service application to meet the requirements.
On the Search Administration page, which search feature should you configure? (To answer, select the appropriate
feature in the answer area.)

Correct Answer:

Question 4
DRAG DROP
A company plans to upgrade from a SharePoint Server 2010 farm to a SharePoint Server 2013 farm.
You plan to install components that are required on the new farm before upgrading.
You need to identify the customizations that must be installed on the new farm.
Which command should you run? (To answer, drag the appropriate command and switch to the correct locations in
the answer area.)

A company plans to upgrade from a SharePoint Server 2010 farm to a SharePoint Server 2013 farm.
You plan to install components that are required on the new farm before upgrading.
You need to identify the customizations that must be installed on the new farm.
Which command should you run? (To answer, drag the appropriate command and switch to the correct locations in
the answer area.)

Correct Answer:

Note:
Identify all server-side customizations and install them before you upgrade
One common error during upgrade is missing server-side files - either files that were installed with SharePoint 2010
Products or customized files. When you prepared for upgrade, you should have created an inventory of the server-
side customizations (such as site definitions, templates, features, Web Parts, assemblies) that your sites required.
Check this inventory to make sure that all the files that are needed for your customizations are installed in your new
environment.
You can use the enumallwebs operation in Stsadm.exe to identify server-side customizations that are being used.
Question 5
You are configuring a SharePoint farm in an environment that includes Microsoft Exchange Server 2013.
You need to ensure that specified SharePoint users can search the Exchange mailboxes of all employees, place holds
on mailbox data, and export mailbox data.
What should you do first?
You need to ensure that specified SharePoint users can search the Exchange mailboxes of all employees, place holds
on mailbox data, and export mailbox data.
What should you do first?
Correct Answer: D
Question 6
You plan to deploy a SharePoint Server 2013 server farm.
The sales department uses Microsoft Office documents to track sales leads.
You need to recommend a solution to ensure that users use the co-authoring functionality in SharePoint Server 2013
to collaborate on Office documents.
What should you include in the recommendation?
The sales department uses Microsoft Office documents to track sales leads.
You need to recommend a solution to ensure that users use the co-authoring functionality in SharePoint Server 2013
to collaborate on Office documents.
What should you include in the recommendation?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 7
A company uses SharePoint Online. The company has implemented eDiscovery.
You create a security group named eDiscovery.
You need to ensure that users in the eDiscovery group can view all discoverable content.
What should you do?
You create a security group named eDiscovery.
You need to ensure that users in the eDiscovery group can view all discoverable content.
What should you do?
Correct Answer: B
Question 8
DRAG DROP
A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The company uses a
third-party application to process payroll data and view payroll reports. The third-party application uses SQL
Authentication. Payroll administrators currently use custom credentials to sign in to the payroll application.
You have the following requirements:
Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports from within
SharePoint.
Payroll administrators must not be required to enter credentials when accessing payroll data.
The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
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.)

A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The company uses a
third-party application to process payroll data and view payroll reports. The third-party application uses SQL
Authentication. Payroll administrators currently use custom credentials to sign in to the payroll application.
You have the following requirements:
Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports from within
SharePoint.
Payroll administrators must not be required to enter credentials when accessing payroll data.
The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
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: Register a managed account to run the Secure Store application pool.
Box 2: Create a Secure Store service application instance, and start the Secure Store Service on servers within the
farm.
Box 3: Generate a new key for your Secure Store service application.
Box 4: Store credentials in Secure Store by using a Secure Store target application.
Note:
* To configure Secure Store, you perform the following steps:
(step 1)
Register a managed account in SharePoint Server 2013 to run the Secure Store application pool.
(step 2)
Start the Secure Store Service on an application server in the farm.
Create a Secure Store Service service application.
* (step 3)
Before using the Secure Store Service, you must generate an encryption key. The key is used to encrypt and decrypt
the credentials that are stored in the Secure Store Service database.
* (Step 4)
Storing credentials in Secure Store is accomplished by using a Secure Storetarget application.
Reference: Configure the Secure Store Service in SharePoint 2013
Box 2: Create a Secure Store service application instance, and start the Secure Store Service on servers within the
farm.
Box 3: Generate a new key for your Secure Store service application.
Box 4: Store credentials in Secure Store by using a Secure Store target application.
Note:
* To configure Secure Store, you perform the following steps:
(step 1)
Register a managed account in SharePoint Server 2013 to run the Secure Store application pool.
(step 2)
Start the Secure Store Service on an application server in the farm.
Create a Secure Store Service service application.
* (step 3)
Before using the Secure Store Service, you must generate an encryption key. The key is used to encrypt and decrypt
the credentials that are stored in the Secure Store Service database.
* (Step 4)
Storing credentials in Secure Store is accomplished by using a Secure Storetarget application.
Reference: Configure the Secure Store Service in SharePoint 2013
Question 9
DRAG DROP
An organization plans to install apps in its production SharePoint environment hosted at sharepoint.contoso.com.
The services necessary to host and enable apps have not been configured.
You need to configure the environment to host SharePoint apps.
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.)

An organization plans to install apps in its production SharePoint environment hosted at sharepoint.contoso.com.
The services necessary to host and enable apps have not been configured.
You need to configure the environment to host SharePoint apps.
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:
*
To create a wildcard Alias (CNAME) record for the new domain name
Verify that the user account that performs this procedure is a local administrator on the domain controller.
In DNS Manager, under Forward Lookup Zones, right-click the new app domain name, and then click New Alias
(CNAME). (box 1)
In the New Resource Record dialog box, in the Alias name (uses parent domain if left blank) box, type *.
The Fully qualified domain name (FQDN) box displays *. followed by the domain name that you created for apps. For
example, *.ContosoApps.com or *.Contoso-Apps.com. (box 2)
Next to the Fully qualified domain name (FQDN) for target host box, type the FQDN of the server that hosts the
SharePoint sites. (box 3)
* Overview of how to configure an environment for apps for SharePoint

* SharePoint-hosted apps for SharePoint are installed on a SharePoint 2013 website, called the host web, and that
have their resources hosted on an isolated subsite of a host web, called the app web. This approach enables you to
reuse common SharePoint artifacts, such as lists and Web Parts. When you take this approach, you can use only
JavaScript and you cannot use any server-side code.
Reference: Configure an environment for apps for SharePoint (SharePoint 2013)

Box 2:

Box 3:

Note:
*
To create a wildcard Alias (CNAME) record for the new domain name
Verify that the user account that performs this procedure is a local administrator on the domain controller.
In DNS Manager, under Forward Lookup Zones, right-click the new app domain name, and then click New Alias
(CNAME). (box 1)
In the New Resource Record dialog box, in the Alias name (uses parent domain if left blank) box, type *.
The Fully qualified domain name (FQDN) box displays *. followed by the domain name that you created for apps. For
example, *.ContosoApps.com or *.Contoso-Apps.com. (box 2)
Next to the Fully qualified domain name (FQDN) for target host box, type the FQDN of the server that hosts the
SharePoint sites. (box 3)
* Overview of how to configure an environment for apps for SharePoint

* SharePoint-hosted apps for SharePoint are installed on a SharePoint 2013 website, called the host web, and that
have their resources hosted on an isolated subsite of a host web, called the app web. This approach enables you to
reuse common SharePoint artifacts, such as lists and Web Parts. When you take this approach, you can use only
JavaScript and you cannot use any server-side code.
Reference: Configure an environment for apps for SharePoint (SharePoint 2013)
Question 10
You need to meet the technical requirements for failover.
What should you do?
What should you do?
Correct Answer: A
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: A
Question 12
DRAG DROP
You are preparing to upgrade from a SharePoint 2010 environment to a SharePoint 2013 environment.
The SharePoint 2010 environment includes a large number of content databases. You restore backups of the content
databases to the Microsoft SQL Server instance in the SharePoint 2013 environment.
You need to upgrade all content databases and minimize monitoring 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 are preparing to upgrade from a SharePoint 2010 environment to a SharePoint 2013 environment.
The SharePoint 2010 environment includes a large number of content databases. You restore backups of the content
databases to the Microsoft SQL Server instance in the SharePoint 2013 environment.
You need to upgrade all content databases and minimize monitoring 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:
* To attach a content database to a web application by using Windows PowerShell
Start the SharePoint 2013 Management Shell.
At the Windows PowerShell command prompt, type the following command and then press ENTER:
Mount-SPContentDatabase -Name DatabaseName -DatabaseServerServerName -WebApplication URL
* Attach the remaining databases (no need to wait until first command finishes and use new instance)
After you restore the first content database and verify success, you can continue to restore and upgrade other
databases. You can perform parallel database attach upgrades to upgrade more than one database at a time. Use
separate Command Prompt windows (i.e new instance) to run multiple upgrades. It is recommended that you
separate the start time for each new database upgrade session by several minutes to prevent issues with temporary
locks set for the web application during attachment. Otherwise you might receive an error on the upgrade session.
The wait time to clear temporary locks varies depending on the number of site collections, or the speed of the
database server hardware.
Reference: Upgrade content databases to SharePoint