SC-500 question of the day
Question for 2026-11-17. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.
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?
Show the explanation
Setting a baseline marks a finding as acceptable so later scans report only deviations from it.
Each option
- A (correct). Correct: Baselined results are treated as accepted and drop out of the failing list.
- B. It stops all findings, including new ones. It would be right for no scenario that needs scanning.
- C. Scans lose their output, and the finding returns. It would be right for no scenario.
- D. It removes the scans and alerts altogether. It would be right when the plan is no longer needed.
What this question tests
It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, baseline.
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-03: A company hosts many databases on one logical server and creates new ones weekly. Every database, current and future, must be audited without per-database work. What should the engineer do?
- 2026-11-04: A company wants to disable SQL logins on its Azure SQL logical server so that only Microsoft Entra identities can authenticate. Which setting should the engineer enable?
- 2026-11-05: A standard in the compliance dashboard includes a control about the physical security of datacenters, which Defender for Cloud cannot assess automatically. How should the engineer record that the company meets it?
- 2026-11-06: A team enables auditing on an Azure SQL database and keeps the default audit action groups. Which activity does the audit log record?
- 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-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-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?
- 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?
Start a daily session
Several questions at a time, aimed at your gaps.