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

10 months ago

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

upvoted 0 times

...

Nicholle

10 months ago

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

upvoted 0 times

...

Dewitt

10 months ago

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

upvoted 0 times

...

Ronna

11 months ago

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

upvoted 0 times

...

Jolanda

11 months ago

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

upvoted 0 times

...

Tomas

11 months ago

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

upvoted 0 times

...

Sharen

11 months ago

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

upvoted 0 times

Theresia

11 months ago

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

upvoted 0 times

...

Amber

11 months ago

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

upvoted 0 times

...

Timothy

11 months ago

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

upvoted 0 times

...

Barney

11 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

11 months ago

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

upvoted 0 times

...

Talia

11 months ago

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

upvoted 0 times

...

Glen

11 months ago

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

upvoted 0 times

...