You work as a Systems Administrator at a company named ABC.com. You are in the process of
deploying new servers running SQL Server 2012.
You install a new server named ABC-SQL06 and configure the SQL Server Authentication mode
to be Windows Authentication. A week later, you discover that someone has changed the
authentication mode to SQL Server Authentication. You change the authentication mode back to
Windows Authentication.
You need to recommend a monitoring solution for ABC-SQL06 that will send you an email alert if
someone modifies the authentication mode.
What should you include in your recommendation?
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
A.
Trace Flags.
B.
SQL Server Agent Alert.
C.
Policy-Based Management.
D.
SQL Server Health Policy.
Explanation:
According http://www.mssqltips.com/sqlservertip/2054/configuring-alerts-for-sql-server-policy-based-management/
you need Policy-Based management + Alert
=> not a sigle answer !!!!
0
0