MENU
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?
Suggested Answer: C
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
BR
Brice
11 months ago
Wait, can User1 even see all databases without proper permissions?
KA
Karon
11 months ago
Definitely agree with Pa on this one!
TR
Tran
11 months ago
Isn't granting select on sys.databases a bit risky?
KA
Kasandra
12 months ago
I think assigning db_datareader in the master is the way to go!
PA
Pa
12 months ago
You need to create User1 in the master database.
AS
Asuncion
1 year ago
I’m leaning towards creating User1 in the master database, but I also recall that roles might be necessary for full access.
LE
Leatha
1 year ago
I practiced a similar question where we had to grant permissions, and I feel like granting select on sys.databases could be a solution, but it seems a bit risky.
LA
Lavera
1 year ago
I think assigning roles like db_datareader could help, but I’m not clear if it should be for the master database or the individual databases.
AS
Ashton
1 year ago
I remember something about needing to create users in the master database, but I'm not sure if that's the only step needed for visibility.
LE
Lennie
1 year ago
Interesting, I was thinking we'd need to grant select permissions on sys.databases to public in the master database. But your approach makes more sense to me.
MA
Mari
1 year ago
Okay, I've got it. We need to assign User1 the db_datareader role for the master database. That should allow them to see all the databases on the logical server.
TE
Teri
1 year ago
Hmm, I'm a bit confused. Do we need to create User1 in the master database, or just assign the right permissions? I'll have to think this through carefully.
SH
Sherly
1 year ago
This seems like a straightforward permissions issue. I think the key is to grant User1 the necessary access to see all the databases.
AL
Alesia
1 year ago
Redirecting standard error to standard output - that's the key here. I've got this.
AP
Apolonia
2 years ago
I'm just gonna go with option E: Summon the Azure database gods and hope they fix it for me. That's how it works, right?
KE
Kendra
1 year ago
That makes sense. I'll go with that option. Thanks!
FR
Franklyn
1 year ago
I think the correct option is to create User1 in the master database.
TA
Tamar
1 year ago
Option E is not a valid choice. You need to choose from the provided options.
JO
Johanna
2 years ago
Option B sounds good to me. I mean, who doesn't love a little data reading? It's like reading a really boring book, but with databases instead of words.
BR
Breana
1 year ago
User1: Thanks, I'll give that a try.
HY
Hyman
1 year ago
User3: That makes sense, User1 needs access to all the databases.
CA
Carin
1 year ago
User2: You should assign User1 the db_datareader role for the master database.
RE
Renea
1 year ago
User1: I can't connect to the logical server in Azure Data Studio.
EV
Evette
2 years ago
Hmm, this is a tricky one. I'm leaning towards option C, since User1 is an Azure AD user and the databases they created should be visible to them. But I could be wrong.
HO
Hobert
1 year ago
I agree, option C seems like the best solution to ensure User1 can see all the databases when connecting with Azure Data Studio.
GI
Gilma
1 year ago
I think option C is the correct choice. User1 should be assigned the db_datareader role for the databases they create.
JO
Johanna
2 years ago
I'm not sure about this one. Maybe option D would work, but that seems a bit too broad. I'll have to think about this one a bit more.
AL
Alaine
2 years ago
I think the answer is B. Assigning User1 the db_datareader role for the master database will allow them to see all the databases, since the master database contains metadata about all the databases on the logical server.
RO
Rodolfo
2 years ago
Hmm, that makes sense too. Let's see what others think before we make our final decision.
HO
Howard
2 years ago
I disagree, I believe the answer is D. Granting select on sys.databases to public in the master database would give User1 access to all databases.
RO
Rodolfo
2 years ago
I think the answer is C. Assigning User1 the db_datareader role for the databases that User1 creates would allow them to see all the databases.