New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 1 Question 105 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 105
Topic #: 1
[All DP-900 Questions]

When you create an Azure SQL database, which account can always connect to the database ?

Show Suggested Answer Hide Answer
Suggested Answer: D

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.


https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

by Denae at May 05, 2025, 05:07 AM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Zona
2 months ago
Wait, are you sure about that? Sounds a bit off!
upvoted 0 times
...
Melynda
2 months ago
No way, it's the Azure AD account that created the database.
upvoted 0 times
...
Francine
3 months ago
I thought it was the server admin login account?
upvoted 0 times
...
Abel
3 months ago
I always thought the sa account had access to everything.
upvoted 0 times
...
Justa
3 months ago
It's definitely the Azure AD admin account!
upvoted 0 times
...
Theron
3 months ago
I remember reading that the Azure AD account has special permissions, but I can't recall if it's the admin or the one that created it.
upvoted 0 times
...
Jackie
4 months ago
I’m a bit confused. I thought the account that created the database had access, but now I’m not so sure.
upvoted 0 times
...
Rebecka
4 months ago
I practiced a similar question last week, and I believe the server admin login account is the one that always connects.
upvoted 0 times
...
Karan
4 months ago
I think it's the Azure AD administrator account, but I'm not entirely sure. I remember something about it being the one with elevated privileges.
upvoted 0 times
...
Venita
4 months ago
This seems like a tricky one, but I think the key is understanding the different admin roles in Azure SQL. Based on my knowledge, the Azure AD account that created the database should always have access, so I'm going with option A.
upvoted 0 times
...
Izetta
4 months ago
I'm a little confused by this question. I know there are different ways to authenticate and access an Azure SQL database, but I'm not sure which one is always allowed. I'll have to review my notes on Azure SQL security before answering this.
upvoted 0 times
...
Lashaun
5 months ago
Okay, I've got this. When you create an Azure SQL database, the server admin login account is automatically granted access. So the correct answer has to be option D.
upvoted 0 times
...
Shenika
5 months ago
Hmm, I'm a bit unsure about this one. I know the Azure AD administrator account has broad permissions, but I'm not sure if that's the same as the account that created the database. Let me think this through carefully.
upvoted 0 times
...
Marguerita
5 months ago
I think this is a pretty straightforward question. The Azure AD account that created the database should always have access, so I'm going with option A.
upvoted 0 times
...
Daisy
9 months ago
I think it's C) the sa account, because it's a system administrator account.
upvoted 0 times
...
Malinda
9 months ago
I'm not sure, but I think it might be D) the server admin login account of the logical server.
upvoted 0 times
...
Muriel
9 months ago
This question is so easy, it's almost like the exam is trying to trick us. D) the server admin login account of the logical server, end of story. Unless, of course, the exam writers have a twisted sense of humor and have buried the real answer somewhere deep in the options.
upvoted 0 times
...
Erin
9 months ago
B) the Azure Active Directly Azure AD) administrator account - wait, is that even a real thing? Azure AD, Azure AO, what is this, a new alphabet soup? I'm going with D, just to be safe.
upvoted 0 times
Maybelle
8 months ago
D) the server admin login account of the logical server - Yeah, I think that's the safest option too.
upvoted 0 times
...
Selma
9 months ago
A) the Azure Active director/ (Azure AO) account that created the database
upvoted 0 times
...
...
Nancey
9 months ago
I agree with Lore, because the account that created the database should always have access to it.
upvoted 0 times
...
Tijuana
9 months ago
This question is a piece of cake! The answer is clearly D) the server admin login account of the logical server. What kind of exam is this, a joke?
upvoted 0 times
...
Twanna
9 months ago
A) the Azure Active director/ (Azure AO) account that created the database - I'm pretty sure that's the right answer, unless Microsoft has done something really weird with their SQL database management.
upvoted 0 times
Delisa
9 months ago
A) the Azure Active director/ (Azure AO) account that created the database - I'm pretty sure that's the right answer, unless Microsoft has done something really weird with their SQL database management.
upvoted 0 times
...
Annice
9 months ago
B) the Azure Active Directly Azure AD) administrator account
upvoted 0 times
...
Maddie
9 months ago
A) the Azure Active director/ (Azure AO) account that created the database
upvoted 0 times
...
...
Herminia
10 months ago
D) the server admin login account of the logical server - duh, that's the only one that makes sense! You can't connect with a random Azure AD account or the SA account, that's just crazy talk.
upvoted 0 times
Aretha
9 months ago
D) the server admin login account of the logical server - duh, that's the only one that makes sense! You can't connect with a random Azure AD account or the SA account, that's just crazy talk.
upvoted 0 times
...
Janna
9 months ago
B) the Azure Active Directly Azure AD) administrator account
upvoted 0 times
...
Odette
9 months ago
A) the Azure Active director/ (Azure AO) account that created the database
upvoted 0 times
...
...
Lore
10 months ago
I think the answer is A) the Azure Active Directory account that created the database.
upvoted 0 times
...

Save Cancel