Q1. - (Topic 6)

You are managing a SharePoint farm in an Active Directory Domain Services (AD DS) forest.

The forest contains two domains named americas.contoso.com and europe.contoso.com. A single SharePoint farm is located in the americas.contoso.com domain and uses Kerberos authentication.

Users in the europe.contoso.com domain cannot access the Excel Services application in the americas.contoso.com domain when using an external data source.

You need to ensure that users in the europe.contoso.com domain can use the Excel Services application with external data sources.

What should you do?

A. Deploy a SharePoint farm in the europe.contoso.com domain.

B. Configure Kerberos constrained delegation.

C. Configure basic Kerberos delegation.

D. Configure anonymous access in the SharePoint farm.

View Answer

Q2. DRAG DROP - (Topic 12)

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

View Answer

Q3. - (Topic 6)

You are managing a SharePoint farm. The SharePoint databases are configured to run on a dedicated instance of Microsoft SQL Server 2008 R2 Service Pack 1.

You need to optimize query executions. What should you do?

A. Move the master database to a RAID 10 volume.

B. Set the maximum degree of parallelism for SQL Server instances to 0.

C. Set the maximum degree of parallelism for SQL Server instances to 4.

D. Set the maximum degree of parallelism for SQL Server instances to 1.

View Answer

Q4. - (Topic 12)

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.

View Answer

Q5. HOTSPOT - (Topic 6)

You have a SharePoint server 2013 server farm.

Users report that the past week, some pages were slow to render.

You need to identify the 10 pages in the farm that take the longest to load.

Which link should you select? (To answer, select the appropriate link in the answer area.)

View Answer

Q6. DRAG DROP - (Topic 6)

A company has a multi-tenant SharePoint environment that includes a web application named WebApp1. WebApp1 is not secure.

The company plans to install SharePoint apps that allow all tenants access to custom applications.

You need to ensure that WebApp1 can host the SharePoint apps over a secure URL. 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.)

View Answer

Q7. - (Topic 6)

You are managing a site collection in a SharePoint farm.

You need to configure the minimum level of permissions necessary for users to manage lists in the site collection.

What permission level should you configure?

A. Edit

B. Contribute

C. Read

D. Limited Access

View Answer

Q8. - (Topic 6)

You administer a SharePoint Online tenant that has a site that contains a document library.

Users from the Human Resource (HR) department have Contributor permissions to the site.

You need to prevent users from the HR department from accessing documents in the library.

Which permission option should you select?

A. Stop Inheriting Permissions

B. Grant Permissions

C. Manage Parent

D. Check Permissions

E. Delete Unique Permissions

View Answer

Q9. HOTSPOT - (Topic 12)

You plan to deploy a SharePoint Server 2013 server farm.

The president of your company sends you the following email message regarding the planned deployment: 'Our company loses an average of $5,000 per minute during service outages. At that rate, $300,000 per hour is a major cost to the company and should be reduced or eliminated. The company must provide continuity for IT services.''

The director of IT services sends you the following email message regarding the planned deployment: The company plans to implement the following as part of the deployment:

✑ Load balance all of the Web servers.

✑ Perform daily and hourly backups of all data.

✑ Centralize all of the service applications on a single server.

✑ Provide redundancy for all of the network components, such as switches and routers."

The director of IT services identifies the following requirements for the planned deployment:

✑ Four front-end Web servers

✑ One database server that will host all of the farm databases and will be replicated to another database server by using log shipping

✑ One dedicated application server that will host all of the service applications, including the Search Service Application and all of the search components.

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

View Answer

Q10. DRAG DROP - (Topic 12)

You plan to deploy the following elements to a SharePoint Server 2013 server farm:

✑ A farm solution

✑ A sandbox solution

✑ A SharePoint hosted app

You need to identify where to deploy each element.

What should you identify? (To answer, drag the appropriate locations to the correct elements. Each location 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)

View Answer