70-332 149(Questions) Advanced Solutions of Microsoft SharePoint Server 2013

Which link should you use?

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.)
Hot Area:




Answer Clike
What should you identify?

DRAG DROP
You plan to deploy SharePoint Server 2013 to your enterprise organization’s multi-farm configuration.
A dedicated enterprise services farm will be created to host shared service applications. Two collaboration farms will be created to host collaboration sites.
All users must be able to perform the following tasks:
• Aggregate tasks from different site collections.
• Automatically translate pages to different languages.
• Classify documents by using an enterprise taxonomy.
• View Microsoft Excel files rendered in the web browser of the users.
You need to identify which service applications to deploy to each farm.
What should you identify? (To answer, drag the appropriate service applications to the correct farms. Each service application 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.)
Select and Place:




Answer Clike
What should you use?

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?
A. Design Manager
B. Asset Manager
C. SharePoint channels
D. Master Page conversion


Answer Clike
What is the minimum number of servers required for the deployment?

You plan to deploy a SharePoint Server 2013 server farm.
You identify the following requirements:
• The farm must be available if a single server fails.
• The farm must support the creation of service applications.
• All search components must be available if a single server fails.
• Microsoft SQL Server database and SharePoint Server 2013 must not be deployed to the same servers.
What is the minimum number of servers required for the deployment?
A. 2
B. 3
C. 4
D. 0


Answer Clike
Which Windows PowerShell cmdlet should you run?

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. Add-SPSolution and then run Install-SPSolution
D. Install-SPAppPackage and then run Import-SPApp


Answer Clike
Which feature should you enable in Microsoft SQL Server?

You recently upgraded a SharePoint Server 2010 server farm to SharePoint Server 2013. The farm contains many sites. The sites contain frequently updated content.
You need to ensure that users can perform demo upgrades of the sites. The solution must minimize the impact on the users.
Which feature should you enable in Microsoft SQL Server?
A. Database mirroring
B. Log shipping
C. AlwaysOn Availability Groups
D. Snapshot


Answer Clike
Which commit type should you recommend for each replica?

HOTSPOT
You are planning the deployment of a SharePoint Server 2013 server farm.
You plan to deploy Microsoft SQL Server 2012 AlwaysOn Availability Groups. The groups will have four replicas configured as shown in the following table.


You need to recommend which mode of commit must be used for each replica.
Which commit type should you recommend for each replica? (To answer, select the appropriate options in the answer area.)
Hot Area:




Answer Clike
HOTSPOT

HOTSPOT
You plan to deploy a SharePoint Server 2013 server farm.
The president of your company sends you the following email message regarding the planned deployment: ‘Our company loses an average of $5,000 per minute during service outages. At that rate, $300,000 per hour is a major cost to the company and should be reduced or eliminated. The company must provide continuity for IT services.”
The director of IT services sends you the following email message regarding the planned deployment: The company plans to implement the following as part of the deployment:
• Load balance all of the Web servers.
• Perform daily and hourly backups of all data.
• Centralize all of the service applications on a single server.
• Provide redundancy for all of the network components, such as switches and routers.”
The director of IT services identifies the following requirements for the planned deployment:
• Four front-end Web servers
• One database server that will host all of the farm databases and will be replicated to another database server by using log shipping
• One dedicated application server that will host all of the service applications, including the Search Service Application and all of the search components.
Select Yes if the statement can be shown to be true based on the available information; otherwise select No.
Hot Area:




Answer Clike
Which node should you perform the configuration?

HOTSPOT
You have a SharePoint Server 2013 server farm that uses a Microsoft SQL Server 2012 database server.
You need to automate the backup of the content databases.
From which node should you perform the configuration? (To answer, select the appropriate node in the answer area.)
Hot Area:




Answer Clike
Which site template should you use?

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?
A. Document Center
B. Records Center
C. eDiscovery Center
D. Enterprise Search Center


Answer Clike
What should you include in the recommendation?

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?
A. The App Management Service
B. OneNote Web App
C. Word Automation Services
D. The Work Management Service


Answer Clike
Which tool should you recommend?

DRAG DROP
You plan to create two external content types named ECT1 and ECT2. ECT1 will retrieve data from a database hosted on a Microsoft SQL Server server. ECT2 will retrieve data from a database hosted on an Oracle server. ECT1 and ECT2 will be deployed at the server farm-level.
You need to recommend a tool to create the external content types. The solution must minimize development effort.
Which tool should you recommend? (To answer, drag the appropriate tools to the correct external content types. Each tool 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.)
Select and Place:




Answer Clike
Which service application should you identify?

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. User Profile Service Application
C. Managed Metadata Service
D. Excel Services Application


Answer Clike
What should you add?

You have a ShafePoint Server 2013 server farm that has Excel Web Services deployed. A user has a Microsoft Excel spreadsheet that uses a dynamic-link library
(DLL) to perform custom calculations.
The user plans to upload the spreadsheet to the farm.
You need to ensure that when the spreadsheet is rendered by Excel Web Services, the custom calculations are performed.
What should you add?
A. A new trust relationship
B. The DLL to the global assembly cache
C. A trusted data provider
D. A user-defined function assembly


Answer Clike
What should you do?

You recently upgraded from SharePoint Server 2010 to SharePoint Server 2013.
You have not upgraded any site collections.
You have a site collection that contains an InfoPath form library. The InfoPath form library has a content type named CT1.
You need to verify whether CT1 will conflict with any of the content types in SharePoint Server 2013.
What should you do?
A. From Site Settings, navigate to Site collection upgrade.
B. Run the Test-SPContentDatabasecmdlet.
C. From Site Settings, navigate to Site collection health checks.
D. From Site Settings, navigate to Content type publishing.


Answer Clike
Which Windows PowerShell cmdlets should you run?

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.)
Select and Place:




Answer Clike
What should you identify?

DRAG DROP
You plan to deploy the following elements to a SharePoint Server 2013 server farm:
• A farm solution
• A sandbox solution
• A SharePoint hosted app
You need to identify where to deploy each element.
What should you identify? (To answer, drag the appropriate locations to the correct elements. Each location 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)
Select and Place:




Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
You have a SharePoint Server 2013 server farm.

