Enabling Database Auditing

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

Quiz covering Security for Azure SQL

What you'll be asked

  1. Which Azure resource is primarily used to store the logs generated by Azure SQL Database Auditing?
  2. You are configuring auditing for an Azure SQL Database. You want to ensure that all failed login attempts are captured. Which setting should you modify?
  3. What is the primary benefit of sending Azure SQL audit logs to a Log Analytics workspace instead of a standard storage account?
  4. When configuring auditing on an Azure SQL server, what is the scope of the policy inheritance?
  5. You have a strict compliance requirement to keep audit logs in an immutable format for 5 years. Which configuration provides the best approach for long-term retention?

Answers and explanations come after you submit.