DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ47

Implement a secure environment

You have 40 Azure SQL databases, with each database assigned to a different customer. All of the databases are hosted on the same Azure SQL Database server.

You need to ensure that every customer can connect only to, and access, their own database.

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

NOTE: Each correct selection is worth one point.

Choose two
Explanation

Create a user in each customer’s database and grant that user only the required permissions in that database. Database-level firewall rules allow network access to specific secure databases, while server-level firewall rules enable access to the entire logical server and therefore all its databases. Azure SQL Database firewall rules

Learn more

Community Discussion

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