MENU
You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server.
You need to ensure that each customer can only connect to and access their respective database.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Suggested Answer: B, C
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
Manage database access by adding users to the database, or allowing user access with secure connection strings.
Database-level firewall rules only apply to individual databases.
https://docs.microsoft.com/en-us/azure/azure-sql/database/secure-database-tutorial
12 comments · newest first
JU
Julianna
12 months ago
Surprised that people think RLS is needed here. Seems unnecessary!
VA
Valentin
1 year ago
Agreed, creating logins in the master database is essential!
TI
Tiffiny
1 year ago
Wait, row-level security? Isn't that overkill for this?
CA
Cary
1 year ago
I think configuring the database firewall is a must too.
CE
Cecil
1 year ago
Definitely need to create users in each database!
BI
Billi
1 year ago
I practiced a similar question where we had to set up user access, and I remember that creating users in each database was part of the solution.
ME
Merissa
1 year ago
Row-level security seems like it would be useful, but I don’t think it applies here since we need to restrict access to entire databases, not just rows.
YO
Yolande
1 year ago
I think configuring the database firewall could help restrict access, but I’m a bit confused about whether I should also create logins in the master database.
TI
Timothy
1 year ago
I remember that creating users in each database is important for access control, but I'm not sure if that's the only step needed.
RE
Reta
1 year ago
File integrity monitoring sounds like the best option to me. It's a dedicated tool for monitoring critical data and reporting any changes, which is exactly what the question is asking for.
LU
Luis
1 year ago
Alright, I think I've got it. The Deployment Report includes the version of InfoScale and how discovered storage is being consumed by host. The other options don't sound familiar to me, so I'll have to guess on those.
DO
Dorothea
1 year ago
This seems straightforward to me. The developer just needs to create a test class and methods to cover the Apex trigger, as option A suggests. The 95% coverage on the helper class is irrelevant if the trigger itself isn't tested.