HOTSPOT
You have a SharePoint Server 2013 server farm.
The farm contains a site that has the URL https://products.contoso.com. The site contains a master product list that is generated by using a Business Data Connectivity Service. The Business Data Connectivity Service retrieves data from the web services of several suppliers. The site also contains product documentation stored as Microsoft Word documents.
The president of your company sends you the following email message: “The product list at https://products.contoso.com changes frequently. Our management and sales teams also make hundreds of changes to product documentation daily. I want to confirm that all of the data is backed up frequently.”
The database administrator sends you the following email message: “We are performing daily incremental backups of Microsoft SQL Server at noon and at midnight. Also, we are performing a full backup of SQL Server on Saturday at 06:00. I’m hoping that this is sufficient.”
The director of IT services sends you the following email message: “The company cannot afford to lose 12 hours of data if an issue occurs. We need to ensure that no more than the last two hours of data for the product list in SharePoint is lost if a server fails. The product documentation does not change as often as the product list, however, no more than the last four hours of product documentation in SharePoint can be lost if an issue occurs.”
Select Yes if the statement can be shown to be true based on the available information; otherwise select No.
Hot Area:




Answer Clike
HOTSPOT

HOTSPOT
You are planning the deployment of a SharePoint Server 2013 server farm.
You gather requirements from the IT managers of three departments.
The human resources department requires one site collection that meets the following requirements:
• Is accessible from the URL http://hr.contoso.com.
• Can store 10 GB of documents.
The sales department requires five site collections that meet the following requirements:
• The URL for all of the site collections will be located under http://intranet.contoso.com.
• The site collections must only be accessible to users in the sales department.
The communications department requires one site collection that meets the following requirements:
• The URL for the site collection will be located under http://intranet.contoso.com.
• The site collection will host many Microsoft PowerPoint presentations. The presentations must be rendered in a web browser if a user does not have PowerPoint installed.
Select Yes if the statement can be shown to be true based on the available information; otherwise select No.
Hot Area:




Answer Clike
What should you include in the recommendation?

You plan to deploy a SharePoint Server 2013 server farm.
Your company frequently creates large video files that can be up to 40 GB in size.
You need to recommend a solution to ensure that users can locate the video files from within SharePoint sites.
What should you include in the recommendation?
A. File shares and content sources
B. File shares and shredded storage
C. Remote BLOB Storage (RBS) and a BLOB cache
D. Remote BLOB Storage (RBS) and content sources


Answer Clike
Which cmdlet should you run first?

You have a SharePoint Server 2010 server farm. The farm contains a custom solution package (.wsp).
You upgrade the farm to SharePoint Server 2013.
You need to ensure that the solution package (.wsp) can be used in the farm.
Which cmdlet should you run first?
A. Add-SPSolution
B. Update-SPSolution
C. Enable-SPFeature
D. Install-SPSolution


Answer Clike
Which method should you recommend for each task?

HOTSPOT
You have a Windows SharePoint Services 3.0 server farm.
You plan to perform the following tasks:
• Upgrade the Windows SharePoint Services 3.0 farm to Microsoft SharePoint Foundation 2010.
• Upgrade SharePoint Foundation 2010 to SharePoint Server 2010.
• Upgrade SharePoint Server 2010 to SharePoint Server 2013.
You need to recommend an upgrade method for each task. The solution must use in-place upgrades, whenever possible.
Which method should you recommend for each task? {To answer, select the appropriate upgrade method for each task in the answer area.)
Hot Area:




Answer Clike
Which service application should you create?

HOTSPOT
You develop an application that generates PDF files from an XML content stream.
You need to create a service application to support the file conversion efforts.
Which service application should you create? (To answer, select the appropriate service application in the answer area).
Hot Area:




Answer Clike
What should you configure?

HOTSPOT
You are managing search results in a SharePoint farm.
You need to promote or demote search results that include specific tags.
In the Search service application, what should you configure? (To answer, select the appropriate link in the answer area.)
Hot Area:




Answer Clike
What should you configure?

You have a SharePoint Server 2013 server farm.
Users purchase several apps for Microsoft Office from the Office Store.
You need to prevent documents containing Apps for Office that are uploaded to SharePoint document libraries from being rendered in a web browser.
What should you configure?
A. The SharePoint Store settings from Central Administration
B. The HTML Field Security settings of the site collection
C. The Apps for Office document library in the App Catalog
D. The General settings of the web application


Answer Clike
What should you modify?

You have a SharePoint Server 2013 server farm.
You have a Microsoft Visio drawing named Drawing1.vsdx that is 40 MB.
You add the Visio Web Access Web Part to a page and configure the Web Part to display Drawing1.
You discover that the Visio diagram is not displayed on the page.
Other Visio diagrams are displayed successfully by using the Visio Web Access Web Part.
You need to ensure that Drawing1.vsdx is displayed in the Visio Web Access Web Part.
What should you modify?
A. The site collection policy
B. The Global Settings of the Visio Services service application
C. The General settings of the web application
D. The List Settings of the list where Drawing1.vsdx is stored


Answer Clike
What should you recommend?

You have a SharePoint Server 2013 server farm.
You purchase an app for SharePoint from the Office Store.
You plan to deploy the app to the farm.
You need to recommend which changes must be made to the network infrastructure before you can deploy the app.
What should you recommend?
A. Add a host header in Internet Information Services (IIS).
B. Modify the Hosts file on the front-end Web servers.
C. Modify the Web.config file on the front-end Web servers.
D. Add an alias (CNAME) record in DNS.


Answer Clike
Which backup method should you recommend for each component?

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.)
Select and Place:




Answer Clike
Which Windows PowerShell cmdlets should you run?

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.)
Select and Place:




Answer Clike
What should you do?

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. Import a Microsoft Excel spreadsheet as a custom list.
B. Provision a Microsoft Project web app.
C. Create a SharePoint task list.
D. Create a collaboration portal.


Answer Clike
Which five steps should you perform in sequence?

DRAG DROP
You are upgrading a SharePoint environment from SharePoint 2010 to SharePoint 2013.
Users must be able to access but not modify SharePoint site content during the upgrade.
You need to upgrade the SharePoint environment.
Which five steps 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.)
Select and Place:




Answer Clike
What should you do?

