What should you include in your recommendation?

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?

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?

A.
Trace Flags.

B.
SQL Server Agent Alert.

C.
Policy-Based Management.

D.
SQL Server Health Policy.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *