What should you create?

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?
A . a contained database user for App1 on DB2
B . a login for App1 on Server1
C . a contained database user from an external provider for App1 on DB2
D . a contained database user from a Windows login for App1 on DB2

View Answer

Answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-ver15