DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ46

Implement a secure environment

You have an Azure subscription.

You create a logical SQL server that hosts four databases. Each database will be used by a different customer.

You need to ensure that every customer can access only its own database. The solution must minimize administrative effort.

Which two actions should you take? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Choose two
Explanation

Database-level IP firewall rules apply only to the individual database and provide isolation between customers’ databases. Azure SQL Database requires an initial server-level IP firewall rule before database-level rules can be configured. Server-level rules alone allow access through the firewall to every database on the logical server.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!