MS-301 Question #8: Real Exam Question with Answer & Explanation

Case Study 2 - Contoso 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: 1. Users in the HR department must be able to see customer data. 2. Users in the research department must be able to read and write data. 3. 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 meet the technical requirements for search. Which two types of components should you add to the farm? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.