DP-300 Certification Practice Question #70

Question

You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server.
You need to ensure that each customer can only connect to and access their respective database.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

To ensure that each customer can only connect to and access their respective database on a shared Azure SQL logical server, you need isolation at both the database membership level and the network level. Creating contained database users in each database (B) allows customers to authenticate directly to their database without a server login in the `master` database, thus preventing them from seeing or attempting to access other databases on the server. Configuring database-level firewalls (C) restricts network access for each customer’s IP address to their specific database, rather than the entire server.

More DP-300 practice questions