Want to Pass 70-332 Exam In Next HOURS? Download Now →
January 12, 2018

Shortcuts To 70-332(1 to 17)


Free Instant Download NEW 70-332 Exam Dumps (PDF & VCE):
Available on: https://www.certshared.com/exam/70-332/


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

Answer:


Q2. HOTSPOT - (Topic 6) 

You are designing a SharePoint search solution. 

The search solution must meet the following requirements: 

. Run search queries against specific SharePoint columns. 

. Run search queries against specific document properties. You need to ensure the search solution meets the requirements. 

What should you do? (To answer, select the appropriate option from each drop-down list in the answer area.) 

Answer: 


Q3. DRAG DROP - (Topic 6) 

A company is implementing a SharePoint farm that will contain six servers. 

The farm architecture design must meet the following requirements: 

. Distribute incoming user requests equally. 

. Provide high availability. 

You need to distribute the servers and roles to meet the requirements. 

How should you distribute the servers and roles? (To answer, drag the appropriate server or role to the correct location or locations in the answer area. Each server or role 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: 


Q4. HOTSPOT - (Topic 6) 

You have a Windows SharePoint Services 3.0 server farm. 

You plan to perform the following tasks: 

. Upgrade the Windows SharePoint Services 3.0 farm to Microsoft SharePoint 

Foundation 2010. 

. Upgrade SharePoint Foundation 2010 to SharePoint Server 2010. 

. Upgrade SharePoint Server 2010 to SharePoint Server 2013. 

You need to recommend an upgrade method for each task. The solution must use in-place upgrades, whenever possible. 

Which method should you recommend for each task? {To answer, select the appropriate upgrade method for each task in the answer area.) 

Answer: 


Q5. - (Topic 6) 

An organization has created graphic designs that will be used for branding in a SharePoint farm. 

You need to develop the supporting assets required to implement the design in the minimum amount of time. 

What should you use? 

A. Design Manager 

B. Asset Manager 

C. SharePoint channels 

D. Master Page conversion 

Answer:

Explanation: Design Manager in SharePoint 2013 provides a new approach for designing websites. Several new branding and design-based capabilities available in Design Manager enable you to create a compelling look, feel, and behavior for your SharePoint 2013 site. Design Manager also supports importing and exporting a visual design, and can help you ensure a consistent visual experience across all device platforms in your organization. 

Incorrect: 

Not C: With device channels in SharePoint 2013, you can render a single publishing site in multiple ways by using different designs that target different devices. 


Q6. DRAG DROP - (Topic 6) 

You are a SharePoint architect for Contoso, Ltd. Contoso has a SharePoint 2010 farm that contains four site collections. Three site collections are available only inside the company network. The fourth site collection is available to an external partner company by using forms-based authentication. The external site collection is used to store contracts and purchase orders. Every site collection has its own content database. 

Contoso purchases an Office 365 subscription for external partner employees. Contoso plans to move the external site collection to SharePoint Online. You have the following requirements: 

Upgrade the external partner site collection to SharePoint Online. 

Upgrade the on-premises farm to SharePoint 2013. 

Minimize downtime for the upgrade. 

Ensure the sites are read-only during the upgrade. 

You need to plan the upgrade for the extranet site. 

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: 


Q7. - (Topic 5) 

You need to resolve the SharePoint database error. 

What should you do? 

A. Add a new request URL mapping to the web application. 

B. Remove the orphaned objects from the database. 

C. Set the databases to read-write. 

D. Add the managed path for the site collection to the web application. 

Answer:

Explanation: 

. ERROR Template.Template Id: SPSite Id=Site Id.could not be accessed due to exception. Skipping SPWeb Id=Web Id.for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id.Site Id.could not be found. 

This error indicates that a managed path is missing. Add the managed path for the site collection into the web application and restart upgrade for the content database that contains this site collection. 

Ref: http://technet.microsoft.com/en-us/library/cc262967(v=office.15).aspx 


Q8. HOTSPOT - (Topic 6) 

You have a SharePoint Server 2013 server farm. 

The farm contains a site that has the URL https://products.contoso.com. 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 https://products.contoso.com 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. 

Answer: 


Q9. - (Topic 5) 

You need to configure authentication for the WebApp1 application pool account. 

What should you do? 

A. Add the application pool account to the db_owner fixed database role in the Master database. 

B. Add the application pool account to a contained database. 

C. Copy the application pool account from the primary replica databases to the secondary replica databases. 

D. Re-create the application pool account in SharePoint Server 2013. 

Answer:


Q10. - (Topic 4) 

You need to configure the Send To connection. 

Which URL should you specify? 

A. https://kb.proseware.com/dropofflibrary 

B. https://kb.proseware.com/_vti_bin/officialfile.asmx 

C. https://teams.proseware.com/_vti_bin/copy.asmx 

D. https://teams.proseware.com/_vti_bin/officialfile.asmx 

Answer:

Explanation: * From scenario: 

/ The ProductsKB site must be provisioned by using a Records Center site template. 

/ ProductsKB - https://kb.proseware.com 

* We should append _vti_bin/officialfile.asmx as a default to the URL. 

Reference: SharePoint 2010 Document Center Send To Connection Setup Walkthrough 


Q11. - (Topic 6) 

You deploy SharePoint Server 2013. 

You need to install a SharePoint hosted app named App1 in a site. 

Which Windows PowerShell cmdlet should you run? 

A. Install-SPSolution and then run Add-SPSolution 

B. Import-SPAppPackage and then run Install-SPApp 

C. Add-SPSolution and then run Install-SPSolution 

D. Install-SPAppPackage and then run Import-SPApp 

Answer:

Explanation: The Add-SPSolution cmdlet adds a SharePoint solution package to the farm. This cmdlet does not deploy the uploaded SharePoint solution. Use the Install-SPSolution cmdlet to deploy the SharePoint solution in the farm. 

Example: 

Install-SPSolution -Identity contoso_solution.wsp -GACDeployment -CompatibilityLevel {14,15} 

This example deploys the installed SharePoint solution installs a previously addedsolution so it can be used correctly in both 14 and 15 mode site collections. 


Q12. - (Topic 6) 

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. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage. 

C. Run the SQL Server 2012 setup package. 

D. Run the SQL Server 2008 R2 SP1 setup package. 

Answer:


Q13. HOTSPOT - (Topic 6) 

You develop an application that generates PDF files from an XML content stream. 

You need to create a service application to support the file conversion efforts. 

Which service application should you create? (To answer, select the appropriate service application in the answer area). 

Answer: 


Q14. DRAG DROP - (Topic 6) 

A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The company uses a third-party application to process payroll data and view payroll reports. The third-party application uses SQL Authentication. Payroll administrators currently use custom credentials to sign in to the payroll application. 

You have the following requirements: 

. Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports from within SharePoint. . Payroll administrators must not be required to enter credentials when accessing payroll data. . The Secure Store must be configured for high security and high process isolation. 

You need to configure the Secure Store to meet the requirements. 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: 


Q15. - (Topic 6) 

Members of the Sales team store Microsoft Excel workbooks and other files on a SharePoint team site. The workbooks do not access external data. 

When Sales team members attempt to open workbooks from the team site, they receive an error message stating that the workbook cannot be opened. 

You need to configure the SharePoint farm to ensure that users can open Excel workbooks. 

What should you do? 

A. Set Trusted File Locations for Excel Services. 

B. Add members to a Secure Store target application. 

C. Set the Excel Calculation Services authentication method to Impersonation. 

D. Grant members Read permission to the Sales team site. 

Answer:


Q16. DRAG DROP - (Topic 1) 

You need to configure authentication for the Tailspin360.TailspinToys.com site. 

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: 


Q17. - (Topic 6) 

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: