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 by using SQL authentication.
You need to ensure that App1 can access DB2. The solution must meet the following requirements:
App1 must be able to view only DB2.
Administrative effort must be minimized.
What should you create?

Question

Examsnet · Accepted Answer

Correct Answer is :  a contained database user from a Windows login for App1 on DB2

Administering Relational Databases on Microsoft Azure (DP-300) Test 2