Microsoft Azure Security Engineer Associate AZ-500 Practice Question
Your company hosts multiple workloads in Azure SQL Managed Instance. The security team wants to centralize audit records with virtual machine logs that are already collected in an Azure Monitor Log Analytics workspace. They also require that every existing and future database in the managed instance be audited without additional configuration effort. What should you do first to meet these requirements?
Enable Azure SQL Auditing at the managed-instance level and configure the destination as the existing Log Analytics workspace.
Configure database-level auditing on each database and set the destination to an Event Hub.
Create an Azure Monitor diagnostic setting for the managed instance to stream SQLInsights metrics to an Azure Storage account.
Enable Microsoft Defender for SQL (Advanced Threat Protection) on the managed instance and send alerts to Azure Monitor.
Configuring instance-level auditing sends audit logs for every current and future database in the managed instance. By selecting Log Analytics as the audit target, the logs are written directly to the existing workspace, allowing centralized analysis with other Azure Monitor data. Database-level auditing must be enabled separately for each database and would not automatically cover new databases. Advanced Threat Protection produces security alerts but does not create audit records. Diagnostic settings for SQL Insights export performance metrics, not detailed audit events.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Azure SQL Auditing?
Open an interactive chat with Bash
How does enabling instance-level auditing differ from database-level auditing?
Open an interactive chat with Bash
What is an Azure Monitor Log Analytics workspace used for?
Open an interactive chat with Bash
Microsoft Azure Security Engineer Associate AZ-500
Secure compute, storage, and databases
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .