Online Access Free 070-332 Practice Test

HOTSPOT
You are the SharePoint administrator for a company that is installing SharePoint 2013. You have a SQL Server named
SPSQLA that has an instance named SharePointPilot.
You have the following requirements:
SQL aliases must be used to specify the connection to the database.
The name of the SQL alias must be configured as SPSQL.
You need to configure the SQL alias on the SharePoint 2013 server.
On the Add Network Library Configuration window, which three options should you select? To answer, select the
appropriate options in the answer area.

Correct Answer:

Explanation:
The following steps show how to create a SQL Server alias on SharePoint 2013 Servers using the SQL Server Client
Network Utility:
1 - Run SQL Server Client Network Utility at:
C:\windows\system32\cliconfig.exe
2. Select the Alias tab, and click Add.
3 - From the Network Libraries section, select TCP/IP.
4 - Type an alias in the Server Alias text box and the SQL Server instance in the Server Name text box.
5 - Check Dynamically Determine Port and click OK.
NOTE: If you use another port to connect on SQL Server, uncheck this option and set the correct port manually.

Reference: Configuring SQL Server alias with SharePoint Server 2013
http://blogs.technet.com/b/gabn/archive/2014/04/14/configuring-sql-server-alias-with-sharepoint-server-2013.aspx

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.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";
• B.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
• C.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;
• D.Run the following Windows PowerShell cmdlets for each web application in the SharePoint 2010 farm you plan to
  upgrade. $db = Get-SPContentDatabase<web application name>Set-SPContentDatabase$db -Status Offline

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

Correct Answer:

Explanation:
Collaboration farm
* Machine Translation Service
Machine Translation Service is a new service application in SharePoint 2013 that provides automatic machine
translation of files and sites.
Applications that use the server object model must run directly on a server that is running SharePoint 2013.
Machine Translation Service also includes a client object model (CSOM) that enables access to the Machine
Translation Service API for online, on-premises, and mobile development. Client applications can use the CSOM to
access server content and functionality.
* Managed Metadata Service allows you to classify with precision.
* Excel Services Application
Excel Services in SharePoint Server 2013 is enabled by creating an Excel Services Application service application in
Central Administration.
* Work Management Service
The Work Management Service Application provides functionality to aggregate tasks to a central location on
SharePoint Server:
Users get the possibility to view and track their to-dos and tasks.
Tasks can be cached to a users personal site.
Tasks can sync to Outlook where users can edit them wherever they have access to Outlook.
Tasks can be aggregated from Exchange, Project Server and SharePoint.
Based on 'Provider model' so that other systems can be integrated in the future.

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

• A.Grant Edit permissions to the developers by using the Set Metadata Store Permissions option
• B.Grant Edit permissions to the developers by using the Set Object Permissions option
• C.Grant Execute permissions to the developers by using the Set Metadata Store Permissions option
• D.Grant Execute permissions to the developers by using the Set Object Permissions option

You are configuring a SharePoint environment to support SharePoint apps for Litware, Inc. The SharePoint servers use
a load-balancer for incoming requests.
You need to ensure that all connections to the SharePoint servers are secure and encrypted.
What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)

• A.Create an SSL certificate for the AppHost.LitwareApps.com domain.
• B.Create a wildcard SSL certificate for *.LitwareApps.com.
• C.Create a DNS forward lookup zone for the LitwareApps.com domain.
• D.Create a DNS A record for AppHost.LitwareApps.com that points to the IP address of the load-balancer.
• E.Create a DNS CNAME record for *.LitwareApps.com.