Top Microsoft 70-332 training tools Choices

Exam Code: 70-332 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Advanced Solutions of Microsoft SharePoint Server 2013
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-332 Exam.


Free VCE & PDF File for Microsoft 70-332 Real Exam
(Full Version!)

Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions

Free Instant Download NEW 70-332 Exam Dumps (PDF & VCE):
Available on:

Q51. – (Topic 6) 

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 for * 

B. Create an SSL certificate for the domain. 

C. Create a wildcard SSL certificate for * 

D. Create a DNS forward lookup zone for the domain. 

E. Create a DNS A record for that points to the IP address of the load-balancer. 

Answer: A,C,D 

Explanation: * 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. 


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 clickNew 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, * or * Etc. 

* 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, 

* Add the new app domain to an existing SSL certificate if you are using the same room domain (for example. 

Either way, the domain should be added in the form of a wildcard (for example, 

* You need a wildcard certificate instead of individual certificates because each installed app has its own subdomain. 

* Wildcard DNS should point to the load balancer. 


Reference: Deployment Guide for Microsoft SharePoint 2013, Configure an environment for apps 

Q52. – (Topic 6) 

You are creating a SharePoint site that will be accessed from the following devices: 

Client computers 

Windows Phone devices 

Windows 8 RT devices 

You need to optimize the SharePoint experience for the listed devices. 

What should you configure? 

A. Device channels 

B. Image renditions 

C. Design Manager 

D. Custom list views 

E. Variations 


Q53. – (Topic 6) 

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. 


Q54. HOTSPOT – (Topic 6) 

You have a SharePoint Server 2013 server farm. 

The farm contains a site that has the URL The site contains a master product list that is generated by using a Business Data Connectivity Service. The Business Data Connectivity Service retrieves data from the web services of several suppliers. The site also contains product documentation stored as Microsoft Word documents. 

The president of your company sends you the following email message: "The product list at changes frequently. Our management and sales teams also make hundreds of changes to product documentation daily. I want to confirm that all of the data is backed up frequently." 

The database administrator sends you the following email message: "We are performing daily incremental backups of Microsoft SQL Server at noon and at midnight. Also, we are performing a full backup of SQL Server on Saturday at 06:00. I'm hoping that this is sufficient." 

The director of IT services sends you the following email message: "The company cannot afford to lose 12 hours of data if an issue occurs. We need to ensure that no more than the last two hours of data for the product list in SharePoint is lost if a server fails. The product documentation does not change as often as the product list, however, no more than the last four hours of product documentation in SharePoint can be lost if an issue occurs." 

Select Yes if the statement can be shown to be true based on the available information; otherwise select No. 


Q55. – (Topic 6) 

You have a ShafePoint Server 2013 server farm that has Excel Web Services deployed. 

A user has a Microsoft Excel spreadsheet that uses a dynamic-link library (DLL) to perform custom calculations. 

The user plans to upload the spreadsheet to the farm. 

You need to ensure that when the spreadsheet is rendered by Excel Web Services, the custom calculations are performed. 

What should you add? 

A. A new trust relationship 

B. The DLL to the global assembly cache 

C. A trusted data provider 

D. A user-defined function assembly 


Explanation: Excel Services User-Defined Functions (UDFs) Strong Name Dependencies In some cases, a user-defined function (UDF) assembly depends on other assemblies that are deployed with it. These dependent DLLs load successfully if they are in the global assembly cache, or if they are located in the same folder as the UDF assembly. 

Reference: Excel Services Best Practices 

Q56. – (Topic 2) 

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. 


Q57. DRAG DROP – (Topic 6) 

You have a custom solution named SalesSolution deployed to the URL 

You need to deploy a new version of the solution without retracting the previous version. 

How should you complete the Windows PowerShell cmdlet? (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.) 


Q58. – (Topic 2) 

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.AllowSelfServiceUpgrade = false 

B. $reports = Get-SPSite "" 

C. $reports.AllowSelfServiceUpgrade 

D. $reports = Get-SPWebApplication "" 

E. Sreports.AllowSelfServiceUpgrade = true 

Answer: A,B 

Explanation: * At the Windows PowerShell command prompt, type the following command 

to view the self-service upgrade setting for a site collection: 




<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. 


* From scenario: 

/ A site collection named Report Center has been created at http:// 

/ 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. 


D: Get-SPWebApplication Returns all Web applications that match the given criteria. The Get-SPWebApplicationcmdlet 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 

Q59. DRAG DROP – (Topic 6) 

You administer a SharePoint 2013 farm for Contoso, Ltd. 

Company policy requires that minimal permissions are granted to users to perform their tasks. 

You need to add User1 as Full Control on the User Profile Service Application. 

How should you complete the relevant Windows PowerShell commands? To answer, 

select the appropriate Windows PowerShell segment from each list in the answer area. 


Q60. – (Topic 2) 

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.