SC-500 practice question on Secure Azure databases, 2026-11-03
Archived question for 2026-11-03. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.
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?
Show the explanation
A server-level auditing policy applies to all existing and newly created databases on that server.
Each option
- A. It leaves new databases uncovered until someone repeats it. It would be right for one database with special events.
- B (correct). Correct: A server policy applies to existing databases and to new ones.
- C. It encrypts data at rest and records nothing. It would be right for file protection.
- D. It scans for weaknesses and records no events. It would be right for configuration review.
What this question tests
It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, server 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-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?
Start a daily session
Several questions at a time, aimed at your gaps.