Official 2014 Free Microsoft 70-332 Questions Sharing(1-10)!
You are configuring SharePoint 2013 to support business intelligence. You need to install PowerPivot for SharePoint. What should you do?
A. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2008 R2 SP1
Feature Pack webpage.
B. Run the SQL Server 2008 setup package.
C. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 Feature
D. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature
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?
A. Create a SharePoint team site.
B. Provision a Microsoft Project web app.
C. Create a SharePoint task list.
D. Import a Microsoft Excel spreadsheet as a custom list.
You are implementing a claims-based authentication solution for a SharePoint farm in an Active Directory Domain Services domain. You install and configure Active Directory Federation Services (AD FS). You need to ensure that all web applications in the farm support SAML-based claims authentication. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Configure AD FS with the web application as a relying party.
B. Configure web applications to use forms-based authentication and AD FS as the trusted identity provider.
C. Configure web applications to use claims-based authentication and AD FS as the trusted identity provider
D. Configure web applications to use classic mode authentication and AD FS as the trusted identity provider.
E. Configure SharePoint to trust AD FS as an identity provider.
Configure SAML-based claims authentication with AD FS in SharePoint 2013. This configuration has the following phases that must be performed in consecutive order:
Phase 1: Install and configure an AD FS server
(A) Phase 2: Configure AD FS with the web application as a relying party (E) Phase 3: Configure SharePoint 2013 to trust AD FS as an identity provider (C) Phase 4: Configure web applications to use claims-based authentication and AD FS as the trusted identity provider
Reference: Configure SAML-based claims authentication with AD FS in SharePoint 2013
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?
A. Install all custom applications in the destination farm.
B. Copy all custom master pages from the source site collection to the Style Library in the destination
C. Copy all SharePoint groups and users from the source farm to the destination farm.
D. Copy all custom master pages from the source site collection to the master page gallery in the destination
An organization upgrades a SharePoint 2010 environment to SharePoint 2013. A site collection is running in SharePoint 2010 compatibility mode. You must verify that the following features will function correctly when the site collection is upgraded to SharePoint 2013 native mode:
• List views
• Custom web parts
• Content query web parts
You need to ensure that you can perform verification testing without impacting the current user experience. What should you do?
A. Upgrade the site collection to SharePoint 2013.
B. Perform a database attach upgrade.
C. Enable the Visual Upgrade option for the site collection.
D. Generate an upgrade evaluation site collection.
Drag and Drop Question
A company plans to upgrade from a SharePoint Server 2010 farm to a SharePoint Server 2013 farm. You plan to install components that are required on the new farm before upgrading. You need to identify the customizations that must be installed on the new farm. Which command should you run? (To answer, drag the appropriate command and switch to the correct locations in the answer area.)
Identify all server-side customizations and install them before you upgrade One common error during upgrade is missing server-side files — either files that were installed with SharePoint 2010 Products or customized files. When you prepared for upgrade, you should have created an inventory of the server-side customizations (such as site definitions, templates, features, Web Parts, assemblies) that your sites required. Check this inventory to make sure that all the files that are needed for your customizations are installed in your new environment. You can use the enumallwebs operation in Stsadm.exe to identify server-side customizations that are being used.
Drag and Drop Question
An organization migrates a SharePoint environment from SharePoint 2010 to SharePoint 2013. The organization has a web application at http://intranet.contoso.com. A corporate governance policy states that users of the web application must be able to create sites only with a compatibility level of SharePoint 2013. You need to implement the governance policy. Which three Windows PowerShell cmdlets should you run in sequence? (To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.)
* RangeName is one of the following values: OldVersions, NewVersion, AllVersions. Here we must NewVerssion as ” the web application must be able to create sites only with a compatibility level of SharePoint 2013″.
* The last step is to validate.
* At the Windows PowerShell command prompt, type the following command to change the compatibility range settings to a specific range:
# Stores the web application at that URL as a variable $wa.CompatibilityRange = [Microsoft.SharePoint.SPCompatibilityRange]::<RangeName> # Specifies which range to use
# Updates the CompatibilityRange setting to use only the range you specified $wa.CompatibilityRange
# Returns the new CompatibilityRange for the web application Where:
<URL> is URL for the web application that you want to change. RangeName is one of the following values: OldVersions, NewVersion, AllVersions. Reference: To change compatibility range for site creation modes for a web application by using Windows PowerShell
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 Transact-SQL (T-SQL) statement for each content database and service application
you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;
C. Run the following command-line tool for each site collection in the content databases you plan to upgrade.
Stsadm -o setsitelock -urKsite collection name> -lock readonly
D. Sign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each
content database and service application database to Read-Only.
Drag and Drop Question
You are preparing to upgrade from a SharePoint 2010 environment to a SharePoint 2013 environment. The SharePoint 2010 environment includes a large number of content databases. You restore backups of the content databases to the Microsoft SQL Server instance in the SharePoint 2013 environment. You need to upgrade all content databases and minimize monitoring 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.)
* To attach a content database to a web application by using Windows PowerShell Start the SharePoint 2013 Management Shell.
At the Windows PowerShell command prompt, type the following command and then press ENTER:
Mount-SPContentDatabase -Name DatabaseName -DatabaseServer ServerName – WebApplication URL
* Attach the remaining databases (no need to wait until first command finishes and use new instance)
After you restore the first content database and verify success, you can continue to restore and upgrade other databases. You can perform parallel database attach upgrades to upgrade more than one database at a time. Use separate Command Prompt windows (i.e new instance) to run multiple upgrades. It is recommended that you separate the start time for each new database upgrade session by several minutes to prevent issues with temporary locks set for the web application during attachment. Otherwise you might receive an error on the upgrade session. The wait time to clear temporary locks varies depending on the number of site collections, or the speed of the database server hardware.
Reference: Upgrade content databases to SharePoint
Drag and Drop Question
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.)
* (step 1) If you already installed and configured SharePoint Server 2013 and you would like to try out Project Server 2013 features there’s no need to install another SharePoint server. You can simply integrate between Project Server 2013 and SharePoint Server 2013 using an existing site collection.
Project Server 2013 runs as a service application under SharePoint 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 on all application servers in your farm before 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 a name for the service application and 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” -DatabaseServer SQLServerInstance -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
If you want to pass the Microsoft 70-332 Exam sucessfully, recommend to read latest Microsoft 70-332 Dump full version.