Which database solution should you use to store the application data?

You plan to deploy two AI applications named AI1 and AI2. The data for the applications will be stored in a relational database.

You need to ensure that the users of AI1 and AI2 can see only data in each user’s respective geographic region. The solution must be enforced at the database level by using row-level security.

Which database solution should you use to store the application data?
A . Microsoft SQL Server on a Microsoft Azure virtual machine
B . Microsoft Azure Database for MySQL
C . Microsoft Azure Data Lake Store
D . Microsoft Azure Cosmos DB

View Answer

Answer: A

Explanation:

Row-level security is supported by SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-2017