Microsoft Exam DP-300 Topic 10 Question 86 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 86
Topic #: 10

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 Malcolm at Mar 17, 2024, 09:58 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Rutha

5 months ago

Agreed. By denying public access, we can make sure only authorized users can access the databases.

upvoted 0 times

...

Colton

6 months ago

I think we should also deny public access to further secure the databases.

upvoted 0 times

...

Lauran

6 months ago

Yes, that's true. We can use both private endpoints and database-level firewall rules for added security.

upvoted 0 times

...

Sarah

7 months ago

But wouldn't creating a database-level firewall rule also help in restricting access?

upvoted 0 times

...

Georgeanna

7 months ago

I agree, that way we can ensure each customer only accesses their own database.

upvoted 0 times

...

Mayra

7 months ago

I think we should create a private endpoint for each customer.

upvoted 0 times

...

Hmm, I'm not sure about that. I think creating a private endpoint could also be a good solution. That would allow us to isolate the databases from the public internet and control access more granularly.

upvoted 0 times

...

Tiera

8 months ago

That's a good point. Database-level firewall rules would allow us to control access to each individual database, which seems like the most targeted approach. And it would minimize the administrative overhead compared to setting up an NSG.

upvoted 0 times

...

Loreta

8 months ago

Okay, so it sounds like the two best options here are database-level firewall rules and creating a private endpoint. Both of those would allow us to isolate the databases and control access for each customer, which is exactly what we need.

upvoted 0 times

...

Marica

8 months ago

Haha, you're probably right, Michael. They're definitely trying to see if we can think critically and not just go for the obvious answer. But I think we've got this - private endpoint and database-level firewall rules are the way to go. Time to ace this exam!

upvoted 0 times

Levi

7 months ago

I agree, let's focus on implementing these solutions to ensure success.

upvoted 0 times

...

Wenona

8 months ago

Let's make sure we cover all the bases to ace this exam!

upvoted 0 times

...

Lavonna

8 months ago

And setting up a server-level firewall rule will add an extra layer of protection.

upvoted 0 times

...

Rodney

8 months ago

Creating a network security group could also help in securing the environment.

upvoted 0 times

...

Clorinda

8 months ago

We definitely need to ensure that each customer's data is secure and isolated.

upvoted 0 times

...

Lavonna

8 months ago

Yes, with those in place, each customer will only have access to their own database.

upvoted 0 times

...

Laurel

8 months ago

Absolutely, private endpoint and database-level firewall rules are the key here.

upvoted 0 times

...

Microsoft Exam DP-300 Topic 10 Question 86 Discussion

Contribute your Thoughts:

Rutha

Colton

Lauran

Sarah

Georgeanna

Mayra

Thaddeus

Tiera

Loreta

Marica

Levi

Wenona

Lavonna

Rodney

Clorinda

Lavonna

Laurel