SC-500 practice question on Secure Azure databases, 2026-11-09
Archived question for 2026-11-09. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.
Which feature encrypts Azure SQL Database data files and automated backups at rest by default?
Show the explanation
Transparent data encryption is on by default for new Azure SQL databases and encrypts data, log files and backups at rest.
Each option
- A. It protects chosen columns with client-side keys and is not the default. It would be right for hiding data from administrators.
- B (correct). Correct: It encrypts the database, its backups and log files without application changes.
- C. It obscures query output and encrypts nothing. It would be right for limiting visible values.
- D. It filters rows and encrypts nothing. It would be right for tenant isolation.
What this question tests
It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql audit, tde.
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-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-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?
Start a daily session
Several questions at a time, aimed at your gaps.