This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Answer the following questions to check your understanding of the key concepts in this module.
Contoso's Azure SQL Database server hosts a high-volume Online Transaction Processing (OLTP) banking application. The security team reports that server-level auditing is causing performance degradation during peak transaction hours. What change resolves this issue?
Disable auditing temporarily during peak hours and re-enable it during off-peak windows
Route audit logs to Event Hubs instead of Azure Storage to reduce write latency
Switch to database-level auditing so each database writes audit logs to its own folder independently
Increase the storage account performance tier to Premium to reduce audit log write times
A financial regulator requires that Contoso's database audit logs can't be altered or deleted after they're written. Which audit destination configuration meets this requirement?
Azure Monitor Log Analytics workspace with a 365-day retention policy
Azure Blob Storage with immutable blob storage (WORM) policies configured on the audit container
Event Hubs with a dedicated consumer group and 30-day message retention
Azure Monitor diagnostic settings with a resource lock applied to the Log Analytics workspace
A cloud security engineer needs to configure SQL Managed Instance auditing to route logs to both Azure Monitor and an Event Hubs. Which configuration method is required for these nonstorage destinations?
The SQL auditing screen in the Azure portal, selecting all three destinations simultaneously
T-SQL CREATE SERVER AUDIT with TO EXTERNAL_MONITOR specified as the destination
Enable the server audit through the Defender for Cloud recommendations panel
Configure a Log Analytics workspace directly in the SQL Managed Instance auditing settings under the Security screen
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?