nerdexam
Microsoft

AI-100 · Question #58

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…

The correct answer is A. Microsoft SQL Server on a Microsoft Azure virtual machine. Row-level security is supported by SQL Server, Azure SQL Database, and Azure SQL Data https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-

Design AI solutions

Question

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?

Options

  • AMicrosoft SQL Server on a Microsoft Azure virtual machine
  • BMicrosoft Azure Database for MySQL
  • CMicrosoft Azure Data Lake Store
  • DMicrosoft Azure Cosmos DB

How the community answered

(55 responses)
  • A
    80% (44)
  • B
    4% (2)
  • C
    5% (3)
  • D
    11% (6)

Explanation

Row-level security is supported by SQL Server, Azure SQL Database, and Azure SQL Data https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-

Topics

#row-level security#SQL Server#geographic data isolation#database security

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AI-100 Practice