A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm.
You are upgrading the farm to SharePoint 2013.
You need to ensure that users can access the unmodified farm contents during the upgrade process.
What should you do?
A. In SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade. Set the Instance Read-Only value to True.
B. In SQL Server Management Studio, locate the content databases and service application databases you plan to upgrade. Set the Database Read-Only value to True.
C. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. EXEC sp_dboption, “read only”, “True”;
D. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urlsite collection name> -lock readonly


Answer Clike
What should you do?

You are managing a SharePoint farm.
You need to ensure that new content is included in search results as soon as possible.
What should you do?
A. Configure on-demand crawling.
B. Configure an incremental crawl to run every 30 minutes.
C. Configure continuous crawling.
D. Add an additional index server to the farm.
E. Configure an incremental crawl to run every day.
F. Reset the search index.


Answer Clike
Which command should you select to complete the configuration?

HOTSPOT
An organization has two SharePoint farms named FarmA and FarmB.
You need to configure FarmA to consume the Managed Metadata service from FarmB.
In Central Administration, which command should you select to complete the configuration? (To answer, select the appropriate command in the answer area.)
Hot Area:




Answer Clike
Which search feature should you configure?

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.)
Hot Area:




Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
Which service application should you create?

HOTSPOT
You develop an application that creates variations of a submitted page. These variations display the original authored page in three different languages.
You need to create a service application to support the language conversion efforts.
Which service application should you create? (To answer, select the appropriate service application in the answer area).
Hot Area:




Answer Clike
What should you configure?

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. Device channels
B. Image renditions
C. Design Manager
D. Custom list views
E. Variations


Answer Clike
What should you do?

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?
A. Install all custom applications in the destination farm.
B. Configure alternate access mappings on the source server.
C. Copy all search indexes from the source farm to the destination farm.
D. Copy all SharePoint groups and users from the source farm to the destination farm.


Answer Clike
What should you do?

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?
A. Copy all custom master pages from the source site collection to the master page gallery in the destination site collection.
B. Copy all custom site definitions from the file system of the source farm to the destination farm.
C. Copy all permission levels from the source farm to the destination farm.
D. Copy all search indexes from the source farm to the destination farm.


Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
What should you do?

You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?
A. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2008 R2 SP1 Feature Pack webpage.
B. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage.
C. Run the SQL Server 2012 setup package.
D. Run the SQL Server 2008 R2 SP1 setup package.


Answer Clike
Where should you place the eDiscovery Center or Centers?

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?
A. Farm2 and Farm3
B. Farm1
C. Farm2
D. Farm1 and Farm2


Answer Clike
Which five actions should you perform in sequence?

DRAG DROP
A site collection includes a subsite that has the following characteristics:
• The subsite does not appear in the navigation structure for the site collection.
• It does not appear in the end user recycle bin or the site collection recycle bin.
• It was last accessed two months ago.
You need to restore the subsite without overwriting any other content in the site collection.
Which five 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.)
Select and Place:




Answer Clike
Which permissions should you select?

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.)
Hot Area:




Answer Clike
What should you do?

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?
A. Add the eDiscovery group as site collection administrators for every site collection that contains discoverable content.
B. Grant Full Control permissions to eDiscovery administrators.
C. Grant the eDiscovery group access to content in all web applications by using a web application user policy.
D. Configure the eDiscovery center to use forms-based authentication.


Answer Clike
What should you do?

HOTSPOT
A company upgrades a SharePoint environment from SharePoint 2010 to SharePoint 2013.
The Site Feeds feature is not available on the upgraded sites.
You need to activate Site Feeds.
What should you do? (To answer, select the appropriate options from the drop-down lists in the answer area.)
Hot Area:




Answer Clike
What should you do?

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?
A. Copy all search indexes from the source farm to the destination farm.
B. Configure alternate access mappings on the source server.
C. Copy all custom master pages from the source site collection to the Style Library in the destination site collection.
D. Copy all custom site definitions from the file system of the source farm to the destination farm.


Answer Clike
What should you do?

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. Create a SharePoint task list.
B. Integrate Microsoft Project Server with SharePoint.
C. Create a SharePoint team site.
D. Create a collaboration portal.


Answer Clike
Which command should you select to complete the configuration?

HOTSPOT
An organization has two SharePoint farms named FarmA and FarmB.
You need to grant a service account full control of the Managed Metadata service on Farm A.
In Central Administration, which command should you select to complete the configuration? (To answer, select the appropriate command in the answer area.)
Hot Area:




Answer Clike
What should you do?

You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?
A. Run the SQL Server 2012 setup package.
B. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage.
C. Run the SQL Server 2008 setup package.
D. Run the SQL Server 2008 R2 SP1 setup package.


Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
An organization has an Active Directory Domain Services (AD DS) domain and a SharePoint intranet site.
You need to ensure that only members of the AD DS security group named Managers can create personal sites.
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.)
Select and Place:




Answer Clike
How should you build the cmdlet?

DRAG DROP
You provision and configure a new SharePoint farm. The farm has not been backed up.
You need to use Windows PowerShell to back up all service applications in the farm.
How should you build the cmdlet? (To answer, drag the appropriate element to the correct location or locations 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.)
Select and Place:




Answer Clike
Which page should you configure the settings?

HOTSPOT
You are configuring SharePoint social features.
You need to ensure that users can configure the SharePoint social features settings from their own profiles.
On which page should you configure the settings? (To answer, select the appropriate link in the answer area.)
Hot Area:




Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
What should you do first?

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?
A. Define an individual target application in the Secure Store that contains Exchange connection information.
B. Configure server-to-server authentication between SharePoint and Exchange.
C. Configure alternate access mappings in SharePoint and Exchange.
D. Create an external content type for Exchange mailbox information.


Answer Clike
What should you do?

A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm.
You are upgrading the farm to SharePoint 2013.
You need to ensure that users can access the unmodified farm contents during the upgrade process.
What should you do?
A. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;
B. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly
C. Run the following Windows PowerShell cmdlets for each web application in the SharePoint 2010 farm you plan to upgrade. $db = Get-SPContentDatabaseSet- SPContentDatabase$db -Status Offline
D. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. EXEC sp_dboption, “read only”, “True”;


Answer Clike
What should you do?

