Question 80
DP-300 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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?
- ACreate User1 in the master database.
- BAssign User1 the db_datareader role for the master database.
- CAssign User1 the db_datareader role for the databases that User1 creates.
- DGrant SELECT on sys.databases to public in the master database.