Azure SQL Auditing Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Auditing and Compliance

Azure SQL Auditing Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which Azure resource is primarily used to store the logs generated by Azure SQL Auditing?

  2. 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. 3

    Which of the following is a primary benefit of using a Log Analytics workspace as the destination for Azure SQL audit logs?

  4. 4

    If you want to audit specific actions, such as 'SCHEMA_OBJECT_ACCESS_GROUP', which component of the auditing configuration should you modify?

  5. 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?