A company named Contoso, Ltd. has a SharePoint 2010 site collection at www.contoso.com. You are preparing to upgrade the site collection to SharePoint 2013.
The root site collection has had extensive customizations made to pages by using SharePoint Designer.
You need to test the site collection customizations before the upgrade.
What should you do?
A. Use the visual upgrade feature in preview mode.
B. Use the page upgrade feature in preview mode for each customized page.
C. Run the Get-SPSite -identity http://www.contoso.com | $_.GetVisualReport() | Format-Table Windows PowerShell cmdlet.
D. Request an upgrade evaluation site collection.


Answer Clike
Which two actions should you perform?

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.)
A. Configure the Secure Store service application for the Excel workbook.
B. Embed the data connection information directly in the Excel workbook.
C. Create a trusted data connection library and add a data connection file.
D. Add the document library containing the Excel workbook to the Trusted File Locations list.
E. Create a Group Policy Object that adds the SharePoint URL to the Trusted Sites zone in Windows Internet Explorer.


Answer Clike
What should you do?

A SharePoint deployment includes the content source described in the following table.


You need to configure the intranet site content source to return search results without impacting availability.
What should you do?
A. Add an additional index server to the farm.
B. Reset the search index.
C. Configure continuous crawling.
D. Configure an incremental crawl to run every day.
E. Configure an incremental crawl to run every 30 minutes.
F. Configure on-demand crawling.


Answer Clike
What should you configure?

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?
A. Custom list views
B. Image renditions
C. Variations
D. Design Manager
E. Device channels


Answer Clike
Which two actions should you perform?

You perform the basic configuration of a SharePoint site to support SharePoint apps.
You need to configure policy settings for SharePoint apps to ensure that users can browse apps in the Office Store but cannot purchase apps without approval.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A. In Central Administration, configure the Office and SharePoint store settings to restrict app purchases.
B. Purchase and configure a wildcard SSL certificate for the domain from a third-party Trusted Root Certification Authority (CA).
C. In Central Administration, specify the URL to the App Catalog site.
D. In each site collection, configure the site app permissions to restrict app purchases.
E. Restrict the users and groups that have Approve permissions on the App Catalog site.


Answer Clike
What should you do?

You are configuring a SharePoint environment to support SharePoint apps for Litware, Inc. The SharePoint servers use a load-balancer for incoming requests.
You need to ensure that all connections to the SharePoint servers are secure and encrypted.
What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)
A. Create a DNS CNAME record for *.LitwareApps.com.
B. Create an SSL certificate for the AppHost.LitwareApps.com domain.
C. Create a wildcard SSL certificate for *.LitwareApps.com.
D. Create a DNS forward lookup zone for the LitwareApps.com domain.
E. Create a DNS A record for AppHost.LitwareApps.com that points to the IP address of the load-balancer.


Answer Clike
What should you do?

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.)
A. Configure a trust relationship between SharePoint Server and Lync Server.
B. Create a SharePoint connector in the Exchange Server management shell.
C. Install the SharePoint Web Services API on every server that runs Exchange Server.
D. Configure a trust relationship between SharePoint Server and Exchange Server.
E. Install the Exchange Web Services API on every SharePoint front-end web server.
F. Create an Exchange eDiscovery service application in Central Administration.


Answer Clike
Which Windows PowerShell cmdlet or cmdlets should you run?

You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging Service (ULS) log contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database “WSS_Content_Portal_Content_Database” requested by the login. The login failed. Login failed for user ‘LITWAREsvcExcelService’.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?
A. $sa = Get-SPServiceApplication | where {$_.TypeName -eq “Excel Services Application Web Service Application”} and $sa.GrantContentDatabasePermissions (“WSS_Content_Portal_Content_Database”)
B. Add SPShellAdmin -UserName LITWAREsvcExcelService
C. Add SPShellAdmin -UserName LITWAREsvcExcelService -database WSS_Content_Portal_Content_Database
D. $wa = Get-SPWebApplication https://portal.litware.com and $wa.GrantToProcessIdentity(“LITWARE svcExcelService”)


Answer Clike
What should you do?

A SharePoint environment contains an instance of Microsoft SQL Server 2008 R2.
You plan to migrate data from the existing database to a new instance of SQL Server 2012.
You need to configure SQL Server to support the migration. You must accomplish this goal without requiring any SharePoint application configuration changes.
What should you do?
A. On the SQL Server, configure a named instance.
B. On all servers in the farm, configure a SQL Server alias.
C. On all servers in the farm, configure SQL Server database mirroring.
D. Create a single-node SQL Server cluster.


Answer Clike
What should you do?

You are migrating a SharePoint Server 2010 My Site site collection to SharePoint Server 2013 by using the database attach method. You copy the content databases to the SharePoint 2013 farm.
You need to verify that all required objects have been successfully added to the SharePoint 2013 farm before upgrading the content database.
What should you do?
A. In the SharePoint 2013 site collection, run the site collection health checks.
B. Run the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2013 farm.
C. Run the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2010 farm.
D. In the SharePoint 2010 site collection, run the site collection health checks.
E. Run the Windows PowerShell cmdlet Mount-SPContentDatabase on the SharePoint 2010 farm.
F. Run the Windows PowerShell cmdlet Mount-SPContentDatabase on the SharePoint 2013 farm.


Answer Clike
Which shared services should you implement?

You are configuring a SharePoint environment to support workflows.
Workflows must meet the following requirements:
• Display a visual representation of the workflow.
• Display the workflow history.
• Provide access to external lists.
You need to implement the necessary shared services.
Which shared services should you implement? (Each correct answer presents part of the solution.
Choose two.)
A. Business Data Connectivity Services
B. Workflow Services
C. Access Services
D. Word Automation Services
E. Visio Graphics Services


Answer Clike
Which two features should you implement?

A Sales team creates proposals by using Microsoft Word. Sales team members store and review the proposal documents in the Sales team site collection.
New proposals are uploaded to the team site for approval.
You need to ensure that approved proposals are automatically converted to PDF format and then routed to a records center site collection.
Which two features should you implement? (Each correct answer presents part of the solution.
Choose two.)
A. Send To Connections
B. Content deployment
C. Document Conversion Service
D. Machine Translation Service
E. Word Automation Services


Answer Clike
What should you do?

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 New-SPTrustedSecurityTokenIssuer on a server in FarmB.
C. Run the Windows PowerShell cmdlet New-SPTrustedSecurityTokenIssuer on a server in HRFarm.
D. Log on as a member of the Administrators group on a server in FarmA.
E. Run the Windows PowerShell cmdlet Get-SPTrustedSecurityTokenIssuer -Identity FarmA on a server in FarmA.


Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
You are deploying a SharePoint farm.
You need to prevent all users from purchasing or installing apps from the SharePoint store.
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.)
Select and Place:




Answer Clike
Which two actions should you perform?

A company has an Active Directory Domain Services domain that contains a SharePoint farm.
The farm contains a site collection that displays data from an employee information database.
You define a domain user account named HRUsers and configure the account to have read-only permissions to the database.
You have the following data access requirements for the employee information database:
• Members of the Human Resources department must be able to view data by using SharePoint, without entering database credentials.
• No other SharePoint users should be able to view the employee data.
You need to meet the requirements.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A. Enable the Reports and Data Search Support site collection feature.
B. Create an external list that displays data from the employee information database.
C. In the Secure Store service application, define a target application by using a group mapping.
D. Enable site collection reporting.
E. In the Secure Store service application, define a target application by using an individual mapping.


Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
A company has a SharePoint 2013 farm. The company is in the process of configuring eDiscovery for Microsoft Exchange Server 2013 and has installed the Microsoft Exchange Web Services Managed API on each front-end web server.
You need to configure a trust relationship between the Exchange server and the SharePoint farm.
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.)
Select and Place:




Answer Clike
Which Windows PowerShell cmdlets should you run?

HOTSPOT
You upgrade a SharePoint 2010 environment to SharePoint 2013. The new environment includes the following site collections.
All site collections are backward compatible with SharePoint 2010.
You are preparing to allow site owners to upgrade sites to SharePoint 2013 compatibility mode.
You need to limit the number of sites that can be upgraded concurrently to five or fewer.
Which Windows PowerShell cmdlets should you run? (To answer, select the appropriate cmdlet from each drop-down list in the answer area.)
Hot Area:




Answer Clike
Which four actions should you perform in sequence?

DRAG DROP
You provision and configure a new SharePoint farm. The content databases are stored in Microsoft SQL Server 2012.
You need to configure the databases for high availability.
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.)
Select and Place:




Answer Clike
Which permission or permissions should you grant to the users?

You need to ensure that users can install apps from the App Catalog.
Which permission or permissions should you grant to the users?
A. Use Client Integration Features
B. Manage Web Site and Create Subsites
C. Use Self-Service Site Creation
D. Add and Customize Pages


Answer Clike
Which button should you click to begin the process?

HOTSPOT
An organization has an Active Directory Domain Services (AD DS) domain that includes a security group named SPAdmins. Employees use SharePoint to connect to external business systems.
In Central Administration, you select Manage Service Applications.
You need to configure the Secure Store service application to ensure that members of the SPAdmins group can create new Secure Store target applications.
Which button should you click to begin the process? (To answer, select the appropriate button in the answer area.)
Hot Area:




Answer Clike
What should you do?

Members of the Sales team store Microsoft Excel workbooks and other files on a SharePoint team site. The workbooks do not access external data.
When Sales team members attempt to open workbooks from the team site, they receive an error message stating that the workbook cannot be opened.
You need to configure the SharePoint farm to ensure that users can open Excel workbooks.
What should you do?
A. Set Trusted File Locations for Excel Services.
B. Add members to a Secure Store target application.
C. Set the Excel Calculation Services authentication method to Impersonation.
D. Grant members Read permission to the Sales team site.


Answer Clike
Which type of site collection should you create?

HOTSPOT
An organization is deploying a SharePoint farm that will provide a records-management solution.
Users must be able to perform the following actions:
• Create in-place holds on content stored in SharePoint and in Microsoft Exchange 2013.
• Search for content and place holds based on the search query.
You need to create a site collection that meets the requirements.
Which type of site collection should you create? (To answer, select the appropriate template in the answer area.)
Hot Area:




Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
An organization has a SharePoint intranet site.
Documents and other files do not currently appear in search results until the day after they are uploaded to the intranet site.
You need to configure the Search service application to ensure that documents appear in search results within one hour of being uploaded to the 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.)
Select and Place:




Answer Clike
How should you distribute the servers and roles?

DRAG DROP
A company is implementing a SharePoint farm that will contain six servers.
The farm architecture design must meet the following requirements:
• Distribute incoming user requests equally.
• Provide high availability.
You need to distribute the servers and roles to meet the requirements.
How should you distribute the servers and roles? (To answer, drag the appropriate server or role to the correct location or locations in the answer area. Each server or role 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.)
Select and Place:




Answer Clike
How should you distribute the service roles?

HOTSPOT
You are designing the search service topology for a SharePoint farm.
The design must meet the following requirements:
Search services must be fault tolerant and highly available.
Search crawls must not affect page load times.
Search queries must run at the fastest possible speed.
You need to distribute the appropriate search service roles to meet the requirements.
How should you distribute the service roles? (To answer, select the appropriate service role from each drop-down list in the answer area.)
Hot Area:




Answer Clike
Which option should you select?

HOTSPOT
You are managing search results in a SharePoint farm.
You need to configure a query rule that fires for all queries.
In the Search service application, which option should you select? (To answer, select the appropriate option in the answer area.)
Hot Area:




Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
Which four actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
An organization is involved in a legal case related to one of its products. All documents related to this product are stored in a subsite of a site collection. The site collection has an existing policy to delete documents that have not been modified for four years.
You must protect the data that is relevant to the case without impacting other content, changing file locations, or duplicating files.
You need to configure SharePoint to ensure that relevant documents are NOT deleted by existing or future expiration policies.
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.)
Select and Place:




Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
An organization uses SharePoint Server collaboration sites for all projects. Each project has a unique site. Project team members have Contribute permission levels to each project site of which they are members.
Sites for completed projects must meet the following requirements:
The project team members must be able to access files.
They must be prohibited from editing or deleting files.
They must not be able to change site permissions.
You need to configure the SharePoint environment to meet the requirements.
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.)
Select and Place:




Answer Clike
What should you do?

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.)
Hot Area:




Answer Clike
What should you do first?

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?
A. Create an external content type for Exchange mailbox information.
B. Configure server-to-server authentication between SharePoint and Exchange.
C. Create an external list for Exchange mailbox information.
D. Configure forms-based authentication between SharePoint and Exchange.


