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.