Azure SQL Auditing Quiz

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

Quiz covering Auditing and Compliance

What you'll be asked

  1. Which Azure resource is primarily used to store the logs generated by Azure SQL Auditing?
  2. You need to ensure that all database queries are audited for a specific Azure SQL Database. Where should you configure the auditing policy to ensure it applies to the entire database?
  3. Which of the following is a primary benefit of using a Log Analytics workspace as the destination for Azure SQL audit logs?
  4. If you want to audit specific actions, such as 'SCHEMA_OBJECT_ACCESS_GROUP', which component of the auditing configuration should you modify?
  5. You have a requirement to audit all database activity, but you must ensure that the audit logs themselves are immutable and cannot be deleted or modified by any user, including administrators, for a period of 90 days. What is the most effective way to achieve this?

Answers and explanations come after you submit.