SC-500 practice question on Secure Azure databases, 2026-11-13
Archived question for 2026-11-13. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.
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?
Show the explanation
DeployIfNotExists remediates by deploying the auditing configuration where it is missing, while Audit only flags noncompliance.
Each option
- A. It reports servers without auditing and fixes nothing. It would be right for reporting only.
- B. It stops deletion and does not enforce auditing. It would be right for protecting servers from removal.
- C. It gives read access and changes nothing. It would be right for inspection.
- D (correct). Correct: It deploys the auditing setting on servers that lack it.
What this question tests
It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, policy.
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-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-11: Defender raises an alert about sign-ins from an unfamiliar address to a production database. What should the analyst do FIRST?
- 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-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?
- 2026-11-16: A company enforces an Allowed locations policy on a subscription. One resource group must host a temporary workload in an unapproved region for 30 days. What is the BEST way to allow it?
- 2026-11-17: An accepted finding keeps appearing in every scheduled security scan of a database, and the team wants the report to stop flagging it while still scanning for new issues. What should the engineer do?
Start a daily session
Several questions at a time, aimed at your gaps.