70-332 무료 덤프문제 온라인 액세스

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.

정답:

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

DRAG DROP
You need to make the required resources available for users in the accounting department.
Which four 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.)

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 command-line tool for each site collection in the content databases you plan to upgrade. Stsadm
  -o setsitelock -urlsite collection name> -lock readonly
• C.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.
• D.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";

DRAG DROP
You need to configure the database servers for high availability.
What should you do? (To answer, drag the appropriate elements to the correct target or targets in the answer area.
Each element 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.)

정답:

Note:
* The content database should be placed on the database servers.
* The configuration database can replicated synchronously locally on the Seattle site.
* From scenario:
/ The databases must belong to a SQL Server AlwaysOn Availability Group and use the WAN connection for database
replication between the sites.
This implies an Asynchronous commit Commit Replica Type.

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.

• A.Word Automation service database
• B.Search Administration service database
• C.Content databases
• D.Usage and Health Data Collection service database
• E.State service database