Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DP-300 Topic 10 Question 86 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 86
Topic #: 10
[All DP-300 Questions]

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.

Show Suggested Answer Hide 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
6 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
...
Thaddeus
8 months ago
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
7 months ago
Let's make sure we cover all the bases to ace this exam!
upvoted 0 times
...
Lavonna
7 months ago
And setting up a server-level firewall rule will add an extra layer of protection.
upvoted 0 times
...
Rodney
7 months ago
Creating a network security group could also help in securing the environment.
upvoted 0 times
...
Clorinda
7 months ago
We definitely need to ensure that each customer's data is secure and isolated.
upvoted 0 times
...
Lavonna
7 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
...
...

Save Cancel