More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Is it secure to use Windows Authentication to establish a connection to MS SQL Server?
Yes. It is very secure to Windows Authentication to establish a connection to MS SQL Server.
In fact, it is more secure than SQL Server Authentication, because
Windows Authentication uses Kerberos security protocol,
provides password policy enforcement with regard to complexity validation for strong passwords,
provides support for account lockout, and supports password expiration.
(Continued on next question...)