Answer Clike
Which Windows PowerShell cmdlets should you run?

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?
A. Install-SPApp and then Update-SPAppCatalogSettings
B. Import-SPAppPackage and then Install-SPApp
C. Import-SPAppPackage and then Enable-SPAppAutoProvision
D. Enable-SPAppAutoProvision and then Install-SPApp


Answer Clike
What should you do?

An organization is using SharePoint for team collaboration. Each department in the organization has a team site and a site owner who is responsible for site management.
Site owners do not have administrative rights to the web servers.
You need to ensure that site owners can install trusted apps to their own sites.
What should you do?
A. Create a sandbox solution.
B. Grant the site owners the Full Control permission level to the web applications.
C. Configure solution blocking settings.
D. Configure content deployment settings.
E. Create an App Catalog site.


Answer Clike
Which four actions should you perform in sequence?

DRAG DROP
An organization plans to deploy Microsoft Project Server 2013.
You need to install and configure Project Server in an existing SharePoint farm.
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.)
Select and Place:




Answer Clike
How should you complete the Windows PowerShell cmdlet?

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.)
Select and Place:




Answer Clike
Which task should you perform?

HOTSPOT
You install Microsoft Project Server 2013.
You need to provision a Project web app instance in an existing web app in a SharePoint farm.
In Central Administration, which task should you perform? (To answer, select the appropriate task in the answer area.)
Hot Area:




Answer Clike
What should you do?

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.)
Select and Place:




Answer Clike
Which command should you run?

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.)
Select and Place:




Answer Clike
Which three Windows PowerShell cmdlets should you run in sequence?

DRAG DROP
An organization migrates a SharePoint environment from SharePoint 2010 to SharePoint 2013. The organization has a web application at http:// intranet.contoso.com.
A corporate governance policy states that users of the web application must be able to create sites only with a compatibility level of SharePoint 2013.
You need to implement the governance policy.
Which three Windows PowerShell cmdlets should you run in sequence? (To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.)
Select and Place:




Answer Clike
What should you do?

A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm.
You are upgrading the farm to SharePoint 2013.
You need to ensure that users can access the unmodified farm contents during the upgrade process.
What should you do?
A. In SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade. Set the Instance Read-Only value to True.
B. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;
C. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly
D. Sign in to Central Administration in the SharePoint 2010 environment you plan to upgrade.
Set each content database and service application database to Read-Only.


Answer Clike
What should you do?

An organization upgrades a SharePoint 2010 environment to SharePoint 2013. A site collection is running in SharePoint 2010 compatibility mode.
You must verify that the following features will function correctly when the site collection is upgraded to SharePoint 2013 native mode:
• List views
• Custom web parts
• Content query web parts
• Subsites
You need to ensure that you can perform verification testing without impacting the current user experience.
What should you do?
A. Upgrade the site collection to SharePoint 2013.
B. Perform a database attach upgrade.
C. Enable the Visual Upgrade option for the site collection.
D. Generate an upgrade evaluation site collection.


Answer Clike
What should you do?

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?
A. Install all custom applications in the destination farm.
B. Copy all custom master pages from the source site collection to the Style Library in the destination site collection.
C. Copy all SharePoint groups and users from the source farm to the destination farm.
D. Copy all custom master pages from the source site collection to the master page gallery in the destination site collection.


Answer Clike
What should you do?

You are implementing a claims-based authentication solution for a SharePoint farm in an Active Directory Domain Services domain. You install and configure Active Directory Federation Services (AD FS).
You need to ensure that all web applications in the farm support SAML-based claims authentication.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Configure AD FS with the web application as a relying party.
B. Configure web applications to use forms-based authentication and AD FS as the trusted identity provider.
C. Configure web applications to use claims-based authentication and AD FS as the trusted identity provider
D. Configure web applications to use classic mode authentication and AD FS as the trusted identity provider.
E. Configure SharePoint to trust AD FS as an identity provider.


Answer Clike
What should you do?

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. Create a SharePoint team site.
B. Provision a Microsoft Project web app.
C. Create a SharePoint task list.
D. Import a Microsoft Excel spreadsheet as a custom list.


Answer Clike
What should you do?

You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?
A. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2008 R2 SP1 Feature Pack webpage.
B. Run the SQL Server 2008 setup package.
C. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 Feature Pack webpage.
D. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage.


Answer Clike
What should you do?

You need to resolve the SharePoint database error.
What should you do?
A. Add a new request URL mapping to the web application.
B. Remove the orphaned objects from the database.
C. Set the databases to read-write.
D. Add the managed path for the site collection to the web application.


Answer Clike
Which solution should you choose?

You need to choose a backup solution.
Which solution should you choose?
A. SharePoint backup from the Central Administration console
B. SQL Server backup by using SQL Server Management Studio
C. Windows Server Backup in Windows Server 2012
D. SharePoint backup by using Data Protection Manager (DPM)


Answer Clike
Which four actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
What should you do?

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.)
Select and Place:




Answer Clike
What should you do?

You need to configure the required level of access to the SharePoint 2010 farm prior to the migration.
What should you do?
A. In the corporate farm, run the ALTER DATABASE Transact-SQL statement.
B. In the corporate farm, run the CONFIG DATABASE Transact-SQL statement.
C. In the product support farm, run the CONFIG DATABASE Transact-SQL statement.
D. In the product support farm, run the ALTER DATABASE Transact-SQL statement.


Answer Clike
Which two Windows PowerShell cmdlets should you run?

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.)
A. Mount-SPContentDatabase
B. Restore-SPFarm
C. Export-SPWeb
D. Get-SPContentDatabase
E. Backup-WebConfiguration


Answer Clike
Which Windows PowerShell cmdlet should you run?

You need to ensure that users can edit the appropriate documents by using Office Web Apps.
Which Windows PowerShell cmdlet should you run?
A. Set-SPWebApplication -Identity “https://webapp2.contoso.com” -AdditionalClaimProvider Force
B. Set-SPWebApplication -Identity “https://webapp1.contoso.com” -AdditionalClaimProvider Force
C. Convert-SPWebApplication -Identity “https://webapp2.contoso.com” -To Claims -Retain Permissions
D. Convert-SPWebApplication -Identity “https://webapp1.contoso.com” -To Claims -Retain Permissions


