A SaaS company serves multiple enterprise customers and must ensure each customer's data is completely isolated at the database level while minimizing management overhead. Which Azure SQL approach is best?
-
A
Single Azure SQL Database per tenant with separate server per customer
-
B
Azure SQL Elastic Pool with one database per tenant and row-level security
-
C
Azure SQL Managed Instance per tenant
-
D
A single Azure SQL Database with tenant_id column and application-level isolation