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 DP-300 Exam - Topic 10 Question 6 Discussion

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.
B) Create users in each database. and C) Configure the database firewall.
A) Implement row-level security (RLS).
D) Configure the server firewall.
E) Create logins in the master database.
F) Implement Always Encrypted.

Microsoft DP-300 Exam - Topic 10 Question 6 Discussion

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

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.

Show Suggested Answer Hide Answer
Suggested Answer: B, C

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

by Earleen at May 09, 2022, 04:07 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Julianna
9 months ago
Surprised that people think RLS is needed here. Seems unnecessary!
upvoted 0 times
...
Valentin
9 months ago
Agreed, creating logins in the master database is essential!
upvoted 0 times
...
Tiffiny
9 months ago
Wait, row-level security? Isn't that overkill for this?
upvoted 0 times
...
Cary
9 months ago
I think configuring the database firewall is a must too.
upvoted 0 times
...
Cecil
9 months ago
Definitely need to create users in each database!
upvoted 0 times
...
Billi
9 months 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.
upvoted 0 times
...
Merissa
10 months 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.
upvoted 0 times
...
Yolande
10 months 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.
upvoted 0 times
...
Timothy
10 months 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.
upvoted 0 times
...
Reta
10 months 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.
upvoted 0 times
...
Luis
10 months 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.
upvoted 0 times
...
Dorothea
10 months 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.
upvoted 0 times
...

Save Cancel