Answer Clike
What should you do?

You need to configure authentication for the WebApp1 application pool account.
What should you do?
A. Add the application pool account to the db_owner fixed database role in the Master database.
B. Add the application pool account to a contained database.
C. Copy the application pool account from the primary replica databases to the secondary replica databases.
D. Re-create the application pool account in SharePoint Server 2013.


Answer Clike
Which two service applications should you configure?

HOTSPOT
You are configuring service applications to support access to the company data warehouse.
You need to assign permissions.
Which two service applications should you configure? (To answer, select the appropriate service applications in the answer area.)
Hot Area:




Answer Clike
Which URL should you specify?

You need to configure the Send To connection.
Which URL should you specify?
A. https://kb.proseware.com/dropofflibrary
B. https://kb.proseware.com/_vti_bin/officialfile.asmx
C. https://teams.proseware.com/_vti_bin/copy.asmx
D. https://teams.proseware.com/_vti_bin/officialfile.asmx


Answer Clike
Which cache should you configure?

You need to configure caching to support the ProseWeb site design elements.
Which cache should you configure?
A. BLOB cache
B. Site collection output cache
C. Site collection object cache
D. Site output cache


Answer Clike
Which Windows PowerShell cmdlets should you run?

You need to configure the site collection upgrade settings.
Which Windows PowerShell cmdlets should you run?
A. $site = Get-SPSite https://teams.proseware.com/productdev/marketing and Ssite.UpgradeReminderDelay = 0 and $site.UpgradeMaintenanceLink = $n
B. $site = Get-SPSite https://teams.proseware.com/productdev/marketing and $site.AllowSelfServiceUpgrade = $false
C. Ssite = Get-SPSite https://teams.proseware.com/productdev/marketing and $site.AllowSelfServiceUpgrade = $true
D. $site = Get-SPSite https://teams.proseware.com/productdev/research and $site.AllowSelfServiceUpgrade = $false
E. $site = Get-SPSite https://teams.proseware.com/productdev/research and Ssite.AllowSelfServiceUpgrade = $true


Answer Clike
Which Windows PowerShell cmdlet should you run?

Before you upgrade the web application, you need to validate that customizations will continue to function.
Which Windows PowerShell cmdlet should you run?
A. Test-SPSite -Identity http://webapp1.contoso.com
B. Test-SPContentDatabase -Identity HQDB -WebApplication http://webapp1.contoso.com
C. Test-SPSite -Identity http://webapp2.contoso.com
D. Test-SPContentDatabase -Identity DEPTDB -WebApplication http:// webapp2.contoso.com
E. Get-SPUpgradeActions -AssignmentCollectionspweb


Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike
Which two sets of Windows PowerShell cmdlets should you run?

You need to upgrade the appropriate site collections.
Which two sets of Windows PowerShell cmdlets should you run? (Each correct answer presents part of the solution. Choose two.)
A. $wa = Get-SPWebApplication https://teams.proseware.com and $wa.SiteUpgradeThrottleSettings.AppPoolConcurrentUpgradeSessionLimit = 10
B. $db = Get-SPContentDatabase”sp_content_teams_productdev” and Sdb.ConcurrentSiteUpgradeSessionLimit = 40
C. $wa = Get-SPWebApplication https://teams.proseware.com/productdev and $wa.SiteUpgradeThrottleSettings.AppPoolConcurrentUpgradeSessionLimi t = 10
D. $wa = Get-SPWebApplication https://teams.proseware.com and $wa.SiteUpgradeThrottleSettings = 10
E. $db = Get-SPContentDatabase”sp_content_teams_productdev” and $db.ConcurrentSiteUpgradeSessionLimit = 20
F. $db = Get-SPContentDatabase “sp_content_teams_productdev” and $db.SiteUpgradeThrottleSettings.AppPoolConcurrentUpgradeSessionLimit = 20


Answer Clike
What should you do?

You are preparing to migrate to the new SharePoint environment.
You need to configure SQL Server connectivity.
What should you do?
A. Configure a SQL Server client alias.
B. Configure a CNAME alias for SQL1.
C. Configure Request Management and specify a routing rule for database connections.
D. Configure a SQL Server failover cluster.


Answer Clike
Which two Windows PowerShell cmdlets should you run?

You need to redeploy the Time Entry app.
Which two Windows PowerShell cmdlets should you run? (Each correct answer presents a complete solution. Choose two.)
A. Import-SPAppPackage
B. Update-SPAppInstance
C. Install-SPSolution
D. Install-SPApp
E. Add SPSolution
F. Add-SPAppPackage


Answer Clike
Which permission level should you grant to the SharePoint_App_Dev group?

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?
A. App Manager permission level to the Central Administration site
B. Full Control permission level to the App Store site
C. Contribute permission level to the App Store site
D. Farm Administrator permission level to ContentFarm
E. Full Control permission level to the Central Administration site


Answer Clike
Which link should you select?

HOTSPOT
You need to begin configuring services to support solutions.
On the System page of Central Administration, which link should you select? (To answer, select the appropriate link in the answer area.)
Hot Area:




Answer Clike
How should you configure Request Manager?

DRAG DROP
You are planning for high availability of the SharePoint environment.
You need to plan the Request Manager configuration.
How should you configure Request Manager? (To answer, drag the appropriate elements to the correct positions 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.)
Select and Place:




Answer Clike
Which four actions should you perform in sequence?

DRAG DROP
You are preparing to create the ProductsKB site.
You need to create and configure the ProductsKB site to store product images.
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.)
Select and Place:




Answer Clike
What should you do?

You are configuring the ProseWeb site.
You need to ensure that the site content displays correctly on all devices.
What should you do?
A. Create a composed look and select the Mobile View option.
B. Configure a browser cookie named deviceChannel and set the value to Mobile.
C. Activate the Enable Mobile Views feature on the website.
D. Configure a device channel. Specify the value MSIE10.0 for the device inclusion rule.
E. Configure a device channel. Specify the value $FALLBACKMOBILEUSERAGENTS for the device inclusion rule.


Answer Clike
Which server or servers should you replicate the logins?

You need to replicate the SQL Server logins for the database instance in the search farm and ensure that no replication related errors are generated.
To which server or servers should you replicate the logins?
A. SPS-DB02 only
B. SPS-DB03 only
C. SPS-DB01 and SPS-DB02 only
D. SPS-DB01, SPS-DB02, and SPS-DB03


