Administering Relational Databases on Microsoft Azure — Question 40

You have an Azure subscription.

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

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

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

NOTE: Each correct selection is worth one point.

Answer options

• A. Deny public access.
• B. Create a private endpoint.
• C. Create a database-level firewall rule.
• D. Create a network security group (NSG).
• E. Create a server-level firewall rule.

Correct answer: C

Explanation

Creating a database-level firewall rule allows you to restrict access to each individual database for the respective customer, ensuring they can only connect to their own data. The other options either provide broader access controls or are not specifically tailored to manage database-level access effectively.