SC-500 practice question on Secure Azure databases, 2026-11-11
Archived question for 2026-11-11. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.
Defender raises an alert about sign-ins from an unfamiliar address to a production database. What should the analyst do FIRST?
Show the explanation
Audit records let the analyst scope what the unfamiliar login accessed before containment decisions.
Each option
- A. It admits the client and widens exposure. It would be right for an approved remote user.
- B. It reviews configuration and says nothing about this login. It would be right for hardening.
- C (correct). Correct: The records show what the login did and when.
- D. It changes data protection and does not investigate. It would be right for protecting columns from administrators.
What this question tests
It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, triage.
The published topics under this objective, so you can check what you have covered:
- Azure SQL platform security
- Auditing for SQL DB
- Managed Instance
- Defender for Databases coverage
More from the archive
- 2026-11-07: The server's network settings are shown below. The security team wants to know what the setting Allow Azure services and resources to access this server permits. Which statement is correct? ``` SQL server: sql-contoso-prod Public network access: Selected networks Firewall rules: office 203.0.113.0 - 203.0.113.255 Allow Azure services and resources to access this server: Yes Private endpoints: (none) ``` What does the setting permit?
- 2026-11-08: Which security standard does Microsoft Defender for Cloud assign by default to Azure subscriptions when it is enabled?
- 2026-11-09: Which feature encrypts Azure SQL Database data files and automated backups at rest by default?
- 2026-11-10: A payment company must show compliance with the PCI standard in the Defender for Cloud dashboard. The engineer finds that the standard is not listed. What should the engineer do?
- 2026-11-12: A built-in policy that denies key vaults without purge protection is assigned to a subscription. An older vault already exists with these settings, and nobody changes it. What happens to it? ``` vault: kv-legacy created: 2024-02-11 (before the assignment) enablePurgeProtection: false policy assignment: Key vaults should have purge protection enabled (effect: Deny) ``` What is the result for kv-legacy?
- 2026-11-13: Policy says auditing must stay enabled on every logical server in a subscription, and servers without it must be corrected automatically. Which control meets the requirement?
- 2026-11-14: Which Microsoft Defender for Cloud dashboard shows how a subscription measures up against industry and regulatory standards?
- 2026-11-15: A compliance team must find database columns that hold personal data, label them by sensitivity, and see in the audit log when labeled columns are read. Which feature supports this?
Start a daily session
Several questions at a time, aimed at your gaps.