Designing and Implementing an Azure AI Solution (legacy) — Question 56

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?

Answer options

• 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

Correct answer: A

Explanation

Microsoft SQL Server on a Microsoft Azure virtual machine supports row-level security, allowing you to enforce data access based on user geography. The other options, such as Azure Database for MySQL, Data Lake Store, and Cosmos DB, do not provide the same level of support for row-level security, making them unsuitable for this requirement.