Microsoft 70-332 Actual Free Exam Questions & Community Discussion
A SharePoint environment contains an instance of Microsoft SQL Server 2008 R2.
You plan to migrate data from the existing database to a new instance of SQL Server 2012.
You need to configure SQL Server to support the migration. You must accomplish this goal without requiring any
SharePoint application configuration changes.
What should you do?
You plan to migrate data from the existing database to a new instance of SQL Server 2012.
You need to configure SQL Server to support the migration. You must accomplish this goal without requiring any
SharePoint application configuration changes.
What should you do?
Correct Answer: B
Vote an answer
DRAG DROP
An organization plans to deploy Microsoft Project Server 2013.
You need to install and configure Project Server in an existing SharePoint farm.
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.)
An organization plans to deploy Microsoft Project Server 2013.
You need to install and configure Project Server in an existing SharePoint farm.
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: Install the Project Server 2013 binaries on the existing SharePoint servers.
Box 2: Run the SharePoint 2013 Products Configuration Wizard.
Box 3: Start the Project Server service instance and create a Project Server service application.
Box 4: Create a Project web app instance.
Note:
* (step 1) If you already installed and configuredSharePoint Server 2013 and you would like to try out Project Server
2013features there's no need to install another SharePoint server. You can simply integrate between Project Server
2013and SharePoint Server 2013using an existing site collection.
Project Server 2013runs as a service application underSharePoint Server 2013. In order to integrate between those
products,Project Server 2013must be installed on each application server in your SharePoint farm.
Reference: Add an application server to a farm in Project Server 2013
* (step 2) First thing that has to be done after installing Project Server 2013 is to run the SharePoint Products
Configuration Wizard. The wizard has to run onall application servers in your farmbefore you can start using Project
Server.
* (step 3) Start the Project Server Application Service.
Create a Project Server service application. Open SharePoint 2013 Central Administration ->Application Management
->Manage service applications ->New ->Project Server Service Application.
Specify anamefor the service applicationand choose an application pool.
* (step 4)
Create a Project Web App database. Open the SharePoint 2013 Management Shell and
Use the following PowerShell cmdlet: New-SPProjectDatabase -Name DatabaseName -ServiceApplication
"ServiceApplicationName" -DatabaseServerSQLServerInstance -Tag String.
For example: New-SPProjectDatabase -Name ProjectWebApp1 -ServiceApplication "ProjectServiceApp " -
DatabaseServer sp2013srv -Tag "ProjectWebApp1DB"
Reference: How to integrate Project Server 2013 with SharePoint Server 2013
Box 2: Run the SharePoint 2013 Products Configuration Wizard.
Box 3: Start the Project Server service instance and create a Project Server service application.
Box 4: Create a Project web app instance.
Note:
* (step 1) If you already installed and configuredSharePoint Server 2013 and you would like to try out Project Server
2013features there's no need to install another SharePoint server. You can simply integrate between Project Server
2013and SharePoint Server 2013using an existing site collection.
Project Server 2013runs as a service application underSharePoint Server 2013. In order to integrate between those
products,Project Server 2013must be installed on each application server in your SharePoint farm.
Reference: Add an application server to a farm in Project Server 2013
* (step 2) First thing that has to be done after installing Project Server 2013 is to run the SharePoint Products
Configuration Wizard. The wizard has to run onall application servers in your farmbefore you can start using Project
Server.
* (step 3) Start the Project Server Application Service.
Create a Project Server service application. Open SharePoint 2013 Central Administration ->Application Management
->Manage service applications ->New ->Project Server Service Application.
Specify anamefor the service applicationand choose an application pool.
* (step 4)
Create a Project Web App database. Open the SharePoint 2013 Management Shell and
Use the following PowerShell cmdlet: New-SPProjectDatabase -Name DatabaseName -ServiceApplication
"ServiceApplicationName" -DatabaseServerSQLServerInstance -Tag String.
For example: New-SPProjectDatabase -Name ProjectWebApp1 -ServiceApplication "ProjectServiceApp " -
DatabaseServer sp2013srv -Tag "ProjectWebApp1DB"
Reference: How to integrate Project Server 2013 with SharePoint Server 2013
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 need to configure the BCS model to access data.
What should you do?
What should you do?
Correct Answer: D
Vote an answer
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 to 192.168.100.31.
You need to configure DNS.
How should you configure the DNS?
receive user requests, and two servers perform back-end processing.
You must forward all requests for www.contoso.com to 192.168.100.31.
You need to configure DNS.
How should you configure the DNS?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You are configuring a SharePoint farm.
You have the following requirements:
Implement an enterprise resource pool.
Enable tasks to be assigned to users.
Implement a resource breakdown structure.
You need to implement a solution that meets the requirements.
What should you do?
You have the following requirements:
Implement an enterprise resource pool.
Enable tasks to be assigned to users.
Implement a resource breakdown structure.
You need to implement a solution that meets the requirements.
What should you do?
Correct Answer: A
Vote an answer
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
An organization has created graphic designs that will be used for branding in a SharePoint farm.
You need to develop the supporting assets required to implement the design in the minimum amount of time.
What should you use?
You need to develop the supporting assets required to implement the design in the minimum amount of time.
What should you use?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
HOTSPOT
You are a SharePoint architect for Contoso, Ltd. The environment has the following servers:
You must support a streamlined topology.
You need to design the distribution of services and other components in the farm.
Use the drop-down menus to select the answer choice that answers each question.
You are a SharePoint architect for Contoso, Ltd. The environment has the following servers:
You must support a streamlined topology.
You need to design the distribution of services and other components in the farm.
Use the drop-down menus to select the answer choice that answers each question.
Correct Answer:
* Business Data Connectivity services should be placed on the Front-end servers.
We include the SPServer1 which has the distributed cache.
* The Word Automation Service should be placed on the Batch application server.
* Microsoft SharePoint Foundation Subscription Settings Service should be placed on the Web server or application
server. Here we use the web servers SPWeb1 and SpWeb2.
Note: Streamlined topologies - The distribution of services and other components in a farm is intended to maximize
system resources of server hardware. Streamlined architectures include front-end servers, batch-processing servers,
and database servers.
Reference: Plan service deployment in SharePoint 2013
https://technet.microsoft.com/en-us/library/jj219591.aspx
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
DRAG DROP
You provision and configure a new SharePoint farm. The farm has not been backed up.
You need to use Windows PowerShell to back up all service applications in the farm.
How should you build the cmdlet? (To answer, drag the appropriate element to the correct location or locations 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.)
You provision and configure a new SharePoint farm. The farm has not been backed up.
You need to use Windows PowerShell to back up all service applications in the farm.
How should you build the cmdlet? (To answer, drag the appropriate element to the correct location or locations 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.)
Correct Answer:
Note:
* You can use Windows PowerShell to back up the farm manually or as part of a script that can be run at scheduled
intervals.
* The Backup-SPFarmcmdlet creates a backup for the entire farm or individual components within the farm. It can
also be used to back up just the configuration settings of a farm to be used as a farm template for other SharePoint
farms.
Syntax:
Backup-SPFarm -BackupMethod<String> -Directory <String> [-AssignmentCollection<SPAssignmentCollection>] [-
BackupThreads<Int32>] [-ConfigurationOnly<SwitchParameter>] [-Confirm [<SwitchParameter>]] [-Force
<SwitchParameter>] [-Item <String>] [-Percentage <Int32>] [-WhatIf [<SwitchParameter>]]
* Here we need a full backup, since the farm has not been backed up earlier.
* Item Parameter
Indicates the part of the farm to back up.
Here we should use Farm\Shared Services
0
0
0
10