MENU
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.
Suggested Answer: C, D
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
RO
Roosevelt
11 months ago
Denying public access is a must for security!
RY
Ryann
11 months ago
Wait, can customers really be isolated like that? Sounds tricky!
BR
Britt
11 months ago
A server-level firewall rule? Not sure if that's necessary.
AM
Amira
12 months ago
I think creating a private endpoint is a solid choice too.
MA
Maryann
12 months ago
Definitely need a database-level firewall rule!
BE
Becky
1 year ago
I’m leaning towards the server-level firewall rule and denying public access, but I wonder if we need both a server and database-level rule for complete security.
DE
Denny
1 year ago
I’m a bit confused about whether to choose a private endpoint or a network security group. I think private endpoints might be more relevant for direct access.
YE
Yesenia
1 year ago
I remember practicing a similar question where we had to limit access to resources. I feel like denying public access is definitely part of the solution here.
MI
Ming
1 year ago
I think creating a database-level firewall rule is important to restrict access to each customer's database, but I'm not sure if we also need a server-level rule.
BI
Billy
1 year ago
Creating a private endpoint seems like the way to go here. That way, each customer can access their own database without any additional firewall configuration. Minimizing administrative effort is key, so I'll focus on that approach.
LA
Lauran
1 year ago
I'm pretty confident that denying public access and creating a database-level firewall rule for each customer would work. But the question is asking for the two best actions, so I'll need to think through the other options as well.
CA
Carmelina
1 year ago
Okay, I think I've got this. Creating a private endpoint will allow each customer to securely connect to their database without needing to manage firewall rules. That sounds like the best way to minimize administrative effort.
SA
Sarah
1 year ago
Hmm, I'm a bit confused here. Do I need to create both a network security group and a server-level firewall rule? Or is it just one or the other?
LE
Leonardo
1 year ago
This seems like a straightforward security question. I'll focus on minimizing administrative effort while ensuring each customer can only access their own database.
AB
Abraham
1 year ago
Hmm, I'm a bit unsure about this one. The question mentions regulations, so I'm wondering if state transition testing might be more appropriate to ensure the system is handling the different regulatory scenarios correctly.
EL
Elbert
1 year ago
I remember learning about Salesforce's email integration features, so I'm pretty sure the answer is True. The key is that it says "all of these communications" will be saved, so that covers the different types listed. I'll mark True and move on.
RU
Rutha
2 years ago
Agreed. By denying public access, we can make sure only authorized users can access the databases.
CO
Colton
2 years ago
I think we should also deny public access to further secure the databases.
LA
Lauran
2 years ago
Yes, that's true. We can use both private endpoints and database-level firewall rules for added security.
SA
Sarah
2 years ago
But wouldn't creating a database-level firewall rule also help in restricting access?
GE
Georgeanna
3 years ago
I agree, that way we can ensure each customer only accesses their own database.
MA
Mayra
3 years ago
I think we should create a private endpoint for each customer.
TH
Thaddeus
3 years 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.
TI
Tiera
3 years 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.
LO
Loreta
3 years 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.
MA
Marica
3 years 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!
LE
Levi
3 years ago
I agree, let's focus on implementing these solutions to ensure success.
WE
Wenona
3 years ago
Let's make sure we cover all the bases to ace this exam!
LA
Lavonna
3 years ago
And setting up a server-level firewall rule will add an extra layer of protection.
RO
Rodney
3 years ago
Creating a network security group could also help in securing the environment.
CL
Clorinda
3 years ago
We definitely need to ensure that each customer's data is secure and isolated.
LA
Lavonna
3 years ago
Yes, with those in place, each customer will only have access to their own database.
LA
Laurel
3 years ago
Absolutely, private endpoint and database-level firewall rules are the key here.