Testlet 1
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case . However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview
Litware, Inc. is an international manufacturing company that has 3,000 users. The company has sales, marketing, research, IT, and human resources (HR) departments.
Litware has two main offices located in New York and London. The company has five branch offices located in Asia.
Existing Environment
Active Directory
The network contains an Active Directory forest named litwareinc.com. The forest contains a single domain. All domain controllers run Windows Server 2016.
SharePoint Server Environment
Litware has a SharePoint Server 2019 farm that contains the servers shown in the following table.
Central Administration has a URL of http://spweb1.litwareinc.com.
The HR department currently uses a SharePoint web application that uses only forms authentication.
The sales department has a SharePoint site that is available anonymously to display product information.
Line-of-Business Application
You have a line-of-business application named LOBApp. LOBApp stores content in a SQL Server database named LOBAppDB.
LOBApp has a service account named LobAppSA.
Problem Statements
Litware identifies the following issues:
– None of the SharePoint sites use TLS.
– The Distributed Cache service uses the farm account.
– When users perform searches from the SharePoint site of the HR department, they receive no results.
– You discover that the user names and passwords configured for managed services were transmitted on the network in plain text.
Requirements
Business Goals
All the components in the SharePoint Server farm must be highly available by using the least number of servers possible.
Each document stored in the HR department site must have the following pieces of metadata: CONID, CONNO, CONDate, and CONApproved.
Security
The farm uses the managed service accounts shown in the following table.
Technical Requirements
Litware identifies the following technical requirements:
– LOBApp content must be visible in search results.
– The principle of least privilege must be used whenever possible.
– All SharePoint service applications must use the SpServices account.
– Information for each product must be displayed as a separate webpage for the sales department.
– Search crawling must start every 10 minutes, regardless of whether the prior session is complete.
– The Cloud Search Service Application must crawl on-premises content in a cloud hybrid search solution.
– The Secure Store Service application must use LitwareAppID as the target application to access LOBAppDB.
Which feature should you activate for the sales department?
- A . SharePoint Server Standard Site Collection features
- B . Site Policy feature
- C . SharePoint Server Enterprise Site Collection features
- D . SharePoint Server Publishing Infrastructure
HOTSPOT
You need to configure the crawl settings to meet the technical requirements.
How should you complete the PowerShell script? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP
You need to meet the technical requirements for searching the LOBApp content.
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.
Explanation:
References: http://prairiedeveloper.com/2016/04/setup-sharepoint-search-crawl-bcs/
You need to recommend changes to the existing environment to support the minimum high-availability SharePoint Server farm. The solution must minimize costs.
Which three changes should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Change the role of SPWEB1 and SPWEB2 to Front-end with Distributed Cache.
- B . Change the role of SPSEARCH1 and SPSEARCH2 to Application with Search.
- C . Remove SPCACHE1 and SPAPP1 from the farm.
- D . Change the role of SPCACHE1 to Single-Server Farm.
- E . Change the role of SPAPP1 to Single-Server Farm.
- F . Remove SPWEB1 and SPSEARCH1 from the farm.
You need to resolve the issues related to passwords being transmitted over the network in plain text.
What should you do?
- A . Configure the SQL servers to use TLS.
- B . Configure Central Administration to use forms authentication.
- C . On SPWEB1, configure a firewall rule that allows outbound traffic on TCP port 443.
- D . Configure Central Administration to use Secure Sockets Layer (SSL).
You need to implement the business goals for the HR department.
What should you do?
- A . Create a content type that contains site columns. Add the content type to the document libraries.
- B . Add site columns to a document library. Save the document library as a template.
- C . Enable enterprise metadata and keywords for the document libraries.
- D . Activate Content Type Syndication Hub. Update the Column default value settings for the document libraries.
DRAG DROP
You need to resolve the issue for the Distributed Cache service.
How should you complete the command? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
References: https://docs.microsoft.com/en-us/sharepoint/administration/manage-the-distributed-cache-service#changethe-service-account
You need to resolve the search issues for the HR department site.
What should you do?
- A . Extend the HR department web application. Set the default zone to forms authentication and the extended zone to NTLM.
- B . Extend the HR department web application. Set the default zone to NTLM and the extended zone to forms authentication.
- C . Create an alternate access mapping for the HR department web application and set the default URL to an intranet zone.
- D . Create an alternate access mapping for the HR department web application and set the default URL to an extranet zone.
Testlet 2
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case . However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview
Contoso, Ltd. is an international pharmaceutical company that has 60,000 users. Contoso has sales, marketing, research, and human resources (HR) departments.
Existing Environment
Productivity Environment
Contoso recently installed a highly available SharePoint Server farm that has Office Server deployed.
Microsoft OneDrive for Business in SharePoint Server is deployed to 10,000 users.
All user accounts are currently stored in an Active Directory Domain Services (AD DS) environment. Each user account has a profile picture in Active Directory.
You recently purchased a SharePoint Online subscription. A small number of users currently use SharePoint Online by using cloud identities.
The root site collection of the farm has a URL of https://portal.contoso.com.
Tens of thousands of documents are added to the farm daily.
The farm contains the servers shown in the following table.
Current Business Model
Contoso has the following business model:
– Users in the research department apply hundreds of terms and keywords as metadata in document libraries.
– The marketing department maintains an external database to store customer information. The information is available in some SharePoint lists and libraries as metadata by using external content types.
Problem Statements
Contoso identifies the following issues:
– Users report that it takes a long time for new documents to appear in search results and the SharePoint sites are slow to load.
– Users in SharePoint Online cannot tag documents by using the terms and keywords available in SharePoint Server on-premises.
– Users report that data refresh in Microsoft Excel Online and the Excel Web Access web part fail to work.
Requirements
Business Goals
Contoso wants to provide seamless, streamlined access to business information, while maintaining appropriate security for employees and contractors.
Technical Requirements
Contoso identifies the following technical requirements:
– Add a picture to the user profile page of each user.
– Resolve the Excel Online issues and enable Excel data refresh.
– Deploy hybrid OneDrive for Business to the remaining 50,000 users.
– Prevent solutions from affecting the performance of existing services.
– Improve search indexing and response times of the existing SharePoint sites.
– Ensure that solutions use the principle of least privilege whenever possible.
– Migrate the terms and keywords from SharePoint Server on-premises to SharePoint Online.
– Configure Microsoft Office 365 for SharePoint hybrid and provide a single sign-on (SSO) experience.
– Configure the permissions for the external content types of the marketing department to meet the following requirements:
– Users in the HR department must be able to see customer data.
– Users in the research department must be able to read and write data.
– Contractors must be able to see data directly from Office applications.
– Ensure that on-premises data from SQL Server databases, SharePoint lists, and Oracle databases can be used to generate reports and dashboards in Microsoft Power BI.
You need to investigate the cause of the search issues reported by the users.
What should you use?
- A . usage reports
- B . query health reports
- C . a SharePoint activity report
- D . crawl health reports
Question Set 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a SharePoint Server farm. You create an external content type named ECT1 for a Microsoft SQL Server database. You implement cloud hybrid search. You create a Line of Business Data content source and run a full crawl. Users in SharePoint Online report that the search results do not contain any data from ECT1. You need to ensure that searches can return data from ECT1.
Solution: You grant the Default content access account Full control permissions to the Central
Administration web application.
Does this meet the goal?
- A . Yes
- B . No
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a SharePoint Server farm. You create an external content type named ECT1 for a Microsoft SQL Server database. You implement cloud hybrid search. You create a Line of Business Data content source and run a full crawl. Users in SharePoint Online report that the search results do not contain any data from ECT1. You need to ensure that searches can return data from ECT1.
Solution: From a Business Data Connectivity Service application, you grant the Default content access
account Manage permissions to ECT1.
Does this meet the goal?
- A . Yes
- B . No
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a SharePoint Server farm. You create an external content type named ECT1 for a Microsoft SQL Server database. You implement cloud hybrid search. You create a Line of Business Data content source and run a full crawl. Users in SharePoint Online report that the search results do not contain any data from ECT1. You need to ensure that searches can return data from ECT1.
Solution: You grant the Default content access account Read permissions to the Central Administration
web application.
Does this meet the goal?
- A . Yes
- B . No
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a SharePoint Server farm. A user attempts to create a site column named RequestType that uses a managed metadata term set named RequestTypes as metadata. The user reports that Allow ‘Fill-in’ choices are set to No, and the option cannot be configured. You need to ensure that the user can set Allow ‘Fill-in’ choices to Yes.
Solution: You set the term set Submission Policy to Open.
Does this meet the goal?
- A . Yes
- B . No
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a SharePoint Server farm. A user attempts to create a site column named RequestType that uses a managed metadata term set named RequestTypes as metadata. The user reports that Allow ‘Fill-in’ choices are set to No, and the option cannot be configured. You need to ensure that the user can set Allow ‘Fill-in’ choices to Yes.
Solution: You add the user as a term set stakeholder.
Does this meet the goal?
- A . Yes
- B . No
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a SharePoint Server farm. A user attempts to create a site column named RequestType that uses a managed metadata term set named RequestTypes as metadata. The user reports that Allow ‘Fill-in’ choices are set to No, and the option cannot be configured. You need to ensure that the user can set Allow ‘Fill-in’ choices to Yes.
Solution: You add the user as a term set Group Manager.
Does this meet the goal?
- A . Yes
- B . No
DRAG DROP
You have a SharePoint Server farm. You create a web application that has a URL of https://portal.contoso.com and a root site collection. You need to ensure that site collection administrators can create new site collections directly from the root site. The new sites must use the modern user interface.
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.
You have a SharePoint Server farm.
The root site collection has a URL of http://sharepoint.contoso.com.
You install and configure Workflow Manager on a server that has an FQDN on workflow.contoso.com.
Workflow administrators report that they cannot create SharePoint 2013 workflows from SharePoint Designer in http://sharepoint.contoso.com.
You need to ensure that the workflow administrators can create SharePoint 2013 workflows.
Which command should you run?
- A . Set-SPWorkflowConfig Cwebapplicationhttp://sharepoint.contoso.com DeclarativeWorkflowsEnabled $true
- B . New-SPWorkManagementServiceApplicationProxy Cname’Work Management Service Application Proxy’ CServiceApplication $sa
- C . New-SPWorkManagementServiceApplication CName’Work Management Service Application’ CApplicationPool’SharePoint Web Services Default’
- D . Register-SPWorkflowService CSPSite http://sharepoint.contoso.com
C Allow0AuthHttp CWorkflowHostUrl http://workflow.contoso.com:12291CScopeName SharePoint – Force
You have a SharePoint Server farm.
You need to ensure that a user named User1 can apply style sheets and override list behaviors. The solution must use the principle of least privilege.
Which permission best achieves the goal? More than one answer choice may achieve the goal. Select the BEST answer.
- A . Edit
- B . Full Control
- C . Design
- D . Limited Access
You have a SharePoint Server farm. You are troubleshooting Kerberos authentication for the farm. You need to view the Kerberos tickets issued to the server.
What should you run?
- A . the klist.execommand
- B . the stsadm.execommand
- C . the Get-SPAuthenticationRealmcmdlet
- D . the Get-SPAppAcquisitionConfigurationcmdlet
You have a SharePoint Server farm.
You need to ensure that a group named Group1 can create and edit term set hierarchies in a term set group named TermGroup1. The solution must use the principle of least privilege.
What is the best role to assign to Group1 to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
- A . Term Store Administrators
- B . Stakeholders for TermGroup1
- C . Owner for TermGroup1
- D . Group Managers for TermGroup1
- E . Contributors for TermGroup1
DRAG DROP
Your network contains an Active Directory domain. Microsoft Active Directory (Azure AD) Connect is configured to sync identifies to an Azure AD tenant. End-user computers are joined to Azure AD.
You have a SharePoint Server farm that supports 30,000 users.
The farm contains the servers shown in the following table.
Users report that they encounter multiple authentication prompts when accessing SharePoint sites. You need to provide a single sign-on (SSO) experience for all the SharePoint sites.
In which order should you perform the actions? To answer, move all of the actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Explanation:
References: https://blogs.msdn.microsoft.com/kaevans/2015/04/13/azure-ad-application-proxy-and-sharepoint-2013/
You have a SharePoint Server farm and a Microsoft Exchange Server organization. SharePoint Server crawls Exchange Server content. You create a new result source that uses the Exchange Server protocol. You need to ensure that users can search the Exchange Server content.
What should you create?
- A . a custom search result type
- B . an additional index partition
- C . a Search Center
- D . an eDiscovery Center
D
Explanation:
References: https://docs.microsoft.com/en-us/sharepoint/search/configure-result-sources-for-search
You are planning the backup strategy for a SharePoint Server farm.
You need to back up content databases automatically every week. The solution must minimize the backup size.
What should you do?
- A . Create a scheduled task that runs Backup-SPWeb.
- B . From Microsoft SQL Server, create a maintenance plan that has a backup task.
- C . From Backup and Restore in Central Administration, configure a farm backup.
- D . From Windows Server Backup, create a backup schedule that performs a custom backup.
HOTSPOT
You have a SharePoint team site. You open the Site Settings and discover that the Navigation settings are missing. You need to configure site navigation to use a term set.
Which two features should you activate? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a SharePoint Server farm. You need to ensure that only errors from SharePoint Server are logged in Event Viewer.
What should you configure from the Diagnostic Logging settings?
- A . usage and health data
- B . Event Throttling
- C . Event Log Flood Protection
- D . Restrict Trace Log disk space usage
B
Explanation:
References: https://docs.microsoft.com/en-us/sharepoint/administration/configure-diagnostic-logging
You have a SharePoint Server farm that contains a term store. The root site collection uses a URL of https://contoso.com/. You need to find all the terms used by the root site collection.
Which URL should you use?
- A . https://contoso.com/_layouts/15/termstoremanager.aspx
- B . https://contoso.com/_layouts/15/contenttypesyndicationhubs.aspx
- C . https://contoso.com/_layouts/15/auditsettings.aspx
- D . https://contoso.com/lists/taxonomyhiddenlist/allitems.aspx
HOTSPOT
Your company has a SharePoint Server farm.
The human resources (HR) department at the company has a site that has a URL of http://contoso.com/hr. You need to back up the HR department site every eight hours by using PowerShell. The backup must complete as quickly as possible.
How should you complete the command? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Your company has a SharePoint Server farm. All servers are virtualized on a Hyper-V host. The company has a single data center.
You need to design a disaster recovery solution.
The solution must meet the following requirements:
– If the data center fails, SharePoint Server services must be recoverable within 24 hours.
– Up to one hour of data can be lost.
– Costs must be minimized during normal operations.
Which technology best meets the requirements? More than one answer choice may achieve the goal. Select the BEST answer.
- A . Hyper-V synchronous replication
- B . the OneDrive sync client
- C . the SharePoint Migration Tool
- D . Azure Site Recovery
Your company has a SharePoint Server farm.
Each department at the company has an associated Active Directory group.
You plan to deploy a Business Connectivity Services (BCS) solution for all the users in the human resources (HR) department. BCS will connect to a Microsoft SQL Server named SQL1. SQL1 uses SQL Server Authentication.
You need to ensure that BCS can access SQL1. Authentication credentials and connection information must be encrypted.
What should you do?
- A . Create a target application that uses a Target Application Type of Group Ticket. Add a new field named ConnectionString and set the field type to PIN. Set the credentials for the target application.
- B . Create a target application that uses a Target Application Type of Group. Add a new field named ConnectionString and set the field type to Generic. Set the credentials for the target application.
- C . Create a target application that uses a Target Application Type of Individual Ticket. Add a new field named ConnectionString and set the field type to Key. Set the credentials for the target application.
- D . Create a target application that uses a Target Application Type of Individual. Add a new field named ConnectionString and set the field type to PIN. Set the credentials for the target application.
HOTSPOT
You have a SharePoint Server farm.
You need to configure the farm to support adding links to the app launcher.
How should you complete the PowerShell script? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
References: https://www.capitolpresence.com/custom-tiles-in-sharepoint-server-2016/
You have a SharePoint Server farm that has one web application. The web application contains one site collection. The site collection contains one site.
You need to enable managed navigation.
What should you do?
- A . From Site Features, activate SharePoint Server Enterprise Site features.
- B . From Site Collection Features, activate SharePoint Server Enterprise Site Collection features.
- C . From Site Features, activate SharePoint Server Publishing.
- D . From Site Collection Features, activate SharePoint Server Publishing Infrastructure.
C
Explanation:
References: https://support.office.com/en-us/article/enable-managed-navigation-for-a-site-in-sharepoint-49a067dc77d2-455d-9e77-250ec7cc0a6d
You have a SharePoint Server farm. You need to add enterprise keywords to the term store.
To which term group should you add the keywords?
- A . Search Dictionaries
- B . System
- C . People
- D . Library
You create a new color palette and font schemes. You need to use the new palette and schemes to customize your SharePoint Server environment. Where should you add the files you created?
- A . Style Library
- B . Managed Solutions Gallery
- C . Theme Gallery
- D . Master Page Gallery
You have a SharePoint Server farm. You configure the User Profile service. You add a new attribute mapping for users.
The users report they cannot see the new attribute in their profile. You need to ensure that the new attribute is displayed for all users as quickly as possible.
What should you run?
- A . a full profile synchronization
- B . a full crawl
- C . an incremental profile synchronization
- D . an incremental crawl
A
Explanation:
References: https://docs.microsoft.com/en-us/sharepoint/administration/start-profile-synchronization-manually
You have a SharePoint Server 2019 farm. The farm contains several Microsoft Office documents. All the documents have a property named Division that is populated automatically based on the document’s author.
You create a text managed property that is retrievable and queryable, and you map the managed property to the Division property.
You need to find only the documents that have the Division property set to Legal.
For what should you search?
- A . Division=Legal
- B . "Legal"
- C . Division:Legal
- D . Legal ONLY