70-332 Exam Dumps Free Shared By Braindump2go For Instant Download Now! Download Latest 70-332 Exam Questions and pass 70-332 one time easily! Do you want to be a winner?
Vendor: Microsoft
Exam Code: 70-332
Exam Name: Microsoft Advanced Solutions of Microsoft SharePoint Server 2013
Keywords: 70-332 Exam Dumps,70-332 Practice Tests,70-332 Practice Exams,70-332 Exam Questions,70-332 PDF,70-332 VCE Free,70-332 Book,70-332 E-Book,70-332 Study Guide,70-332 Braindump,70-332 Prep Guide
QUESTION 81
You need to provision a SharePoint environment for MyTailspin.TailspinToys.com.
What should you do?
A. Create a web application and a site collection using the My Site Host template.
B. Create a web application, a site collection using the My Site Host template, and site collections
for each user.
C. Configure the User Profile Synchronization service to perform a full import of AD DS user profiles.
D. Configure the User Profile Synchronization service to set up a My Sites site collection.
Answer: A
QUESTION 82
Drag and Drop Question
You need to design the architecture of the farm.
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:
* From scenario:
/ The farm must be made fault tolerant by using virtualization.
/ The farm must include two front-end web servers.
/ All content must remain available to users if one of the front-end web servers becomes unavailable. (not put them on the same Hyper-V host) / Page requests must be distributed equally across the front-end web servers. / All customer, order, and product information will be stored in tables in a Microsoft SQL Server database.
Need to use Microsoft SQL Server.
QUESTION 83
You need to configure the BCS model to access data. What should you do?
A. Import the BCS model and enter the required account by using the Set Object Permissions command.
B. Create an external content type and enter the target application ID in the Secure Store Application ID field.
C. Create an external content type and choose the Connect with user’s identity option.
D. Create an external content type and choose the Connect with impersonated custom identity option.
Enter the target application friendly name of the Secure Store target application.
Answer: B
Case Study: 2 – World Wide Importers (QUESTION 84 – QUESTION 90)
Background
General Background
Wide World Importers plans to upgrade from SharePoint 2010 to SharePoint 2013 to take advantage of additional business intelligence (BI) services, including PerformancePoint Services, PowerPivot for Excel, and SQL Server Reporting Services 2012 (SSRS). All users are members of an Active Directory Domain Services (AD DS) domain.
Technical Background
The current environment integrates with a stand-alone instance of Microsoft SQL Server 2008 R2 Analysis Services (SSAS). Wide World Importers has acquired SQL Server 2012 licenses for the purpose of upgrading all the SQL Server instances to SQL Server 2012.
Business Requirements
The SharePoint 2013 environment and supporting back-end servers that run SQL Server must be highly available and redundant in the case of unplanned downtime or a disaster.
Technical Environment
SharePoint 2013 Production Farm Topology
The SharePoint 2013 production farm topology consists of the servers listed in the following table.
The Wide World Importers SharePoint 2013 environment has the following characteristics:
– A hardware load-balancer is configured to balance traffic between PROD-WEB-01 and PROD-WEB-02.
– SSRS is installed on PROD-APP-01 in SharePoint integrated mode.
– SSRS report databases are stored on PROD-DB-01.
– A site collection named Report Center has been created at http:// reports.wideworldimporters.com.
– All SharePoint content and configuration databases are stored on PROD-DB-01.
– All site collections have been migrated to a single content database named WSS_Content.
– A content database named WSS_TempContent has been restored to PROD-DB-01, but not attached to the SharePoint 2013 farm.
– An AD DS domain user account named PPS_SVC has been created.
SharePoint 2013 Disaster Recovery Site
The SharePoint 2013 Disaster Recovery farm topology consists of the servers listed in the following table.
Technical Requirements
– Log shipping must be used to send transaction log backups to the instance of SQL Server that is running in the disaster recovery site.
– Discrete sets of SharePoint content databases must be configured to automatically failover together.
– An additional SQL Server 2012 Report Server must be added to the SharePoint 2013 environment. The server must be configured to use SharePoint integrated mode.
– Additional SQL Server 2012 Report Servers must not be installed on machines that are running SharePoint as a front-end web server.
– 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.
– A daily backup schedule must be created to perform SQL Server backups of all SharePoint content and configuration databases.
– The PPS_SVC AD DS user account must be used for the PerformancePoint service application.
– Farm administrators must be able to recover content from WSS_TempContent without attaching the database to the farm.
– All content databases within the production farm must be set to read-only when patching and upgrading the farm.
– Farm administrators must be able to determine which sites were missed or skipped during the upgrade process and must be able to monitor any future upgrades.
QUESTION 84
You need to meet the content recovery requirements for the farm.
What should you do?
A. Run the Windows PowerShell cmdlet Get-SPUnattachedContentDatabase -DatabaseName
“WSS_TempContent”
B. Run the Windows PowerShell cmdlet Get-SPContentDatabase -Con nectAsUnattached Data
base – DatabaseName “SharePoint_Config”
C. Use the Recover data from an unattached content database option in Central Administration.
D. Use the Export a site or list option in Central Administration.
Answer: A
QUESTION 85
Drag and Drop Question
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.)
Answer:
Explanation:
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
Reference: Run a farm that uses read-only databases in SharePoint 2013
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.
Braindump2go Offers PDF & VCE Dumps Download for New Released Microsoft 70-332 Exam! 100% Exam Success Guaranteed OR Full Money Back Instantly!
