Q1. - (Topic 6) 

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. 

View Answer

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

View Answer

Q3. DRAG DROP - (Topic 6) 

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

View Answer

Q4. HOTSPOT - (Topic 1) 

You need to support Windows Phone devices. 

Which Site Settings option should you configure? (To answer, select the appropriate option in the answer area.) 

View Answer

Q5. - (Topic 6) 

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 

View Answer

Q6. DRAG DROP - (Topic 6) 

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

View Answer

Q7. - (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. Configure forms-based authentication between SharePoint and Exchange. 

B. Create an external content type for Exchange mailbox information. 

C. Define a group target application in the Secure Store that contains Exchange connection information. 

D. Configure SharePoint and Exchange to use the same realm name. 

View Answer

Q8. - (Topic 6) 

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. 

View Answer

Q9. HOTSPOT - (Topic 6) 

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

View 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 

View Answer