Skip to content

All certifications

SC-500 practice question on Secure Azure databases, 2026-11-07

Archived question for 2026-11-07. Domain: Secure storage, databases, and networking. Objective SC500-D2-2: Secure Azure databases. Original SecLern question, written for practice.

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?

Show the explanation

The Allow Azure services setting creates an allowance for connections from any Azure IP address, so private endpoints or virtual network rules are used when tighter control is needed.

Each option

  • A. It is not limited by subscription. It would be right for a virtual network rule.
  • B. The setting admits any Azure resource. It would be right for a stricter configuration.
  • C. The setting adds an allowance for Azure sources. It would be right if it were set to No.
  • D (correct). Correct: The setting admits traffic from any Azure source to the public endpoint, though authentication is still required.

What this question tests

It maps to SC-500 objective SC500-D2-2, Secure Azure databases: Secure Azure databases Related ideas: sql platform, firewall.

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

Start a daily session

Several questions at a time, aimed at your gaps.