DP-300 Implement a secure environment Practice Question
You are configuring Azure SQL Database for a multi-tenant application. Each tenant's data is stored in a separate database. You need to ensure that a tenant admin can only manage their own database and not other databases on the same logical server. What is the best approach?
⚠ Common exam trap
Many candidates confuse server-level logins with database-level contained users, assuming that assigning db_owner via a server login is sufficient for isolation, but it actually grants cross-database access.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a contained database user with db_owner role in each tenant's database and use Microsoft Entra authentication.
Creating a contained database user with the db_owner role in each tenant's database, using Microsoft Entra authentication, ensures that the tenant admin can only manage their own database. Contained database users are scoped to the individual database, not the logical server, so they cannot access other databases on the same server. This aligns with the principle of least privilege for multi-tenant isolation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a server-level firewall rule to restrict access to the tenant's IP.
Why it's wrong here
A server-level firewall rule controls network reachability to the logical server, not authorisation within databases, so any permitted tenant admin could still manage every database. It is tempting because firewall rules are the standard first layer of Azure SQL access control, and per-tenant IP ranges feel naturally tenant-scoped.
- ✓
Create a contained database user with db_owner role in each tenant's database and use Microsoft Entra authentication.
Why this is correct
Contained database users live inside each database, so a tenant admin granted db_owner there cannot reach other databases on the same logical server. Microsoft Entra authentication supplies the identity, and no server-level login is created, preserving tenant isolation.
- ✗
Create a server-level login and assign it as db_owner on all databases.
Why it's wrong here
A server-level login mapped to db_owner in every database grants the tenant admin full control across all tenant databases, directly violating the isolation requirement. It is tempting because server-level principals simplify centralised administration, and db_owner is the natural role for a database administrator managing a single database.
- ✗
Create a database-level firewall rule for each tenant database.
Why it's wrong here
Database-level firewall rules govern which IP addresses may connect, not which objects a connected principal may administer, so they cannot restrict a tenant admin's permissions. They are tempting because per-database rules do scope access per tenant, but that scoping is network-based rather than permission-based.
Go deeper
Related to this question
Learn chapter
Managing Identity and Access for Azure SQL
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 574-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.