Q1. - (Topic 3)
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: E
Q2. DRAG DROP - (Topic 6)
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.)
Answer:
Q3. HOTSPOT - (Topic 6)
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.)
Answer:
Q4. - (Topic 6)
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: B
Q5. - (Topic 6)
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: B
Q6. - (Topic 6)
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: A
Explanation: Design Manager in SharePoint 2013 provides a new approach for designing websites. Several new branding and design-based capabilities available in Design Manager enable you to create a compelling look, feel, and behavior for your SharePoint 2013 site. Design Manager also supports importing and exporting a visual design, and can help you ensure a consistent visual experience across all device platforms in your organization.
Incorrect:
Not C: With device channels in SharePoint 2013, you can render a single publishing site in multiple ways by using different designs that target different devices.
Q7. DRAG DROP - (Topic 6)
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.)
Answer:
Q8. - (Topic 6)
You are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections.
Each site collection has its own content database. Contoso is upgrading the SharePoint 2010 farm to SharePoint 2013. You create a SharePoint 2013 test farm to test the upgrade process.
The SharePoint migration team reports the content database upgrade failed with the following errors:
. ERROR Database [ContentDatabase] contains a site (Id = [identifier], url = [http://sitecolIectiona]) that is not found in the site map.
. Feature upgrade incomplete for Feature 'ContosoCustomSite' (Id: 'Feature GUID') in site 'http://sitecollectionb'. Exception: A duplicate content type name "Customer" was found.
. ERROR Found a missing feature Id = [Feature Identifier]
You need to resolve the issues.
Which three actions should you perform? Each correct answer presents part of the solution.
A. In the SharePoint 2010 farm, remove orphan objects from the content database and restart the upgrade process.
B. Extract the solution packages from the SharePoint 2010 farm by using the Get-SPSolution Windows PowerShell cmdlet and install to the SharePoint 2013 farm. Run the Test-SPContentDatabase Windows PowerShell cmdlet to confirm if the upgrade errors are fixed.
C. Use the SharePoint Designer to delete the Customer content type from the site collection named http://sitecollectionb, and then restart the upgrade process.
D. Delete the site with the site definition Id = [identifier].
E. Open the site collection named http://sitecolIectionb from the SharePoint 2010 farm and rename the Customer content type and then restart the upgrade process.
Answer: A,B,D
Q9. HOTSPOT - (Topic 4)
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.)
Answer:
Q10. - (Topic 6)
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<database name>, "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: B
Q11. - (Topic 6)
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: D
Q12. DRAG DROP - (Topic 6)
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.)
Answer:
Q13. HOTSPOT - (Topic 6)
You have a SharePoint Server 2013 server farm. The farm contains the following servers:
Six front-end Web servers Four application servers Four databases servers
All of the databases in the farm are mirrored by using Microsoft SQL Server database mirroring.
The farm contains the following service applications:
.PerformancePoint Service Application
. Managed Metadata Service
The PerformancePoint Service Application is configured as shown in the PerformancePoint exhibit. (Click the Exhibit button.)
The Managed Metadata Service application is configured as shown in Managed Metadata exhibit. (Click the Exhibit button.)
Select Yes if the statement can be shown to be true based on the available information; otherwise select No.
Answer:
Q14. HOTSPOT - (Topic 6)
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.)
Answer:
Q15. - (Topic 5)
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: A
Q16. DRAG DROP - (Topic 6)
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.)
Answer:
Q17. DRAG DROP - (Topic 6)
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.)
Answer: