DP-300 Certification Practice Question #292

Question

You are evaluating the business goals.
Which feature should you use to provide customers with the required level of access based on their service agreement?

Accepted Answer

The scenario requires providing customers with different table and row-level access in the database based on their specific service agreement. Row-Level Security (RLS) is the native SQL Server/Azure SQL database feature designed specifically to restrict row-level data access based on the executing user's context or role. Although the deployment model provisions separate databases for customers, managing the specific table and row access policies within those databases to align with service agreements is best achieved using RLS.

More DP-300 practice questions