Test your preparation for Microsoft 70-332 with these actual 70-332 questions below. Exam questions are a sure method to validate one’s preparation for actual certification exam.
QUESTION 36
A company has two SharePoint farms as described in the following table.
You need to process incoming server requests on HRFarm that originate from FinanceFarm. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Configure both farms to use Secure Sockets Layer (SSL) connections.
B. Run the Windows PowerShell cmdlet New-SPTrustedSecurityTokenlssuer on a server in FinanceFarm.
C. Run the Windows PowerShell cmdlet New-SPTrustedSecurityTokenlssuer on a server in HRFarm.
D. Log on as a member of the Administrators group on a server in HRFarm.
E. Run the Windows PowerShell cmdlet Get-SPTrustedSecurityTokenIssuer -Identity FarmA on a server
in HRFarm.
Answer: ACD
Explanation:
C (not B):
New-SPTrustedSecurityTokenIssuer
Creates a trust between a server to server principal. Use the New-SPTrustedSecurityTokenIssuer cmdlet to establish a trust between a server to server principal.
QUESTION 37
You are migrating a SharePoint Server 2010 My Site site collection to SharePoint Server 2013 by using the database attach method.
You copy the content databases to the SharePoint 2013 farm.
You need to verify that all required objects have been successfully added to the SharePoint 2013 farm before upgrading the content database.
What should you do?
A. In the SharePoint 2013 site collection, run the site collection health checks.
B. Run the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2013 farm.
C. Run the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2010 farm.
D. In the SharePoint 2010 site collection, run the site collection health checks.
E. Run the Windows PowerShell cmdlet Mount-SPContentDatabase on the SharePoint 2010 farm.
F. Run the Windows PowerShell cmdlet Mount-SPContentDatabase on the SharePoint 2013 farm.
Answer: B
QUESTION 38
You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site.
The Unified Logging Service (ULS) log contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database “WSS_Content_Portal_Content_Database” requested by the login. The login failed. Login failed for user ‘LITWARE\svcExcelService’.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?
A. $sa = Get-SPServiceApplication | where {$_.TypeName -eq “Excel Services Application Web Service Application”} and $sa.GrantContentDatabasePermissions(“WSS_Content_Portal_Content_Database”)
B. Add SPShellAdmin -UserName LITWARE\svcExcelService
C. Add SPShellAdmin -UserName LITWARE\svcExcelService -database WSS_Content_Portal_Content_Database
D. $wa = Get-SPWebApplication https://portal.litware.com and $wa.GrantToProcessIdentity(“LITWARE \svc
ExcelService”)
Answer: D
QUESTION 39
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?
A. On the SQL Server, configure a named instance.
B. On all servers in the farm, configure a SQL Server alias.
C. On all servers in the farm, configure SQL Server database mirroring.
D. Create a single-node SQL Server cluster.
Answer: B
QUESTION 40
A company plans to use eDiscovery in SharePoint.
The environment includes Microsoft Lync Server 2013 and Microsoft Exchange Server 2013.
Lync Server is configured to archive conversations to Exchange Server.
You configure Exchange Server for eDiscovery.
You need to complete the eDiscovery configuration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Configure a trust relationship between SharePoint Server and Lync Server.
B. Create a SharePoint connector in the Exchange Server management shell.
C. Install the SharePoint Web Services API on every server that runs Exchange Server.
D. Configure a trust relationship between SharePoint Server and Exchange Server.
E. Install the Exchange Web Services API on every SharePoint front-end web server.
F. Create an Exchange eDiscovery service application in Central Administration.
Answer: DE
Explanation:
* If you will use a SharePoint eDiscovery Center to discover content in Exchange Server, you must configure SharePoint Server 2013 and Exchange Server to interact.
Perform the following steps:
(E) Ensure that the Exchange Web Service managed API is installed on every front-end server that is running SharePoint Server 2013. (D) Configure a trust relationship between Server 2013 and Exchange Server. If you want content from Lync Server 2013 to be discoverable, configure Lync Server 2013 to archive to Exchange Server 2013. (this step has already been done here)
Perform the eDiscovery configuration steps for Exchange. (this step has already been done here)
Reference: Configure communication between SharePoint Server 2013 and Exchange Server 2013
QUESTION 41
You are creating a SharePoint site that will be accessed remotely.
You need to optimize the SharePoint experience for all mobile devices.
What should you configure?
A. Custom list views
B. Image renditions
C. Variations
D. Design Manager
E. Device channels
Answer: E
QUESTION 42
You perform the basic configuration of a SharePoint site to support SharePoint apps.
You need to configure policy settings for SharePoint apps to ensure that users can browse apps in the Office Store but cannot purchase apps without approval.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. In Central Administration, configure the Office and SharePoint store settings to restrict app purchases.
B. Purchase and configure a wildcard SSL certificate for the domain from a third-party Trusted Root Certification Authority (CA).
C. In Central Administration, specify the URL to the App Catalog site.
D. In each site collection, configure the site app permissions to restrict app purchases.
E. Restrict the users and groups that have Approve permissions on the App Catalog site.
Answer: AC
Explanation:
Configure app requests and SharePoint Store settings Farm administrators can determine whether users can purchase apps from the SharePoint Store. This setting is at the web application scope. If users cannot purchase apps, they can still browse the SharePoint Store, and request an app. Farm administrators and the App Catalog site owner can view and respond to app requests.
To configure SharePoint Store settings
If you want to switch to a different web application, click the down arrow next to the web application URL to change to a different web application. (C) Reference: Manage the App Catalog in SharePoint 2013
QUESTION 43
You are configuring a SharePoint environment to support SharePoint apps for Litware, Inc.
The SharePoint servers use a load-balancer for incoming requests.
You need to ensure that all connections to the SharePoint servers are secure and encrypted. What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)
A. Create a DNS CNAME record forsc.LitwareApps.com.
B. Create an SSL certificate for the AppHost.LitwareApps.com domain.
C. Create a wildcard SSL certificate for =c.LitwareApps.com.
D. Create a DNS forward lookup zone for the LitwareApps.com domain.
E. Create a DNS A record for AppHost.LitwareApps.com that points to the IP address of the load- balancer.
Answer: ACD
Explanation:
A: You must create a new domain name in Domain Name Services (DNS) to host the apps.
To help improve security, the new domain name should not be a subdomain of the domain that hosts the SharePoint sites.
Depending on your configuration, you might have to create a new forward lookup zone first, or you can start with a wildcard CNAME entry in the same zone as the SharePoint site domain.
Note:
To create a wildcard Alias (CNAME) record for the new domain name
1. Verify that the user account that performs this procedure is a local administrator on the domain controller.
2. In DNS Manager, right-click the name of domain that hosts the SharePoint sites, and then click New Alias (CNAME).
3. In the New Resource Record dialog box, in the Alias name (uses parent domain if left blank) box, type *. followed by the domain name that you want to use for apps. For example, *.ContosoApps.com or *.Contoso-Apps.com.
Etc.
C: If you are using Secure Sockets Layer (SSL), you must either create an SSL certificate or add the new domain to your existing SSL certificate.
* Create an SSL certificate if you are using a different root domain (for example, ContosoApps.com).
* Add the new app domain to an existing SSL certificate if you are using the same room domain (for example. Apps.Contoso.com).
Either way, the domain should be added in the form of a wildcard (for example, *.contosoapps.com).
You need a wildcard certificate instead of individual certificates because each installed app has its own subdomain.
Note:
* Wildcard DNS should point to the load balancer.
Reference: Deployment Guide for Microsoft SharePoint 2013, Configure an environment for apps
QUESTION 44
A company uses a data-connected Microsoft Excel workbook to build reports from external data sources. Data is not refreshed when the workbook is displayed in a browser.
You need to ensure that users can refresh Excel workbooks that are displayed in a browser. Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)
A. Configure the Secure Store service application for the Excel workbook.
B. Embed the data connection information directly in the Excel workbook.
C. Create a trusted data connection library and add a data connection file.
D. Add the document library containing the Excel workbook to the Trusted File Locations list.
E. Create a Group Policy Object that adds the SharePoint URL to the Trusted Sites zone in Windows
Internet Explorer.
Answer: AB
Explanation:
To configure Excel Services data access to use embedded data connections, you use the following process:
Configure a data access account
(A) Create a Secure Store target application
(B) Configure a workbook to use an embedded data connection
A: You must create a target application in Secure Store that contains the credentials that you created for data access. This target application can then be specified in data-connected Excel workbooks and will be used by Excel Services when it refreshes data in the workbook.
B: Configure a workbook to use an embedded data connection
You must configure the Excel Services Authentication Settings in the workbook before you publish it to SharePoint Server 2013. Doing so enables the workbook to use a Secure Store target application to refresh data that is rendered using Excel Services. Use the following procedure to configure the authentication settings.
Note:
* Excel Services in SharePoint Server 2013 provides three methods of using Secure Store Service to refresh the external data source in a workbook:
/ You can use an unattended service account.
/ You can specify a Secure Store target application in a workbook. (This is known as an embedded connection.)
/ You can use an Office Data Connection (ODC) file that specifies a Secure Store target application.
This article describes how to do this.
Reference: Configure Excel Services data refresh by using external data connections in SharePoint Server 2013
QUESTION 45
A SharePoint deployment includes the content source described in the following table.
You need to configure the intranet site content source to return search results without impacting availability.
What should you do?
A. Add an additional index server to the farm.
B. Reset the search index.
C. Configure continuous crawling.
D. Configure an incremental crawl to run every day.
E. Configure an incremental crawl to run every 30 minutes.
F. Configure on-demand crawling.
Answer: C
QUESTION 46
A company named Contoso, Ltd. has a SharePoint 2010 site collection at www.contoso.com.
You are preparing to upgrade the site collection to SharePoint 2013. The root site collection has had extensive customizations made to pages by using SharePoint Designer.
You need to test the site collection customizations before the upgrade.
What should you do?
A. Use the visual upgrade feature in preview mode.
B. Use the page upgrade feature in preview mode for each customized page.
C. Run the Get-SPSite -identity http://www.contoso.com | $_.GetVisualReport() | Format-Table Windows PowerShell cmdlet.
D. Request an upgrade evaluation site collection.
Answer: D
QUESTION 47
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?
A. Define an individual target application in the Secure Store that contains Exchange connection information.
B. Configure server-to-server authentication between SharePoint and Exchange.
C. Configure alternate access mappings in SharePoint and Exchange.
D. Create an external content type for Exchange mailbox information.
Answer: B
QUESTION 48
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. 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;
B. 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
C. Run the following Windows PowerShell cmdlets for each web application in the SharePoint 2010 farm you plan to upgrade. $db = Get-SPContentDatabase<web application name> Set- SPContentDatabase$db -Status Offline
D. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. EXEC sp_dboption<database name>, “read only”, “True”;
Answer: A
QUESTION 49
Drag and Drop Question
An organization has an Active Directory Domain Services (AD DS) domain and a SharePoint intranet site.
You need to ensure that only members of the AD DS security group named Managers can create personal sites.
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:
Box 1: Sign in to Central Administration
Box 2: Manage settings for the User Profile service application.
Box 3: Configure user permissions for the User Profile service application
Note:
* SharePoint Server 2013 includes several changes to the User Profile service application settings in Central Administration to support new My Sites functionality.
*Configure permissions for personal and social
The Manage User Permissions page contains new and updated settings for the User Profile service application. You can select one or more of the following permissions for users and groups that you want to grant permission to personal and social features:
/ Create Personal Site (required for personal storage, newsfeed, and followed content) This permission enables users to create personal sites to store their documents, newsfeed, and followed content.
/ Follow People and Edit Profile This permission enables users to follow people from their My Site and to edit their personal profile.
/ Use Tags and Notes This permission enables users to use the Tags and Notes feature from SharePoint Server 2010.
Reference: Explore Microsoft SharePoint 2013
QUESTION 50
Drag and Drop Question
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.)
Answer:
Explanation:
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-SPFarm cmdlet 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
These Microsoft 70-332 exam questions are all a small selection of questions. If you want to practice more questions for actual 70-332 exam, use the links at the end of this document. Also you can find links for 70-332 exam practice test software that is great for preparation and self-assessment for Microsoft 70-332 exam.
http://www.greatexam.com/70-332-exam-questions.html