Microsoft
DP-300 · Question #156
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
Sign in or unlock DP-300 to reveal the answer and full explanation for question #156. The question stem and answer options stay visible for context.
Submitted by certguy· Mar 6, 2026Implement a secure environment
Question
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?
Options
- 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.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.