Microsoft 070-332 Actual Free Exam Questions & Community Discussion

You have a SharePoint Server 2013 server farm.
You implement Business Connectivity Services (BCS). You need to ensure that the BCS data is available for search.
What should you configure?

You need to ensure that users can edit the appropriate documents by using Office Web Apps.
Which Windows PowerShell cmdlet should you run?

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

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

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?

You need to configure Excel Services.
What should you do?

DRAG DROP
You manage a Microsoft SharePoint 2013 farm for Contoso, Ltd. The farm contains four servers. Two of the servers
receive user requests, and two servers perform back-end processing.
You must forward all requests for www.contoso.com
You have the following requirements:
* App Management must use all addresses in the contoso.apps.com zone.
* All traffic must be sent to a load balancer named nlb.contoso.com
You need to configure DNS.
Which three action you will perform in sequence? To answer, move the appropriate actions from the list of actions to
the answer area.

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.

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?

===========================
Case Study: 2
World Wide Importers
Background
General Background
Wide World Importers plans to upgrade from SharePoint 2010 to SharePoint 2013 to take advantage of
additional business intelligence (BI) services, including PerformancePoint Services, PowerPivot for Excel,
and SQL Server Reporting Services 2012 (SSRS). All users are members of an Active Directory Domain
Services (AD DS) domain.
Technical Background
The current environment integrates with a stand-alone instance of Microsoft SQL Server 2008 R2 Analysis
Services (SSAS). Wide World Importers has acquired SQL Server 2012 licenses for the purpose of
upgrading all the SQL Server instances to SQL Server 2012.
Business Requirements
The SharePoint 2013 environment and supporting back-end servers that run SQL Server must be highly
available and redundant in the case of unplanned downtime or a disaster.
Technical Environment
SharePoint 2013 Production Farm Topology
The SharePoint 2013 production farm topology consists of the servers listed in the following table.

The Wide World Importers SharePoint 2013 environment has the following characteristics:
*A hardware load-balancer is configured to balance traffic between PROD-WEB-01 and PROD-WEB-02.
*SSRS is installed on PROD-APP-01 in SharePoint integrated mode.
*SSRS report databases are stored on PROD-DB-01.
*A site collection named Report Center has been created at http://reports.wideworldimporters.com.
*All SharePoint content and configuration databases are stored on PROD-DB-01.
*All site collections have been migrated to a single content database named WSS_Content.
*A content database named WSS_TempContent has been restored to PROD-DB-01, but not attached to the SharePoint 2013 farm.
*An AD DS domain user account named PPS_SVC has been created.
SharePoint 2013 Disaster Recovery Site
The SharePoint 2013 Disaster Recovery farm topology consists of the servers listed in the following table.

Technical Requirements
*Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the disaster recovery site.
*Discrete sets of SharePoint content databases must be configured to automatically failover together.
*An additional SQL Server 2012 Report Server must be added to the SharePoint 2013 environment. The server must be configured to use SharePoint integrated mode.
*Additional SQL Server 2012 Report Servers must not be installed on machines that are running SharePoint as a front-end web server.
*Site Collection administrators must not have the ability to upgrade site collections.
*Site Collection upgrade jobs must be throttled to a maximum of five site collections at a time.
*A daily backup schedule must be created to perform SQL Server backups of all SharePoint content and configuration databases.
*The PPS_SVC AD DS user account must be used for the PerformancePoint service application.
*Farm administrators must be able to recover content from WSS_TempContent without attaching the database to the farm.
*All content databases within the production farm must be set to read-only when patching and upgrading the farm.
*Farm administrators must be able to determine which sites were missed or skipped during the upgrade process and must be able to monitor any future upgrades.
===========================
You need to meet the content recovery requirements for the farm.
What should you do?

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?