SQL Authentication Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Authentication

What you'll be asked

  1. Which of the following is the most fundamental security practice when configuring database user accounts?
  2. When using Windows Authentication (Integrated Security) for SQL Server, what is the primary security benefit compared to SQL Server Authentication?
  3. An application connects to a database using a service account. Which configuration best minimizes the impact of a potential SQL injection attack?
  4. What is the primary risk associated with enabling 'Mixed Mode Authentication' in SQL Server?
  5. In a high-security environment, you are tasked with implementing database authentication that prevents 'pass-the-hash' attacks and ensures that credentials are never transmitted over the network. Which mechanism should you implement?

Answers and explanations come after you submit.