Microsoft 70-332 Actual Free Exam Questions & Community Discussion

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

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

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

You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?

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

You are the administrator of a SharePoint environment. The SharePoint environment uses Azure Infrastructure
Services for disaster recovery.
You must create a disaster recovery plan that includes warm failover to Azure Infrastructure Services.
You need to identify which service databases must be restored.
Which two service databases must you restore? Each correct answer presents part of the solution.

You need to ensure that the developers have the necessary permissions to meet the BCS model requirements.
What should you do?

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 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?

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.