GreatExam 70-332 study guide provides you everything you will need to take your 70-332 exam. The 70-332 exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.
QUESTION 86
Drag and Drop Question
You need to meet the disaster recovery requirements.
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.)
Answer:
Explanation:
Note:
* From scenario:
/ Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the disaster recovery site. / A hardware load-balancer is configured to balance traffic between PROD-WEB-01 and PRODWEB-02. Both are running SQL Server 2012.
/ The SharePoint 2013 Disaster Recovery farm topology consists of the servers listed in the following table.
/ Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the disaster recovery site.
* SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary serverinstance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.
* Terms and Definitions
/ primary server
The instance of SQL Server that is your production server.
/ primary database
The database on the primary server that you want to back up to another server. All administration of the log shipping configuration through SQL Server Management Studio is performed from the primary database.
/ secondary server The instance of SQL Server where you want to keep a warm standby copy of your primary database.
/ secondary database The warm standby copy of the primary database. The secondary database may be in either the RECOVERING state or the STANDBY state, which leaves the database available for limited read-only access.
QUESTION 87
You need to meet the technical requirements for failover. What should you do?
A. Configure log shipping between PROD-DB-01 and PROD-DB-02.
B. Configure an AlwaysOn availability group between PROD-DB-01 and PROD-DB-02.
C. Configure database mirroring with an additional witness server between PROD-DB-01 and PROD- DB-02.
D. Configure an active/passive failover cluster between PROD-DB-01 and PROD-DB-02.
Answer: B
QUESTION 88
You need to implement a Reporting Services solution. What should you do?
A. Use Reporting Services Configuration Manager to add an additional report server to PROD-APP- 02.
B. Install Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode.
On the SQL Server Feature Selection page, select Reporting Services add-in for SharePoint products.
C. Install Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode.
On the SQL Server Feature Selection page, select Reporting Services – SharePoint.
D. Uninstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-01.
Install Reporting Services on PROD-WEB-01 and PROD-WEB-02.
Add the report server URL to the load-balance pool.
Answer: C
QUESTION 89
You need to meet the security requirement for site collection upgrades.
Which two Windows PowerShell cmdlets should you perform? (Each correct answer presents part of the solution. Choose two.)
A. $reports.AllowSelfServicellpgrade = false
B. $reports = Get-SPSite “http://reports.wideworldimporters.com”
C. $reports.AllowSelfServiceUpgrade
D. $reports = Get-SPWebApplication “http://reports.wideworldimporters.com”
E. Sreports.AllowSelfServiceUpgrade = true
Answer: AB
Explanation:
* At the Windows PowerShell command prompt, type the following command to view the self-service upgrade setting for a site collection:
$site=Get-SPSite <URL>
$site.AllowSelfServiceUpgrade=<Value>
Where:
<URL> is URL for the site collection that you want to affect. <Value> is either ‘true’ to allow site collection administrators to upgrade the site, or ‘false’ to not show them the notification and not allow them to upgrade.
* Get-SPSite
Returns all site collections that match the specified criteria.
Note:
* From scenario:
/ A site collection named Report Center has been created at http:// reports.wideworldimporters.com.
/ 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.
Incorrect:
D: Get-SPWebApplication
Returns all Web applications that match the given criteria. The Get-SPWebApplication cmdlet returns all Web applications that match the scope given by the Identity parameter. The Identity can be the name of the name, URL, or GUID of the Web application. If no Identity is specified, all Web applications are returned. The Central Administration Web application is only returned if its exact identity is provided or the IncludeCentralAdministration flag is provided.
Reference: Manage site collection upgrades to SharePoint 2013
QUESTION 90
Drag and Drop Question
You need to meet the database backup requirements.
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.)
Answer:
Explanation:
Box 1: Management
Box 2: recurring
Box 3: daily
Box 4: backup
Note:
* From scenario:
/ A daily backup schedule must be created to perform SQL Server backups of all SharePoint content and configuration databases.
* To start the Maintenance Plan Wizard
1. Expand the server.
2. Expand the Management folder.
3. Right-click Maintenance Plans and select Maintenance Plan Wizard. This launches the wizard and you can now step through and create a plan customized to meet your maintenance requirements.
* Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” Click next to the wizard description, in the `select plan properties’ click on `Change’ Select schedule type as `recurring’ and configure your schedule for backup, for example select frequency as `daily’ for daily backups.
Case Study: 3 – Baldwin Museum of Science (QUESTION 91 – QUESTION 98)
Background
Baldwin Museum of Science has an Active Directory Domain Services (AD DS) domain named BaldwinMuseumOfScience.com. The domain has a SharePoint environment that contains two farms named ContentFarm and SearchFarm. ContentFarm includes content and collaboration tools. A custom app named Time Entry is deployed to the App Store on ContentFarm. ContentFarm includes a site collection named HR. You are planning for a major content and configuration update to the term store in the managed metadata service application that is located on ContentFarm. SearchFarm is reserved for crawling content and responding to search queries.
ContentFarm Topology
The topology of ContentFarm is shown in the following table.
ContentFarm has the following characteristics:
– Primary content for the farm is available at the URL SharePoint.BaldwinMuseumOfScience.com.
– Requests for content from the farm are load-balanced between SPC-WEB01 and SPC- WEB02.
– The servers that run Microsoft SQL Server are members of an active/passive cluster that run a failover cluster named SP-SQL01.
– MySites sites for each user are hosted on a separate web application available at the URL my.baldwinmuseumofscience.com.
– Requests for MySites pages are load-balanced between SPC-WEB01 and SPC-WEB02.
– A full backup of the farm is performed once a week.
– An incremental backup of the farm is performed once a day.
– The Site Owner of the HR site collection requires that the HR Site Collection be backed up in full on a daily basis.
– The managed metadata, user profile, and BCS service applications are enabled in the farm.
– All members of the SharePoint developer team belong to an AD DS security group named SharePoint_App_Dev.
SearchFarm Topology
The topology of SearchFarm is shown in the following table.
SearchFarm has the following characteristics:
– The farm currently uses SPS-DB01 as its primary database instance.
– SPS-DB01 has experienced multiple hard drive failures in the last month.
– The identity of the search service application is not documented.
Technical Requirements
The following requirements must be met for ContentFarm and SearchFarm:
– All administrative activities must be performed by using Windows PowerShell.
– Custom applications created by using the SharePoint app model must be deployed to, and hosted in, an internal App Store.
– Site owners must not be able to directly purchase third-party apps from the public SharePoint Store.
– Members of the SharePoint_App AD D5 security group must have the ability to submit new apps and app updates to the App Store of ContentFarm.
– Members of the SharePoint_App_Dev AD DS security group must not be granted farm administrator rights in ContentFarm.
– The Time Entry app must remain available to users at all times.
– The contents of ContentFarm must be indexed by the Search service application of SearchFarm.
– All responses to queries submitted by users in ContentFarm must be served by the Search service application of SearchFarm.
– The database resources for SearchFarm must be configured to be highly available by using SQL Server database mirroring with automatic failover.
– MySite content databases must be moved to a separate clustered database instance. The new clustered database instance must be created by using existing database servers in ContentFarm.
– All storaae resources for both farms must be redundant and provide high performance for both read and write operations and support disk mirroring.
– A snapshot of the current state of the managed metadata service application must be taken before the service application receives the planned major update.
QUESTION 91
You need to configure SPS-DB01.
Which type of storage solution should you implement?
A. Multiple disks individually attached via Fibre Channel
B. Multiple disks configured in a RAID 0 array
C. Multiple disks individually attached via iSCSI
D. Multiple disks configured in a RAID 5 array
E. Multiple disks configured in a RAID 10 array
Answer: E
QUESTION 92
Hotspot Question
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.)
Answer:
Explanation:
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.
QUESTION 93
Drag and Drop Question
You need to reconfigure the ContentFarm database topology.
What should you do? (To answer, drag the appropriate options to the correct location or locations in the answer area. Each option 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.)
Answer:
Explanation:
Note:
* From Scenario:
/ MySite content databases must be moved to a separate clustered database instance. The new clustered database instance must be created by using existing database servers in ContentFarm.
/ All storage resources for both farms must be redundant and provide high performance for both read and write operations and support disk mirroring.
* Box 1:
Use both SQL Server 2012 servers (SPC-DB01 and SPC-DB02)
* Box 2:
/ From ScenarIO: SPS-DB01 has experienced multiple hard drive failures in the last month.
So we use SPC-DB02 as the active node.
* Box 3, Box 4, Box 5: We move the content databases to the new SQL Server instance
* Box 6: Reattach to the web application.
QUESTION 94
You need to replicate the SQL Server logins for the database instance in the search farm and ensure that no replication related errors are generated.
To which server or servers should you replicate the logins?
A. SPS-DB02 only
B. SPS-DB03 only
C. SPS-DB01 and SPS-DB02 only
D. SPS-DB01, SPS-DB02, and SPS-DB03
Answer: A
QUESTION 95
Hotspot Question
You need to configure the environment to support the management of custom applications.
What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.)
Answer:
QUESTION 96
You need to back up the Managed Metadata service application before the update.
Which two tools can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A. The Backup and Recovery page in Central Administration
B. SQL Server Management Studio
C. The Backup-SPFarm Windows PowerShell cmdlet
D. The Backup-SPSite Windows PowerShell cmdlet
E. The Backup SqlDatabase Windows PowerShell cmdlet
Answer: AC
QUESTION 97
You need to redeploy the Time Entry app.
Which two Windows PowerShell cmdlets should you run? (Each correct answer presents a complete solution. Choose two.)
A. Import-SPAppPackage
B. Update-SPAppInstance
C. Install-SPSolution
D. Install-SPApp
E. Add SPSolution
F. Add-SPAppPackage
Answer: AD
Explanation:
A: Use the Import-SPAppPackage cmdlet to import an app package from the content database and create an app inside the site collection by using the SiteCollection parameter.
D: Use the Install-SPApp cmdlet to install an instance of an app within a web application.
* From scenario
/ ContentFarm includes content and collaboration tools.
A custom app named Time Entry is deployed to the App Store on ContentFarm.
Note:
Incorrect:
B: Use the Update-SPAppInstance cmdlet to update the app instance.
QUESTION 98
You need to ensure that app developers have the necessary permission to submit apps for deployment.
Which permission level should you grant to the SharePoint_App_Dev group?
A. App Manager permission level to the Central Administration site
B. Full Control permission level to the App Store site
C. Contribute permission level to the App Store site
D. Farm Administrator permission level to ContentFarm
E. Full Control permission level to the Central Administration site
Answer: B
Case Study: 4 – Proseware, Inc (QUESTION 99 – QUESTION 108)
Background
General Background
You are a SharePoint administrator for a media distribution company named Proseware, Inc. Proseware is in the process of upgrading from SharePoint 2010 to SharePoint 2013. The IT group has deployed a new SharePoint 2013 farm. The farm is not yet fully configured. You are supporting the product development group during the planning and configuration of the new SharePoint farm. The product development group includes the research, development, and marketing teams. The product development group has multiple team sites and project collaborations sites in the current SharePoint 2010 farm.
Business Background
Stakeholders have identified the following initiatives:
– ProseWeb, a public website that will allow anonymous visitors to browse the company’s product catalog.
– PartnerWeb, a public website that will allow authenticated users from partner companies to collaborate on product materials.
– ProductsKB, a centralized repository where teams can publish product-related documents, images, videos, and other information related to the company’s product catalog. Information in this site will be consumed by the ProseWeb site.
Technical Background
The company has an Active Directory Domain Services (AD DS) domain named proseware.com. All servers and user accounts are members of the domain. The company has purchased the proseware-apps.com domain to support SharePoint apps. The SharePoint 2013 farm currently has the following configuration:
– The farm includes seven SharePoint servers named SPWEB1, SPWEB2, SPWEB3, SPWEB4, SPADM1, SPAPP1, and SPAPP2.
– SPWEB1, SPWEB2, SPWEB3, SPWEB4 and SPADM1 are configured as front-end web servers.
– SPADM1 is dedicated for administration purposes.
– Windows Network Load Balancing has been configured to load balance all host names across the front-end web servers.
– Central Administration has been provisioned on SPWEB4 and SPADM1. ?The farm includes two database servers named SQL1 and SQL2 that run Microsoft SQL Server 2012 Enterprise.
– Wildcard certificates for *.proseware.com and *.proseware-apps.com have been installed on all SharePoint servers.
– Five web applications have been created:
ProseWeb – https://www.proseware.com
PartnerWeb – https://partners.proseware.com
ProductsKB – https://kb.proseware.com
Teams – https://teams.proseware.com
Apps – https://proseware-apps.com
– The SharePoint development team has created a custom web template solution package named ProseWebTemplate.WSP for provisioning the ProseWeb site collection. The package includes a custom template named ProseWeb.
– An instance of a managed metadata service application has been configured with a content type hub. Two enterprise content types named Product Document and Product Image have been published in the content type hub and are available across all web applications and sites.
– All team collaboration site collections for the product development group are contained in a single content database named sp_content_teams_productdev. The database has been restored on SQL1, and upgraded by using the database attach method on the Teams web application. The site collections have not been ungraded.
– All team collaboration site collections for the product development group are referenced under a wildcard managed path at https://teams.proseware.com/productdev.
– The product development marketing team collaboration site is located at https:// teams.proseware.com/productdev/marketing.
– The marketing team has made significant customizations to their team collaboration site by using Microsoft SharePoint Designer.
Business Requirements
The SharePoint 2013 environment must meet the following business requirements:
– Due to export and copyright restrictions, SharePoint sites may be accessed only from within North America.
– The ProseWeb site must display a fixed-width page design for desktop browsers, and a single responsive web design for all mobile devices. The company’s web designers have prepared two site templates that meet these requirements.
– To support the website design layouts, images on the website must be rendered in one of three standard sizes, specified in pixels: Thumbnail (150 x 150), Catalog (300 x 300), and Detail (500 x 500).
– Users must be able to easily copy product-related documents, images, and other files from any team collaboration site to the ProductsKB site. Metadata on content must be preserved when moving or copying content between sites.
– The product development group’s team collaboration site collections must be upgraded.
Technical Requirements
You have the following technical requirements:
– SQL Server connections must use TCP and port 1488.
– Site collection upgrades must be throttled for no more than 20 concurrent upgrades within any content database, and throttled at 10 concurrent upgrades for any web application instance.
– If a site collection has been customized by using SharePoint Designer:
The site collection upgrade must be performed by a farm administrator.
All customizations must be evaluated and verified before performing the upgrade.
– All sandboxed solution code must run on the same server as the original request.
– Requests originating from outside the company network must not be routed to any server running Central Administration.
– SPAPP1 and SPAPP2 must not process user requests for site content and pages.
– You must deploy the custom web template solution as a full-trust farm solution and use the ProseWeb template when creating the root site collection for the ProseWeb web application.
– The ProductsKB site must be provisioned by using a Records Center site template.
QUESTION 99
Hotspot Question
You need to begin configuring services to support solutions.
On the System page of Central Administration, which link should you select? (To answer, select the appropriate link in the answer area.)
Answer:
Explanation:
Note:
* Manage Farm Solutions: This option allows you to manage solutions in the farm.
Again, no change when compared to SharePoint 2010.
QUESTION 100
Drag and Drop Question
You are planning for high availability of the SharePoint environment.
You need to plan the Request Manager configuration.
How should you configure Request Manager? (To answer, drag the appropriate elements to the correct positions 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.)
Answer:
Explanation:
Note:
* From scenario:
/ Due to export and copyright restrictions, SharePoint sites may be accessed only from within North America
Here implemented through the Throttling Rule.
/ Requests originating from outside the company network must not be routed to any server running Central Administration.
/ Central Administration has been provisioned on SPWEB4 and SPADM1.
Here available only for Execution Group 1.
* Throttling Rules
A Throttling Rule is the definition of the criteria to evaluate before refusing requests which match the criteria. Throttling Rules are NOT associated with a Machine Pool or an Execution Group.
Throttling Rules can have an expiry time set.
* Execution Groups
A Execution Group is a collection of Routing Rules which allows the precedence of rule evaluation to be controlled and Routing Rules to be managed in batches. There are three execution groups (0, 1 & 2) which are evaluated in order. If no Execution Group for a Routing Rule is specified it is associated with Execution Group 0.
* SharePoint Server 2013 introduces a new capability called Request Management. Request Management allows SharePoint to understand more about, and control the handling of, incoming requests. Request Management employs a rules based approach, which enables SharePoint to take the appropriate action for a given request based upon administrator supplied configuration.
QUESTION 101
Drag and Drop Question
You are preparing to create the ProductsKB site.
You need to create and configure the ProductsKB site to store product images.
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.)
Answer:
Explanation:
Box 1: Activate the Content Organizer site feature.
Box 2: Create an asset library.
Box 3: Add the Product Image content type to the asset library.
Box 4: Configure a Content Organizer rule on the Product Image content type.
Note:
* The Content Organizer is a SharePoint feature that can automatically manage some important library tasks. This not only saves time, but can help make sure that a document library is managed consistently.
* The Content Organizer can automatically do the following tasks:
/ Route documents to different libraries or folders In effect, the Content Organizer acts as a gatekeeper for documents. Each time that a document is uploaded, the Content Organizer uses rules that you created to determine where it should move the document. Then, it routes the document to the correct library or folder, which can be located in a different site collection. Rules can be based on a combination of content types and metadata.
/ More tasks. Not listed here.
* To determine how to route a document, Content Organizer uses rules that you create. Rules are based on a combination of content types and metadata.
* Before you create rules: First steps
There are several important steps that you have to follow before you create rules for routing documents.
1. Activate the Content Organizer feature.
2. Create libraries and folders that you want documents to be routed to. You might want to create folders for each type of document that you are routing. For example, create a library just for e-mail records or Excel spreadsheets. To learn about how to create libraries, see the links in the See Also section.
3. Content types must be associated with documents that are to be routed. In them, the content type can be part of the criteria that determines the final location where a document is stored.
* Create rules to route documents
For each record type that you add to the Record Routing list, you specify a record title and description. You also specify the location in the site where the record is stored. To make sure that all relevant records are routed to the appropriate location, you can specify alternate names for the record type.
4.On the Site Settings page, under the Site Administration section, click Content Organizer Rules.
Etc.
Reference: Set up an Asset Library to store image, audio, or video files
QUESTION 102
You are configuring the ProseWeb site.
You need to ensure that the site content displays correctly on all devices.
What should you do?
A. Create a composed look and select the Mobile View option.
B. Configure a browser cookie named deviceChannel and set the value to Mobile.
C. Activate the Enable Mobile Views feature on the website.
D. Configure a device channel. Specify the value MSIE10.0 for the device inclusion rule.
E. Configure a device channel. Specify the value $FALLBACKMOBILEUSERAGENTS for the device inclusion rule.
Answer: E
QUESTION 103
You need to upgrade the appropriate site collections.
Which two sets of Windows PowerShell cmdlets should you run? (Each correct answer presents part of the solution. Choose two.)
A. $wa = Get-SPWebApplication https://teams.proseware.com and $wa.SiteUpgradeThrottleSettings.
AppPoolConcurrentUpgradeS essionLimit = 10
B. $db = Get-SPContentDatabase”sp_content_teams_productdev” and Sdb.ConcurrentSiteUpgradeSessionLimit = 40
C. $wa = Get-SPWebApplication https://teams.proseware.com/productdev and $wa.SitellpgradeThrottleSettings.
AppPoolConcurrentUpgradeSessionLimi t = 10
D. $wa = Get-SPWebApplication https://teams.proseware.com and $wa.SitellpgradeThrottleSettings = 10
E. $db = Get-SPContentDatabase”sp_content_teams_productdev” and $db.ConcurrentSiteUpgradeSessionLimit = 20
F. $db = Get-SPContentDatabase “sp_content_teams_productdev” and $db.SiteUpgradeThrottleSettings.
AppPoolConcurrentUpgradeSessionLimit = 20
Answer: AE
Explanation:
A: https://teams.proseware.com
SiteUpgradeThrottleSettings
Throttle Limit 10 : 10 concurrent upgrades for any web application instance
E: SiteUpgradeThrottleSettings
ConcurrentSiteUpgradeSessionLimit = 20
20 concurrent upgrades
* From scenario:
/ Site collection upgrades must be throttled for no more than 20 concurrent upgrades within any content database, and throttled at 10 concurrent upgrades for any web application instance.
QUESTION 104
You are preparing to migrate to the new SharePoint environment.
You need to configure SQL Server connectivity.
What should you do?
A. Configure a SQL Server client alias.
B. Configure a CNAME alias for SQL1.
C. Configure Request Management and specify a routing rule for database connections.
D. Configure a SQL Server failover cluster.
Answer: A
QUESTION 105
Drag and Drop Question
You are configuring the ProseWeb site.
You need to create the root site collection on the web application.
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.)
Answer:
Explanation:
Note:
* Add-SPSolution uploads a SharePoint solution package to the farm.
* The Install-SPSolution cmdlet deploys an installed SharePoint solution in the farm.
Use the Add- SPSolution cmdlet to install a SharePoint solution package in the farm.
The 70-332 PDF dumps and 70-332 practice test with free VCE player are available on GreatExam now. Get a complete hold of them through GreatExam to give your career a boost and start earning your Microsoft certification today!