MENU
When you create an Azure SQL database, which account can always connect to the database ?
Suggested Answer: D
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
31 comments · newest first
ZO
Zona
10 months ago
Wait, are you sure about that? Sounds a bit off!
ME
Melynda
10 months ago
No way, it's the Azure AD account that created the database.
FR
Francine
10 months ago
I thought it was the server admin login account?
AB
Abel
11 months ago
I always thought the sa account had access to everything.
JU
Justa
11 months ago
It's definitely the Azure AD admin account!
TH
Theron
11 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.
JA
Jackie
11 months ago
I’m a bit confused. I thought the account that created the database had access, but now I’m not so sure.
RE
Rebecka
12 months ago
I practiced a similar question last week, and I believe the server admin login account is the one that always connects.
KA
Karan
12 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.
VE
Venita
12 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.
IZ
Izetta
1 year 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.
LA
Lashaun
1 year 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.
SH
Shenika
1 year 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.
MA
Marguerita
1 year 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.
DA
Daisy
1 year ago
I think it's C) the sa account, because it's a system administrator account.
MA
Malinda
1 year ago
I'm not sure, but I think it might be D) the server admin login account of the logical server.
MU
Muriel
1 year 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.
ER
Erin
1 year 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.
MA
Maybelle
1 year ago
D) the server admin login account of the logical server - Yeah, I think that's the safest option too.
SE
Selma
1 year ago
A) the Azure Active director/ (Azure AO) account that created the database
NA
Nancey
1 year ago
I agree with Lore, because the account that created the database should always have access to it.
TI
Tijuana
1 year 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?
TW
Twanna
1 year 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.
DE
Delisa
1 year 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.
AN
Annice
1 year ago
B) the Azure Active Directly Azure AD) administrator account
MA
Maddie
1 year ago
A) the Azure Active director/ (Azure AO) account that created the database
HE
Herminia
1 year 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.
AR
Aretha
1 year 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.
JA
Janna
1 year ago
B) the Azure Active Directly Azure AD) administrator account
OD
Odette
1 year ago
A) the Azure Active director/ (Azure AO) account that created the database
LO
Lore
1 year ago
I think the answer is A) the Azure Active Directory account that created the database.