Microsoft 070-332 Actual Free Exam Questions & Community Discussion
DRAG DROP
A SharePoint 2010 environment contains the site collections described in the following table.
You plan to migrate the environment to SharePoint 2013. You create a SharePoint 2013 site at the URL
http://testIntranet.contoso.com. You restore the database backups from the 2010 environment to the 2013
environment.
You test the migration plan by migrating the Intranet.Content database to the new site.
You need to verify that the test migration succeeds.
Which Windows PowerShell cmdlets should you run? (To answer, drag the appropriate cmdlets to the correct location
or locations in the answer area. Each cmdlet 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.)
A SharePoint 2010 environment contains the site collections described in the following table.
You plan to migrate the environment to SharePoint 2013. You create a SharePoint 2013 site at the URL
http://testIntranet.contoso.com. You restore the database backups from the 2010 environment to the 2013
environment.
You test the migration plan by migrating the Intranet.Content database to the new site.
You need to verify that the test migration succeeds.
Which Windows PowerShell cmdlets should you run? (To answer, drag the appropriate cmdlets to the correct location
or locations in the answer area. Each cmdlet 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:
Note:
* Test -SPContentDatabase
Use the Test-SPContentDatabase cmdlet to test a content database against a Web application to verify all
customizations referenced within the content database are also installed in the web application.
* The Mount-SPContentDatabase cmdlet attaches an existing content database to the farm. If the database being
mounted requires an upgrade, this cmdlet will cause the database to be upgraded.
Example:
ExAMPLE
Mount-SPContentDatabase "MyDatabase" -DatabaseServer "MyServer" -WebApplication http://sitename
This example mounts an existing database to the sitename web application. If upgrades are required, it triggers
database schema upgrade and then performs only build-to-build upgrade actions on existing site collections if
required.
You are moving a customized SharePoint site collection to a new farm.
You attach and mount the source content database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
You attach and mount the source content database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
Correct Answer: D
Vote an answer
DRAG DROP
You need to meet the content access requirements during the upgrade process.
What should you do? (To answer, drag the appropriate terms to the correct location or locations in the answer area.
Each term 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 need to meet the content access requirements during the upgrade process.
What should you do? (To answer, drag the appropriate terms to the correct location or locations in the answer area.
Each term 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:
Box 1: SQL Server Management Studio
Box 2: State
Box 3: True
Box 4: Content
Note:
* From scenario:
/ All content databases within the production farm must be set to read-only when patching and upgrading the farm.
* SQL Server Management Studio (ssms) is a software application first launched with the Microsoft SQL Server 2005
that is used for configuring, managing, and administering all components within Microsoft SQL Server.
* A farm is considered read-only if one of the following is true:
All content databases are set to read-only.
Service application databases are set to read-only.
* To set content databases to read-only by using SQL Server
Verify that the user account that is performing this procedure is a member of the db_owner fixed database role in
each database.
Start SQL Server Management Studio.
Right-click the content database that you want to make read-only, and then click Properties.
Select the Options page, and, in the Other options list, scroll to the State section.
In the Database Read-Only row, click the arrow next to False, select True, and then click OK.
Repeat for all other content databases.
Reference: Run a farm that uses read-only databases in SharePoint 2013
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?
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?
Correct Answer: A
Vote an answer
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.
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
You upgrade a SharePoint Server 2010 server farm to SharePoint Server 2013. Several users report that a site
collection site has the visual elements of SharePoint Server 2010.
You need to ensure that the site collection uses the visual elements of SharePoint Server 2013.
Which cmdlet should you run?
collection site has the visual elements of SharePoint Server 2010.
You need to ensure that the site collection uses the visual elements of SharePoint Server 2013.
Which cmdlet should you run?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You need to configure caching to support the ProseWeb site design elements.
Which cache should you configure?
Which cache should you configure?
Correct Answer: B
Vote an answer
You are moving a customized SharePoint site collection to a new farm. You attach and mount the source content
database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
database in the destination farm.
You need to ensure that all customizations from the source farm are available in the destination farm.
What should you do?
Correct Answer: D
Vote an answer
You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?
You need to install PowerPivot for SharePoint.
What should you do?
Correct Answer: D
Vote an answer
HOTSPOT
You need to back up the HR site collection.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
You need to back up the HR site collection.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
Correct Answer:
Note:
* SQL Server: The content database is stored in SQL Server.
/ From Scenario: The farm currently uses SPS-DB01 as its primary database instance.
* Windows Scheduled task to set a reoccurring task.
* Backup-SPSite Performs a backup of a site collection.
* Daily
From scenario: The Site Owner of the HR site collection requires that the HR Site Collection be backed up in full on a
daily basis.
DRAG DROP
A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The company uses a
third-party application to process payroll data and view payroll reports. The third-party application uses SQL
Authentication. Payroll administrators currently use custom credentials to sign in to the payroll application.
You have the following requirements:
Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports from within
SharePoint.
Payroll administrators must not be required to enter credentials when accessing payroll data.
The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
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 company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The company uses a
third-party application to process payroll data and view payroll reports. The third-party application uses SQL
Authentication. Payroll administrators currently use custom credentials to sign in to the payroll application.
You have the following requirements:
Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports from within
SharePoint.
Payroll administrators must not be required to enter credentials when accessing payroll data.
The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
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.)
Correct Answer:
Box 1: Register a managed account to run the Secure Store application pool.
Box 2: Create a Secure Store service application instance, and start the Secure Store Service on servers within the
farm.
Box 3: Generate a new key for your Secure Store service application.
Box 4: Store credentials in Secure Store by using a Secure Store target application.
Note:
* To configure Secure Store, you perform the following steps:
(step 1)
Register a managed account in SharePoint Server 2013 to run the Secure Store application pool.
(step 2)
Start the Secure Store Service on an application server in the farm.
Create a Secure Store Service service application.
* (step 3)
Before using the Secure Store Service, you must generate an encryption key. The key is used to encrypt and decrypt
the credentials that are stored in the Secure Store Service database.
* (Step 4)
Storing credentials in Secure Store is accomplished by using a Secure Storetarget application.
Reference: Configure the Secure Store Service in SharePoint 2013
Box 2: Create a Secure Store service application instance, and start the Secure Store Service on servers within the
farm.
Box 3: Generate a new key for your Secure Store service application.
Box 4: Store credentials in Secure Store by using a Secure Store target application.
Note:
* To configure Secure Store, you perform the following steps:
(step 1)
Register a managed account in SharePoint Server 2013 to run the Secure Store application pool.
(step 2)
Start the Secure Store Service on an application server in the farm.
Create a Secure Store Service service application.
* (step 3)
Before using the Secure Store Service, you must generate an encryption key. The key is used to encrypt and decrypt
the credentials that are stored in the Secure Store Service database.
* (Step 4)
Storing credentials in Secure Store is accomplished by using a Secure Storetarget application.
Reference: Configure the Secure Store Service in SharePoint 2013
0
0
0
10