You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL databases named DB1 and DB2. You plan to deploy a Windows app named App1 that will authenticate to DB2

Question

Options

• Aa contained database user for App1 on DB2
• Ba login for App1 on Server1
• Ca contained database user from an external provider for App1 on DB2
• Da contained database user from a Windows login for App1 on DB2

• A
  78% (25)
• B
  13% (4)
• C
  3% (1)
• D
  6% (2)

Explanation

Use contained database users to authenticate SQL Server and SQL Database connections at the database level. A contained database is a database that is isolated from other databases and from the instance of SQL Server/ SQL Database (and the master database) that hosts the database. SQL Server supports contained database users for both Windows and SQL Server https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users- making-your-database-portable?view=sql-server-ver15

No community discussion yet for this question.