WHICH OF THE FOLLOWING DEFINES MIXED MODE AUTHENTICATION

10. Which of the following defines mixed mode authentication?

A. Connections can be made using only Windows accounts.

B. Connections to SQL Server can be made with either Windows accounts

or with SQL Server Logins.

C. Connections can be made using only SQL Server Logins.

D. Connections can be made using only database users.

The correct answer is B. When you are using mixed mode authentication,

connections to SQL Server can be made either with Windows accounts

or SQL Server Logins. Answers A and C are incorrect since mixed mode

authentication does not exclusively use Windows accounts or SQL Server

logins. Answer D is incorrect since it is not a mode of authentication.