Explanation:When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows user accounts. 9. Which of the following is the biggest disadvantage of SQL Server Authentication mode ?
A. SQL Server Authentication cannot use Kerberos security protocol
B. Allows SQL Server to support Web-based applications where users create their own identities
C. Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication
D. None of the mentioned
Answer:A
Explanation:When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows user accounts. 9. Which of the following is the biggest disadvantage of SQL Server Authentication mode ?
A. SQL Server Authentication cannot use Kerberos security protocol B. Allows SQL Server to support Web-based applications where users create their own identities C. Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication D. None of the mentioned
Explanation:Windows Authentication use Kerberos security protocol. 10. The Windows password policies enforced for SQL Server logins depends upon _____________________ API.