Case Study
This is a case study. Case studies are not limited 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 question on 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 sections 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 on 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.
Background
Contoso, Ltd. is a manufacturing company that serves the oil and gas industry. The company produces materials and chemicals that are used in the production of gasoline. Contoso has recently acquired several smaller companies including A Datum, Litware, Inc., and Northwind Traders. Contoso has now grown from a local company to a company that has offices in multiple geographies.
The company has the following offices:

Corporate structure
Contoso is divided into business units on their function primarily, and then by geographic region. The corporate language is English. Contoso has a major datacenter that is located near their Dallas facilities. A.
Datum Corporation has a contract with a third-party datacenter in London, England. Contoso intends to move their environment fully to the cloud in the future, and will use SQL Databases in the cloud for business continuity.
Contoso has, up until recently, handled all collaboration between employees using a single file share, email, USB flash drives, and local storage. With a growing need for global cooperation and collaboration, Contoso has elected to implement a SharePoint environment. You must minimize the costs for the solution.
Business requirements
SharePoint
SharePoint environment
Each business functional group requires a unique site collection. You must create child site collections

for each geographical region that is of a business functional group.
The SharePoint taxonomy must follow the corporate structure.

All existing corporate content must be migrated to the new SharePoint 2016 environment.

The SharePoint environment must be accessible to all employees 24 hours a day, 7 days a week, and

365 days a year.
Data
You must retain all records for compliance reasons.

You must share sales data by using Microsoft Excel. The sales data must be available online.

The Beijing office must be able to share information to external partners.

Employees
Employee requirements
Employees must only use SharePoint Designer to edit SharePoint pages.

Employees must be able to edit Excel workbooks in a browser.

Employees must have access to PowerPivot.

Editing of SharePoint pages
Contoso has decided that they will allow employees to edit SharePoint 2016 pages only by using SharePoint Designer. Employees must edit pages in a development environment that is located in Dallas.
Changes must be applied to the production environment by using a backup/restore operation on the individual site collection. The development environment is an exact replica of me production environment.
Technical requirements
SharePoint requirements
You identify the following requirements for the SharePoint environment:
Backup and disaster recovery
The environment must be backed up at all times. You must not permit the loss of more than one hour of

data.
In the event of a disaster, the SharePoint environment must remain accessible to all employees. All

disaster response and recovery plans and protocols will be available from the corporate SharePoint instance. The maximum acceptable downtime for the environment is four hours.
In the case of failure, you must be able to restore the environment to any point within three weeks

before the failure.
SharePoint farm
You must ensure that specific offices can share content with external partners.

You must log activities related to PowerPivot in the SharePoint usage logs.

You must implement Search services from the on-premises farm.

Deployment guidelines
You have the following guidelines and protocols for implementing the SharePoint environment:

You must install and configure all servers in an identical way.

You must provision all site collections by using the SPSite. Copy method at the content database level.

You must use reproducible and traceable methods to provision sites.
You must track information about SharePoint installations in Active Directory Domain Services.

You must specify different service accounts for each service application.

Users in the Dallas test environment must be able to create content databases on demand.

Planned environments
You plan to implement the following environments:

Groups and accounts
You must create the following groups:

You must create the following service accounts:

Monitoring and management
You must implement monitoring for the following aspects of the SharePoint solution:
Security You must be notified if administrator accounts are used to run application pools or if the server farm account is used for other services.
Performance You must monitor database index fragmentation and whether the paging file size is sufficient.
Availability You must monitor free space on drives and receive an alert if a drive is running out of space.
You must also be notified if one or more servers are not responding.
SharePoint page performance You must monitor the manufacturing, trading, and finance instances in Beijing for the any performance issues. You must also log attempts to connect to the instances from locations outside of the corporate network.
Connectivity between Office 365 and the on-premises SharePoint 2016 environment You must monitor connectivity between the two environments.
Contoso is concerned that unauthorized users may gain access to sensitive information. You must log any attempts to access sensitive information. The company is especially interested in the logging the following actions:
attempts to open documents that contain personal information

editing sensitive documents

printing sensitive documents

You need to define the content database architecture.
What should you create?