What should you do?

You create five Azure SQL Database instances on the same logical server.

In each database, you create a user for an Azure Active Directory (Azure AD) user named User1.

User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error.

You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases.

What should you do?
A . Create User1 in the master database.
B. Assign User1 the db_datareader role for the master database.
C. Assign User1 the db_datareader role for the databases that Userl creates.
D. Grant select on sys.databases to public in the master database.

View Answer

Answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage