Deal of The Day! 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
9 months ago
Agreed. By denying public access, we can make sure only authorized users can access the databases.
upvoted 0 times
...
Colton
9 months ago
I think we should also deny public access to further secure the databases.
upvoted 0 times
...
Lauran
9 months ago
Yes, that's true. We can use both private endpoints and database-level firewall rules for added security.
upvoted 0 times
...
Sarah
10 months ago
But wouldn't creating a database-level firewall rule also help in restricting access?
upvoted 0 times
...
Georgeanna
11 months ago
I agree, that way we can ensure each customer only accesses their own database.
upvoted 0 times
...
Mayra
11 months ago
I think we should create a private endpoint for each customer.
upvoted 0 times
...
Thaddeus
11 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
11 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
11 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
12 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
11 months ago
I agree, let's focus on implementing these solutions to ensure success.
upvoted 0 times
...
Wenona
11 months ago
Let's make sure we cover all the bases to ace this exam!
upvoted 0 times
...
Lavonna
11 months ago
And setting up a server-level firewall rule will add an extra layer of protection.
upvoted 0 times
...
Rodney
11 months ago
Creating a network security group could also help in securing the environment.
upvoted 0 times
...
Clorinda
11 months ago
We definitely need to ensure that each customer's data is secure and isolated.
upvoted 0 times
...
Lavonna
11 months ago
Yes, with those in place, each customer will only have access to their own database.
upvoted 0 times
...
Laurel
11 months ago
Absolutely, private endpoint and database-level firewall rules are the key here.
upvoted 0 times
...
...

Save Cancel