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

Microsoft DP-300 Question Answer

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?

Create User1 in the master database.

Assign User1 the db_datareader role for the master database.

Assign User1 the db_datareader role for the databases that Userl creates.

Grant select on sys.databases to public in the master database.

DP-300 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"