Answer Clike
What should you do?

HOTSPOT
You need to configure the environment to support the management of custom applications.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
Hot Area:




Answer Clike
What should you do?

DRAG DROP
You need to reconfigure the ContentFarm database topology.
What should you do? (To answer, drag the appropriate options to the correct location or locations in the answer area. Each option 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.)
Select and Place:




Answer Clike
Which type of storage solution should you implement?

You need to configure SPS-DB01.
Which type of storage solution should you implement?
A. Multiple disks individually attached via Fibre Channel
B. Multiple disks configured in a RAID 0 array
C. Multiple disks individually attached via iSCSI
D. Multiple disks configured in a RAID 5 array
E. Multiple disks configured in a RAID 10 array


Answer Clike
What should you do?

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.)
Hot Area:




Answer Clike
Which two Windows PowerShell cmdlets should you perform?

You need to meet the security requirement for site collection upgrades.
Which two Windows PowerShell cmdlets should you perform? (Each correct answer presents part of the solution. Choose two.)
A. $reports.AllowSelfServiceUpgrade = false
B. $reports = Get-SPSite “http://reports.wideworldimporters.com”
C. $reports.AllowSelfServiceUpgrade
D. $reports = Get-SPWebApplication “http://reports.wideworldimporters.com”
E. Sreports.AllowSelfServiceUpgrade = true


Answer Clike
What should you do?

DRAG DROP
You need to meet the database backup 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.)
Select and Place:




Answer Clike
What should you do?

You need to implement a Reporting Services solution.
What should you do?
A. Use Reporting Services Configuration Manager to add an additional report server to PROD- APP-02.
B. Install Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services add-in for SharePoint products.
C. Install Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services – SharePoint.
D. Uninstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-01. Install Reporting Services on PROD-WEB-01 and PROD-WEB-02. Add the report server URL to the load-balance pool.


Answer Clike
What should you do?

You need to meet the technical requirements for failover.
What should you do?
A. Configure log shipping between PROD-DB-01 and PROD-DB-02.
B. Configure an AlwaysOn availability group between PROD-DB-01 and PROD-DB-02.
C. Configure database mirroring with an additional witness server between PROD-DB-01 and PROD-DB-02.
D. Configure an active/passive failover cluster between PROD-DB-01 and PROD-DB-02.


Answer Clike
What should you do?

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.)
Select and Place:




Answer Clike
What should you do?

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.)
Select and Place:




Answer Clike
What should you do?

You need to meet the content recovery requirements for the farm.
What should you do?
A. Run the Windows PowerShell cmdlet Get-SPUnattachedContentDatabase -DatabaseName “WSS_TempContent”
B. Run the Windows PowerShell cmdlet Get-SPContentDatabase -Con nectAsUnattached Data base -DatabaseName “SharePoint_Config”
C. Use the Recover data from an unattached content database option in Central Administration.
D. Use the Export a site or list option in Central Administration.


Answer Clike
What should you do?

You need to configure the BCS model to access data.
What should you do?
A. Import the BCS model and enter the required account by using the Set Object Permissions command.
B. Create an external content type and enter the target application ID in the Secure Store Application ID field.
C. Create an external content type and choose the Connect with user’s identity option.
D. Create an external content type and choose the Connect with impersonated custom identity option. Enter the target application friendly name of the Secure Store target application.


Answer Clike
What should you do?

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.)
Select and Place:




Answer Clike
Which Site Settings option should you configure?

HOTSPOT
You need to support Windows Phone devices.
Which Site Settings option should you configure? (To answer, select the appropriate option in the answer area.)
Hot Area:




Answer Clike
What should you do?

You need to provision a SharePoint environment for MyTailspin.TailspinToys.com.
What should you do?
A. Create a web application and a site collection using the My Site Host template.
B. Create a web application, a site collection using the My Site Host template, and site collections for each user.
C. Configure the User Profile Synchronization service to perform a full import of AD DS user profiles.
D. Configure the User Profile Synchronization service to set up a My Sites site collection.


Answer Clike
What should you do?

You need to meet the site availability requirements.
What should you do?
A. Configure each web server as a node of a Network Load Balancing (NLB) cluster.
B. Create an alternate access mapping entry for each server.
C. Create client-side host entries to point to specific servers.
D. Create Request Management rules to route traffic to each server.


Answer Clike
What should you do?

You need to configure the BCS model to access data.
What should you do?
A. Create an external content type and enter the target application friendly name in the Secure Store Application ID field.
B. Create an external content type and enter the target application ID in the Secure Store Application ID field.
C. Create an external content type and choose the Connect with impersonated custom identity option. Enter the target application friendly name of the Secure Store target application.
D. Create an external content type and choose the Connect with user’s identity option.


Answer Clike
What should you do?

You need to configure Excel Services.
What should you do?
A. Add a trusted file location to the Tailspin360 site.
B. Add each user as a Viewer.
C. Add each user as a Contributor.
D. Add a trusted data connection library to the Tailspin360 site.


Answer Clike
Which three actions should you perform in sequence?

DRAG DROP
You need to ensure that the site supports the required languages.
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.)
Select and Place:




Answer Clike
What should you do?

You need to ensure that the developers have the necessary permissions to meet the BCS model requirements.
What should you do?
A. Grant Edit permissions to the developers by using the Set Object Permissions option
B. Grant Execute permissions to the developers by using the Set Object Permissions option
C. Grant Edit permissions to the developers by using the Set Metadata Store Permissions option
D. Grant Execute permissions to the developers by using the Set Metadata Store Permissions option


Answer Clike
Which steps should you take?

You need to meet the site collection creation requirements for MyTailspin.TailspinToys.com. Which steps should you take? (Each correct answer presents part of the solution. Choose all that apply.)
A. Ensure that the Setup My Sites setting for the User Profile service application uses the URL of the My Site host site collection and a wildcard inclusion.
B. Ensure that the Setup My Sites setting for the User Profile service application uses the URL of the My Site host site collection and an explicit inclusion.
C. Grant the Create Subsites permission to each user.
D. Grant the Create Personal Site permission to each user.


Answer Clike
Which three actions should you perform in sequence?

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.)
Select and Place:




Answer Clike