Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. - (Topic 5)
You need to configure Office 365 to automate the sign-in experience. What should you do?
A. Configure AD FS to convert the domain contoso.com to a federated domain.
B. Run the New-MsolFederatedDomain-DomainName contoso.com
A. –SupportMultipleDomain Windows PowerShell cmdlet.
C. Configure AD FS to add the domain contoso.com as an AD FS federated domain and to support multiple domains.
D. Run the Update-MsolFederatedDomain-DomainName contoso.com - SupportMultipleDomain Windows PowerShell cmdlet.
Answer: B
Q2. HOTSPOT - (Topic 6)
You have a SharePoint Server 2013 server farm that contains a web application named WebApp1. WebApp1 uses classic-mode authentication.
A company policy states that Central Administration must be used, whenever possible.
In the table below, identify which tasks can be performed from Central Administration and which task can only be performed from Windows PowerShell. Make only one selection in each row.
Answer:
Q3. - (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.
Answer: : A,B
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
Q4. HOTSPOT - (Topic 6)
You need to implement Community sites and eDiscovery centers in Office 365.
In the table below, select the Office 365 plan that you should use for each type of site. NOTE: Make only one selection in each column.
Answer:
Q5. - (Topic 12)
You recently upgraded a SharePoint Server 2007 server farm to SharePoint Server 2013.
You discover that when search results contain Microsoft Word 2007 documents, the results do not display the title of the documents. Instead, the results display a few words from the text of the documents as the title.
You need to ensure that the title of the Word 2007 documents is displayed in the search results.
The solution must minimize administrative effort.
What should you do?
A. Modify the EnableOptimisticTitleOverride registry value.
B. Modify the DisableLoopbackCheck registry value.
C. Delete and recreate the Search Service Application.
D. Reset the index and perform a full crawl.
Answer: D
Explanation: You must create a new managed property and map only TermTitle and Title crawled properties. Then do another full crawl.
Incorrect:
Not A: This only works in SharePoint 2010.
Reference: Is there a way to force search results to display word document titles? https://social.technet.microsoft.com/Forums/office/en-US/e27b6b4f-d38f-49ec-9fca-
7aa21099886f/is-there-a-way-to-force-search-results-to-display-word-document- titles?forum=sharepointsearch
Q6. HOTSPOT - (Topic 12)
You develop an application that creates variations of a submitted page. These variations display the original authored page in three different languages.
You need to create a service application to support the language conversion efforts. Which service application should you create? (To answer, select the appropriate service
application in the answer area).
Answer:
Q7. HOTSPOT - (Topic 6)
You are troubleshooting a SharePoint app by using the Developer Dashboard. You need to view the events that have been logged for the selected request.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)
Answer:
Q8. - (Topic 12)
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: B
Q9. DRAG DROP - (Topic 6)
You are managing a SharePoint website.
You need to add a search service component to the search topology.
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:
Q10. - (Topic 2)
You need to implement Office 365 authentication. What should you do?
A. Create an AD DS domain named proseware.com and join the AD FS servers to the proseware.com domain.
B. Add a DNS CNAME record for www.proseware.com and point it to www.adatum.com.
C. Deploy an AD FS proxy for the proseware.com domain.
D. Add proseware.com as an Office 365 SSO domain and update all user principal names (UPNs) to also use proseware.com.
Answer: D
Q11. DRAG DROP - (Topic 12)
A company has a SharePoint 2013 farm. The company is in the process of configuring eDiscovery for Microsoft Exchange Server 2013 and has installed the Microsoft Exchange Web Services Managed API on each front-end web server.
You need to configure a trust relationship between the Exchange server and the SharePoint farm.
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:
Q12. HOTSPOT - (Topic 12)
A company upgrades a SharePoint environment from SharePoint 2010 to SharePoint 2013. The Site Feeds feature is not available on the upgraded sites.
You need to activate Site Feeds.
What should you do? (To answer, select the appropriate options from the drop-down lists in the answer area.)
Answer:
Q13. - (Topic 6)
A SharePoint environment contains a single web application at http://web01.
You create a site collection under the web application. The site collection has the URL http://sharepoint.contoso.com.
You need to ensure that the site collection is also accessible at http://intranet.contoso.com. What should you do?
A. Add intranet.contoso.com as an alternate access mapping for the web application.
B. Extend the web application and add intranet.contoso.com to the Intranet Zone.
C. Run the Set-SPSiteUrl Windows PowerShell cmdlet.
D. Run the New-SPSite Windows PowerShell cmdlet.
Answer: C
Q14. - (Topic 6)
Your company has a SharePoint Server 2013 server farm.
You create a Business Connectivity Services (BCS) application.
You deploy the application to the farm,
Users create lists and add items to the lists based on the BCS application.
The users report that when they search for data, BCS items are not displayed in the search results. Other items in the farm are displayed in the search results.
You need to ensure that BCS data is displayed in the search results. The solution must minimize administrative effort.
What should you create?
A. a Local SharePoint Results result source
B. an OpenSearch 1.0/1.1 result source
C. a Line of Business Data content source
D. a Custom Repository content source
Answer: C
Explanation: If your company has an on-premises SharePoint 2013 farm and a SharePoint Online 2013 tenancy, you can use BCS to create a secure connection between the two to make line-of-business (LOB) data available to applications for SharePoint and external lists in SharePoint Online. This is called a SharePoint BCS Hybrid solution. SharePoint Online 2013 supports only one-way connections from online to on-premises and to only one on-premises farm. The LOB data must be published as an OData source
Q15. HOTSPOT - (Topic 6)
You are a SharePoint farm administrator.
When you attempt to navigate to the SharePoint home page, you receive an application error message that includes a correlation ID. The diagnostic logs do not contain the error
corresponding to the correlation ID.
You need to adjust the diagnostic logging level to capture all events.
Which least critical event should you select? (To answer, select the appropriate event from the drop-down list.)
Answer: