Microsoft Exam DP-300 Topic 2 Question 88 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 88
Topic #: 2

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.

ACreate a network security group (NSG)

BCreate a server-level firewall rule

CCreate a private endpoint

DCreate a database-level firewall rule.

EDeny public access.

Show Suggested Answer

Suggested Answer: C, D

by Elmer at Apr 22, 2024, 10:39 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephaine

6 months ago

I think creating a private endpoint would also be beneficial to limit access to only authorized users.

upvoted 0 times

...

Nicholle

7 months ago

I believe we should also create database-level firewall rules for extra security measures.

upvoted 0 times

...

Dewitt

7 months ago

I agree, that would help ensure each customer only accesses their own database.

upvoted 0 times

...

Ronna

7 months ago

I think we should create a network security group (NSG) to restrict access.

upvoted 0 times

...

Jolanda

8 months ago

I agree. Creating a private endpoint will ensure each customer can only access its own database.

upvoted 0 times

...

Tomas

8 months ago

Yes, that's a good idea. We should also create a private endpoint.

upvoted 0 times

...

Sharen

8 months ago

I think we should create a database-level firewall rule.

upvoted 0 times

Theresia

7 months ago

Agreed, denying public access will help limit the risk of unauthorized access to the databases.

upvoted 0 times

...

Amber

7 months ago

We should also deny public access to further enhance the security measures.

upvoted 0 times

...

Timothy

7 months ago

Definitely, using a private endpoint can help keep the databases isolated and secure.

upvoted 0 times

...

Barney

7 months ago

I think creating a private endpoint can also help ensure that each customer can only access its own database.

upvoted 0 times

...

Daren

7 months ago

True, network security groups can help restrict access and provide an additional layer of security.

upvoted 0 times

...

Talia

7 months ago

We should also consider creating a network security group to control inbound and outbound traffic.

upvoted 0 times

...

Glen

8 months ago

I agree, creating a database-level firewall rule is important to ensure security.

upvoted 0 times

...