Microsoft Advanced Solutions of Microsoft SharePoint Server 2013 - 070-332 Exam Practice Test
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.
A company uses a data-connected Microsoft Excel workbook to build reports from external data sources.
Data is not refreshed when the workbook is displayed in a browser.
You need to ensure that users can refresh Excel workbooks that are displayed in a browser.
Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)
Data is not refreshed when the workbook is displayed in a browser.
You need to ensure that users can refresh Excel workbooks that are displayed in a browser.
Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)
Correct Answer: B,D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
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: D
HOTSPOT
You are designing a SharePoint search solution.
The search solution must meet the following requirements:
Run search queries against specific SharePoint columns.
Run search queries against specific document properties.
You need to ensure the search solution meets the requirements.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
You are designing a SharePoint search solution.
The search solution must meet the following requirements:
Run search queries against specific SharePoint columns.
Run search queries against specific document properties.
You need to ensure the search solution meets the requirements.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
Correct Answer:
Note:
* To include the content and metadata of crawled properties in the search index, you map crawled properties to
managed properties.
* A crawled property is content and metadata that is extracted from an item, such as a document or a URL, during a
crawl. A crawled property can be an author, title, or subject. To include the content and metadata of crawled
properties in the search index, you map crawled properties to managed properties. Managed properties can have a
large number of settings, or attributes. These attributes determine how the contents are shown in search results. The
search schema contains the attributes on managed properties and the mapping between crawled properties and
managed properties.
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: B,C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
DRAG DROP
You need to configure authentication for the Tailspin360.TailspinToys.com 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 need to configure authentication for the Tailspin360.TailspinToys.com 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:
Box 1:
Box 2:
Box 3:
Note:
* Step 1:
/ Target Application Type. By default, SharePoint Online uses type Group Restricted.
/ In the Members section, enter a list of users or SharePoint Online groups of users who need to access the target
application. Or, you can use the Browse button to search for the name of a group that you want to map to the Target
Application.
* Step 2:
In the Credential Fields section, enter the Field Names and Field Types for the credentials that are required to access
data in the Target Application. These fields determine how you will map identity in the Secure Store Service. By
default, the Credential Fields list the Windows User Name and Windows Password with matching Field Types (User
Name and Password), and specifies that the password is masked.
* Step 3:
If you are using Excel Services, use the procedures in this section to complete the necessary configuration steps.
If the Unattended Service Account has not already been configured for Excel Services, follow these steps to configure
it.
To configure the Unattended Service Account
On the SharePoint Central Administration home page, under Application Management, click Manage Service
Applications.
Click the Excel Services service application.
Click Global Settings.
In the External Data section, choose the Use an existing Unattended Service Account option, and then type the name
of the target application that you created for the Unattended Service Account in the Target Application ID text box.
Click OK.
* From scenario:
/ The site must be accessible only to members of the Sales team.
/ The salesAccess shared domain account has permissions to read data from the database.
/ Excel workbooks published to a document library app must be opened in a browser. Excel workbooks in other
locations must open in Excel.
* The Secure Store Service is designed to create a background mapping between a group of users in SharePoint, and a
single user known to the external data system. When the Secure Store Service is properly configured, the following
occurs:
* A user authenticates through Internet Information Services (the web server technology underlying SharePoint
technologies) to SharePoint Online via valid credentials.
* Inside SharePoint Online, the Secure Store Service uses mapped credentials known to the external business
application to render any necessary external data on the site for the authenticated user.
Reference: Create or edit a Secure Store Target Application
Box 2:
Box 3:
Note:
* Step 1:
/ Target Application Type. By default, SharePoint Online uses type Group Restricted.
/ In the Members section, enter a list of users or SharePoint Online groups of users who need to access the target
application. Or, you can use the Browse button to search for the name of a group that you want to map to the Target
Application.
* Step 2:
In the Credential Fields section, enter the Field Names and Field Types for the credentials that are required to access
data in the Target Application. These fields determine how you will map identity in the Secure Store Service. By
default, the Credential Fields list the Windows User Name and Windows Password with matching Field Types (User
Name and Password), and specifies that the password is masked.
* Step 3:
If you are using Excel Services, use the procedures in this section to complete the necessary configuration steps.
If the Unattended Service Account has not already been configured for Excel Services, follow these steps to configure
it.
To configure the Unattended Service Account
On the SharePoint Central Administration home page, under Application Management, click Manage Service
Applications.
Click the Excel Services service application.
Click Global Settings.
In the External Data section, choose the Use an existing Unattended Service Account option, and then type the name
of the target application that you created for the Unattended Service Account in the Target Application ID text box.
Click OK.
* From scenario:
/ The site must be accessible only to members of the Sales team.
/ The salesAccess shared domain account has permissions to read data from the database.
/ Excel workbooks published to a document library app must be opened in a browser. Excel workbooks in other
locations must open in Excel.
* The Secure Store Service is designed to create a background mapping between a group of users in SharePoint, and a
single user known to the external data system. When the Secure Store Service is properly configured, the following
occurs:
* A user authenticates through Internet Information Services (the web server technology underlying SharePoint
technologies) to SharePoint Online via valid credentials.
* Inside SharePoint Online, the Secure Store Service uses mapped credentials known to the external business
application to render any necessary external data on the site for the authenticated user.
Reference: Create or edit a Secure Store Target Application
===========================
Case Study: 3
Baldwin Museum of Science
Background
Baldwin Museum of Science has an Active Directory Domain Services (AD DS) domain named
BaldwinMuseumOfScience.com.
The domain has a SharePoint environment that contains two farms named ContentFarm and SearchFarm.
ContentFarm includes content and collaboration tools. A custom app named Time Entry is deployed to the
App Store on ContentFarm. ContentFarm includes a site collection named HR.
You are planning for a major content and configuration update to the term store in the managed metadata
service application that is located on ContentFarm.
SearchFarm is reserved for crawling content and responding to search queries.
ContentFarm Topology
The topology of ContentFarm is shown in the following table.
ContentFarm has the following characteristics:
Primary content for the farm is available at the URL
*
SharePoint.BaldwinMuseumOfScience.com.
Requests for content from the farm are load-balanced between SPC-WEB01 and
*
SPC-WEB02.
The servers that run Microsoft SQL Server are members of an active/passive cluster
*
that run a failover cluster named SP-SQL01.
MySites sites for each user are hosted on a separate web application available at the
*
URL my.baldwinmuseumofscience.com.
Requests for MySites pages are load-balanced between SPC-WEB01 and SPC-
*
WEB02.
A full backup of the farm is performed once a week.
*
An incremental backup of the farm is performed once a day.
*
The Site Owner of the HR site collection requires that the HR Site Collection be
*
backed up in full on a daily basis.
The managed metadata, user profile, and BCS service applications are enabled in the
*
farm.
All members of the SharePoint developer team belong to an AD DS security group
*
named SharePoint_App_Dev.
SearchFarm Topology
The topology of SearchFarm is shown in the following table.
SearchFarm has the following characteristics:
The farm currently uses SPS-DB01 as its primary database instance.
*
SPS-DB01 has experienced multiple hard drive failures in the last month.
*
The identity of the search service application is not documented.
*
Technical Requirements
The following requirements must be met for ContentFarm and SearchFarm:
All administrative activities must be performed by using Windows PowerShell.
*
Custom applications created by using the SharePoint app model must be deployed to,
*
and hosted in, an internal App Store.
Site owners must not be able to directly purchase third-party apps from the public
*
SharePoint Store.
Members of the SharePoint_App AD DS security group must have the ability to
*
submit new apps and app updates to the App Store of ContentFarm.
Members of the SharePoint_App_Dev AD DS security group must not be granted
*
farm administrator rights in ContentFarm.
The Time Entry app must remain available to users at all times.
*
The contents of ContentFarm must be indexed by the Search service application of
*
SearchFarm.
All responses to queries submitted by users in ContentFarm must be served by the
*
Search service application of SearchFarm.
The database resources for SearchFarm must be configured to be highly available by
*
using SQL Server database mirroring with automatic failover.
MySite content databases must be moved to a separate clustered database instance.
*
The new clustered database instance must be created by using existing database
servers in ContentFarm.
All storage resources for both farms must be redundant and provide high
*
performance for both read and write operations and support disk mirroring.
A snapshot of the current state of the managed metadata service application must be
*
taken before the service application receives the planned major update.
===========================
You need to configure SPS-DB01.
Which type of storage solution should you implement?
Case Study: 3
Baldwin Museum of Science
Background
Baldwin Museum of Science has an Active Directory Domain Services (AD DS) domain named
BaldwinMuseumOfScience.com.
The domain has a SharePoint environment that contains two farms named ContentFarm and SearchFarm.
ContentFarm includes content and collaboration tools. A custom app named Time Entry is deployed to the
App Store on ContentFarm. ContentFarm includes a site collection named HR.
You are planning for a major content and configuration update to the term store in the managed metadata
service application that is located on ContentFarm.
SearchFarm is reserved for crawling content and responding to search queries.
ContentFarm Topology
The topology of ContentFarm is shown in the following table.
ContentFarm has the following characteristics:
Primary content for the farm is available at the URL
*
SharePoint.BaldwinMuseumOfScience.com.
Requests for content from the farm are load-balanced between SPC-WEB01 and
*
SPC-WEB02.
The servers that run Microsoft SQL Server are members of an active/passive cluster
*
that run a failover cluster named SP-SQL01.
MySites sites for each user are hosted on a separate web application available at the
*
URL my.baldwinmuseumofscience.com.
Requests for MySites pages are load-balanced between SPC-WEB01 and SPC-
*
WEB02.
A full backup of the farm is performed once a week.
*
An incremental backup of the farm is performed once a day.
*
The Site Owner of the HR site collection requires that the HR Site Collection be
*
backed up in full on a daily basis.
The managed metadata, user profile, and BCS service applications are enabled in the
*
farm.
All members of the SharePoint developer team belong to an AD DS security group
*
named SharePoint_App_Dev.
SearchFarm Topology
The topology of SearchFarm is shown in the following table.
SearchFarm has the following characteristics:
The farm currently uses SPS-DB01 as its primary database instance.
*
SPS-DB01 has experienced multiple hard drive failures in the last month.
*
The identity of the search service application is not documented.
*
Technical Requirements
The following requirements must be met for ContentFarm and SearchFarm:
All administrative activities must be performed by using Windows PowerShell.
*
Custom applications created by using the SharePoint app model must be deployed to,
*
and hosted in, an internal App Store.
Site owners must not be able to directly purchase third-party apps from the public
*
SharePoint Store.
Members of the SharePoint_App AD DS security group must have the ability to
*
submit new apps and app updates to the App Store of ContentFarm.
Members of the SharePoint_App_Dev AD DS security group must not be granted
*
farm administrator rights in ContentFarm.
The Time Entry app must remain available to users at all times.
*
The contents of ContentFarm must be indexed by the Search service application of
*
SearchFarm.
All responses to queries submitted by users in ContentFarm must be served by the
*
Search service application of SearchFarm.
The database resources for SearchFarm must be configured to be highly available by
*
using SQL Server database mirroring with automatic failover.
MySite content databases must be moved to a separate clustered database instance.
*
The new clustered database instance must be created by using existing database
servers in ContentFarm.
All storage resources for both farms must be redundant and provide high
*
performance for both read and write operations and support disk mirroring.
A snapshot of the current state of the managed metadata service application must be
*
taken before the service application receives the planned major update.
===========================
You need to configure SPS-DB01.
Which type of storage solution should you implement?
Correct Answer: C
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
HOTSPOT
You are a SharePoint administrator at Litware, Inc. A Business Data Connectivity service application has recently been
deployed.
Users report that they cannot create external lists that contain the external content types, and they receive the
following error message when they try to open existing external lists: "Access Denied by Business Data Connectivity".
You need to configure the minimum permissions required so that users can create external lists and read data in
external lists.
On the Set Object Permissions page, which permissions should you select? (To answer, select the appropriate
permissions in the answer area.)
You are a SharePoint administrator at Litware, Inc. A Business Data Connectivity service application has recently been
deployed.
Users report that they cannot create external lists that contain the external content types, and they receive the
following error message when they try to open existing external lists: "Access Denied by Business Data Connectivity".
You need to configure the minimum permissions required so that users can create external lists and read data in
external lists.
On the Set Object Permissions page, which permissions should you select? (To answer, select the appropriate
permissions in the answer area.)
Correct Answer:
A company plans to use eDiscovery in SharePoint. The environment includes Microsoft Lync Server 2013 and
Microsoft Exchange Server 2013. Lync Server is configured to archive conversations to Exchange Server. You configure
Exchange Server for eDiscovery.
You need to complete the eDiscovery configuration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
Microsoft Exchange Server 2013. Lync Server is configured to archive conversations to Exchange Server. You configure
Exchange Server for eDiscovery.
You need to complete the eDiscovery configuration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
Correct Answer: C,D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You are moving a customized SharePoint site collection to a new farm. You attach and mount the source content
database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
Correct Answer: A
An organization has a SharePoint environment that contains the following three farms:
Farm1 has a Search service application that is configured to crawl all SharePoint sites in Farm1.
Farm2 has a Search service application that is configured to crawl all SharePoint sites in Farm2 and Farm3.
Farm3 does not have a Search service application.
You need to plan for eDiscovery so that you can discover all SharePoint site content in the environment.
Where should you place the eDiscovery Center or Centers?
Farm1 has a Search service application that is configured to crawl all SharePoint sites in Farm1.
Farm2 has a Search service application that is configured to crawl all SharePoint sites in Farm2 and Farm3.
Farm3 does not have a Search service application.
You need to plan for eDiscovery so that you can discover all SharePoint site content in the environment.
Where should you place the eDiscovery Center or Centers?
Correct Answer: A