SC-500 practice question on Secure Azure databases, 2026-11-06
Archived question for 2026-11-06. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.
A team enables auditing on an Azure SQL database and keeps the default audit action groups. Which activity does the audit log record?
Show the explanation
The default audit action groups are completed batches, successful database authentication and failed database authentication.
Each option
- A (correct). Correct: The default groups cover completed batches and both kinds of database sign-in.
- B. These groups are not on by default. It would be right after adding those action groups.
- C. Defaults also include successful sign-ins and queries. It would be right for a custom, narrow policy.
- D. Those operations are not default groups. It would be right for no default policy.
What this question tests
It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, action groups.
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-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?
Start a daily session
Several questions at a time, aimed at your gaps.