Microsoft Advanced Solutions of Microsoft SharePoint Server 2013

QUESTION NO: 1
DRAG DROP
You have a SharePoint Server 2013 server farm that has the Excel Services Application service application deployed.
The farm uses a database server that has Microsoft SQL Server 2012 installed.
You need to implement PowerPivot for Excel Services in a basic configuration.
Which three actions should you perform in sequence? (To answer, move the appropriate three 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: Need to upgrade SQL server.
* Step 2: On the Setup Role page, select SQL Server PowerPivot for SharePoint. This option installs Analysis Services in
SharePoint mode.
Optionally, you can add an instance of the Database Engine to your installation. You might add the Database Engine
when setting up a new farm and need a database server to run the farm's configuration and content databases. This
option also installs SQL Server Management Studio.

* Step 3: Configure Excel Services for Analysis Services integration
In SharePoint Central Administration, in the Application Management group, click Manage Service Applications.
Click the name of your service application, the default is Excel Services Application.
On the Manage Excel Services Application page, click Data Model Settings.
Click Add Server.
In Server Name, type the Analysis Services server name and the PowerPivot instance name. For example
MyServer\POWERPIVOT. The PowerPivot instance name is required.
Type a description.
Click Ok.
Reference: PowerPivot for SharePoint 2013 Installation

QUESTION NO: 2
DRAG DROP
You plan to deploy a SharePoint Server 2013 server farm.
You need to recommend which methods must be used to back up the following components:
The Managed Metadata Service, including the associated proxy
The entire farm, including all of the data and all of the configurations
A single list only
Which backup method should you recommend for each component? (To answer, drag the appropriate backup
methods to the correct components. Each backup method 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:
* Service information:
At the Windows PowerShell command prompt, type the following command:
Backup-SPFarm -Directory <BackupFolder> -BackupMethod {Full | Differential} -Item <ServiceApplicationName> [-
Verbose]
Where:
<BackupFolder> is the path of a folder on the local computer or on the network in which you want to store the
backups.
<ServiceApplicationName> is the name of the service application that you want to back up. To display the name of the
service application, at the Windows PowerShell command prompt, type the following command: Backup-SPFarm -
ShowTree.
* Farm:
At the Windows PowerShell command prompt, type the following command:
Backup-SPFarm -Directory <BackupFolder> -BackupMethod {Full | Differential} [-Verbose]
* Single list:
At the Windows PowerShell command prompt, type the following command:
Export-SPWeb -Identity <SiteURL> -Path <Path and File Name> [-ItemUrl <URL of Site, List, or Library>] [-
IncludeUserSecurit
Where:
<SiteURL> is URL for the site, list, or library that you are exporting.
<Path and FileName> is path and name for the site, list, or library that you are exporting.
<URL of Site, List, or Library> is the URL for the site, list, or library where you are exporting.

QUESTION NO: 3
You have a SharePoint Server 2013 server farm named Farm1. Farm1 contains the following service applications:
Excel Services Application
Search Service Application
Managed Metadata Service
User Profile Service Application
You plan to deploy a new SharePoint Server 2013 server farm named Farm2. Farm2 must use the same service
applications as Farm1.
You plan to use as many services from Farm1 in Farm2 as possible.
You need to identify which service application must be created in Farm2.
Which service application should you identify?

A. Search Service Application B. Excel Services Application C. User Profile Service Application D. Managed Metadata Service

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
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?

A. Install-SPSolution and then run Add-SPSolution B. Import-SPAppPackage and then run Install-SPApp C. Install-SPAppPackage and then run Import-SPApp D. Add-SPSolution and then run Install-SPSolution

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
A company has two SharePoint farms as described in the following table.

You need to process incoming server requests on HRFarm that originate from FinanceFarm.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A. Configure both farms to use Secure Sockets Layer (SSL) connections. B. Run the Windows PowerShell cmdlet Get-SPTrustedSecurityTokenIssuer -Identity FarmA on a server in FarmA. C. Run the Windows PowerShell cmdlet New-SPTrustedSecurityTokenIssuer on a server in Farm D. Run the Windows PowerShell cmdlet New-SPTrustedSecurityTokenIssuer on a server in HRFarm. E. Log on as a member of the Administrators group on a server in FarmA.

Correct Answer: A,D,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
===========================
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?

A. Multiple disks individually attached via iSCSI B. Multiple disks configured in a RAID 0 array C. Multiple disks individually attached via Fibre Channel D. Multiple disks configured in a RAID 10 array E. Multiple disks configured in a RAID 5 array

Correct Answer: D

QUESTION NO: 7
HOTSPOT
You have a SharePoint Server 2013 server farm and a Microsoft Exchange Server 2013 organization.
The User Profile Service Application is provisioned and configured.
You need to ensure that when users navigate to their personal site, they can see their tasks from Exchange Server
2013 and from SharePoint Server 2013.
Which service application should you deploy? (To answer, select the appropriate service application in the answer
area.)

Correct Answer:

Explanation: Work Management Service Application
The Work Management Service Application provides functionality to aggregate tasks to a central location on
SharePoint Server:
Users get the possibility to view and track their to-dos and tasks.
Tasks can be cached to a users personal site.
Tasks can sync to Outlook where users can edit them wherever they have access to Outlook.
Tasks can be aggregated from Exchange, Project Server and SharePoint.
Based on 'Provider model' so that other systems can be integrated in the future.

QUESTION NO: 8
You are configuring a SharePoint farm.
You have the following requirements:
Implement an enterprise resource pool.
Enable tasks to be assigned to users.
Implement a resource breakdown structure.
You need to implement a solution that meets the requirements.
What should you do?

A. Provision a Microsoft Project web app. B. Create a SharePoint task list. C. Import a Microsoft Excel spreadsheet as a custom list. D. Create a collaboration portal.

Correct Answer: A

QUESTION NO: 9
DRAG DROP
You are planning to install an instance of Microsoft SQL Server for a SharePoint 2013 farm.
You have the following requirements:
Ensure that databases can be redirected to other servers.
Minimize potential security threats.
You need to install and configure the instance.
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: Create a named instance of SQL Server.
Box 2: Configure the instance to use a custom port.
Box 3: Create a SQL Server alias and configure the farm to use the alias.
Note:
* To harden the security for SQL server it is highly recommend to install SQL Server with named instance with custom
port and block all default SQL specific ports.
* After the installation of SQL Server with named instance, we have to assign a custom static port number for the SQL
Service.
* After the SQL installation we go to the SharePoint side.
We have to configure the SQL Client Alias.
Reference: Install & Configure SharePoint 2013 with SQL Client Alias

QUESTION NO: 10
You are creating a SharePoint site that will be accessed from the following devices:
Client computers
Windows Phone devices
Windows 8 RT devices
You need to optimize the SharePoint experience for the listed devices.
What should you configure?

A. Variations B. Device channels C. Image renditions D. Custom list views E. Design Manager

Correct Answer: B

QUESTION NO: 11
DRAG DROP
You have a custom solution named SalesSolution deployed to the URL http://site.contoso.com/sites/sales.
You need to deploy a new version of the solution without retracting the previous version.
How should you complete the Windows PowerShell cmdlet? (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:
*(box 1) The Update-SPSolutioncmdlet upgrades a deployed SharePoint solution in the farm. Use this cmdlet only if a
new solution contains the same set of files and features as the deployed solution.
Syntax:
Update-SPSolution [-Identity] <SPSolutionPipeBind> -LiteralPath<String> [-
AssignmentCollection<SPAssignmentCollection>] [-CASPolicies<SwitchParameter>] [-Confirm [<SwitchParameter>]] [-
Force <SwitchParameter>] [-FullTrustBinDeployment<SwitchParameter>] [-GACDeployment<SwitchParameter>] [-
Local <SwitchParameter>] [-Time <String>] [-WhatIf [<SwitchParameter>]]
*(box 2) Identity Required
Specifies the SharePoint solution to deploy.
* (box 3)
LiteralPathRequired
Specifies the path to the solution package.
The type must be a valid path in either of the following forms:
-C:\folder_name
-\\server_name\folder_name

QUESTION NO: 12
You are the administrator for your company's SharePoint environment. You are configuring a site collection to prepare
for an upgrade to SharePoint Server 2013.
You need to ensure that no updates are allowed to an individual site collection.
What should you do?

A. In Central Administration, set the state of the site lock status to No access. B. In Central Administration, set the state of the site lock status to Read-only. C. In Central Administration, set the state of the site lock status to Adding Content prevented. D. In SQL Server, set the content database to read-only.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 13
DRAG DROP
You need to meet the content access requirements during the upgrade process.
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:

Box 1: SQL Server Management Studio
Box 2: State
Box 3: True
Box 4: Content
Note:
* From scenario:
/ All content databases within the production farm must be set to read-only when patching and upgrading the farm.
* SQL Server Management Studio (ssms) is a software application first launched with the Microsoft SQL Server 2005
that is used for configuring, managing, and administering all components within Microsoft SQL Server.
* A farm is considered read-only if one of the following is true:
All content databases are set to read-only.
Service application databases are set to read-only.
* To set content databases to read-only by using SQL Server
Verify that the user account that is performing this procedure is a member of the db_owner fixed database role in
each database.
Start SQL Server Management Studio.
Right-click the content database that you want to make read-only, and then click Properties.
Select the Options page, and, in the Other options list, scroll to the State section.
In the Database Read-Only row, click the arrow next to False, select True, and then click OK.
Repeat for all other content databases.
Reference: Run a farm that uses read-only databases in SharePoint 2013

QUESTION NO: 14
You need to configure Excel Services.
What should you do?

A. Add a trusted data connection library to the Tailspin360 site. B. Add a trusted file location to the Tailspin360 site. C. Add each user as a Contributor. D. Add each user as a Viewer.

Correct Answer: B

QUESTION NO: 15
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.

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

Microsoft Advanced Solutions of Microsoft SharePoint Server 2013 - 070-332 Exam Questions