Q1. - (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. 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. 

View Answer

Q2. DRAG DROP - (Topic 6) 

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.) 

View Answer

Q3. HOTSPOT - (Topic 6) 

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.) 

View Answer

Q4. - (Topic 6) 

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 'LITWARE\svcExcelService'. 

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 LITWARE\svcExcelService 

C. Add SPShellAdmin -UserName LITWARE\svcExcelService -database WSS_Content_Portal_Content_Database 

D. $wa = Get-SPWebApplication https://portal.litware.com and $wa.GrantToProcessIdentity("LITWARE \svcExcelService") 

View Answer

Q5. - (Topic 6) 

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. 

View Answer

Q6. - (Topic 1) 

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. 

View Answer

Q7. DRAG DROP - (Topic 6) 

You are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections. Three site collections are available only inside the company network. The fourth site collection is available to an external partner company by using forms-based authentication. The external site collection is used to store contracts and purchase orders. Every site collection has its own content database. 

Contoso purchases an Office 365 subscription for external partner employees. Contoso plans to move the external site collection to SharePoint Online. You have the following requirements: 

Upgrade the external partner site collection to SharePoint Online. 

Upgrade the on-premises farm to SharePoint 2013. 

Minimize downtime for the upgrade. 

Ensure the sites are read-only during the upgrade. 

You need to plan the upgrade for the extranet 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. 

View Answer

Q8. HOTSPOT - (Topic 6) 

You are the administrator for your company's SharePoint environment. 

You are preparing your environment for high availability. You must use SQL Server 

AlwaysOn. 

You need to identify the replication methodology for each SharePoint service database. In the table below, identify whether SQL Server AlwaysOn is available for each of the service databases. 

NOTE: Make only one selection in each column. 

View Answer

Q9. HOTSPOT - (Topic 6) 

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. 

View Answer

Q10. - (Topic 6) 

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 

View Answer