HOTSPOT
Background
You manage a Microsoft SQL Server environment that includes the following databases: DB1, DB2,
Reporting.
The environment also includes SQL Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). All
SSRS and SSAS servers use named instances. You configure a firewall rule for SSAS.
Databases
Database Name:
DB1
Notes:
This database was migrated from SQL Server 2012 to SQL Server 2016. Thousands of records are inserted
into DB1 or updated each second. Inserts are made by many different external applications that your
company’s developers do not control. You observe that transaction log write latency is a bottleneck in
performance. Because of the transient nature of all the data in this database, the business can tolerate some
data loss in the event of a server shutdown.
Database Name:
DB2
Notes:
This database was migrated from SQL Server 2012 to SQL Server 2016. Thousands of records are updated or
inserted per second. You observe that the WRITELOG wait type is the highest aggregated wait type. Most
writes must have no tolerance for data loss in the event of a server shutdown. The business has identified
certain write queries where data loss is tolerable in the event of a server shutdown.
Database Name:
Reporting
Notes:
You create a SQL Server-authenticated login named BIAppUser on the SQL Server instance to support users
of the Reporting database. The BIAppUser login is not a member of the sysadmin role.
You plan to configure performance-monitoring alerts for this instance by using SQL Agent Alerts.You need to set up the service accounts that the database engine and SQL Server Agent services will use.
How should you design the solution? To answer, select the appropriate configuration options in the answer
area.
Hot Area:

Answer:

Explanation:
Box 1: Domain Account
The service startup account defines the Microsoft Windows account in which SQL Server Agent runs and its
network permissions. SQL Server Agent runs as a specified user account. You select an account for the SQL
Server Agent service by using SQL Server Configuration Manager, where you can choose from the following
options:
* Built-in account. You can choose from a list of the following built-in Windows service accounts: Local System
account.
* This account. Lets you specify the Windows domain account in which the SQL Server Agent service runs.
Box 2: Domain users
Microsoft recommends choosing a Windows user account that is not a member of the Windows Administrators
group.
Box 3: Managed Service Accounts
When resources external to the SQL Server computer are needed, Microsoft recommends using a Managed
Service Account (MSA), configured with the minimum privileges necessary.
Note: A Managed Service Account (MSA) can run services on a computer in a secure and easy to maintain
manner, while maintaining the capability to connect to network resources as a specific user principal.
https://msdn.microsoft.com/en-us/library/ms191543.aspx