nerdexam
Microsoft

AZ-500 · Question #241

You are working for an organization as an Azure administrator. You are tasked to migrate an on- premises SQL Server to four Azure SQL databases in a single Azure SQL Server. The SQL Server audit…

The correct answer is B. Configure Azure Storage as the audit log destination. C. Enable auditing at the server level. To ensure all four Azure SQL databases are audited with minimal cost, enable auditing at the server level and configure Azure Storage as the destination for the audit logs.

Submitted by suresh_in· Mar 6, 2026Secure compute, storage, and databases

Question

You are working for an organization as an Azure administrator. You are tasked to migrate an on- premises SQL Server to four Azure SQL databases in a single Azure SQL Server. The SQL Server audit logs were copied to an Azure Blob storage before migrating to Azure. There is a quarterly review carried with the audit logs for any suspicious activity. You are required to make sure Auditing events of all Azure SQL databases must be logged and stored for review. You should be careful with the costs as they should be minimum. Can you identify the two actions you should perform? (opt any TWO).

Options

  • AEnable auditing at the database level.
  • BConfigure Azure Storage as the audit log destination.
  • CEnable auditing at the server level.
  • DConfigure Azure Event Hub as the audit log destination.

How the community answered

(65 responses)
  • A
    8% (5)
  • B
    77% (50)
  • D
    15% (10)

Why each option

To ensure all four Azure SQL databases are audited with minimal cost, enable auditing at the server level and configure Azure Storage as the destination for the audit logs.

AEnable auditing at the database level.

Enabling auditing at the database level for each of the four databases would be less efficient and potentially more complex to manage than server-level auditing, without offering significant cost benefits for this scenario.

BConfigure Azure Storage as the audit log destination.Correct

Azure Storage (specifically Blob storage) is a cost-effective solution for storing audit logs, especially when long-term retention and periodic review are required, fulfilling the 'minimum costs' requirement.

CEnable auditing at the server level.Correct

Enabling auditing at the server level applies to all databases within that Azure SQL logical server, ensuring all four databases are covered efficiently without needing to configure auditing individually for each database.

DConfigure Azure Event Hub as the audit log destination.

Azure Event Hub is designed for real-time streaming of events and is generally a more expensive destination for static audit log storage and periodic review compared to Azure Storage.

Concept tested: Azure SQL Database server-level auditing and log destination

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-500 Practice