Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

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 ?

Athe Azure Active director/ (Azure AO) account that created the database

Bthe Azure Active Directly Azure AD) administrator account

Cthe sa account

Dthe server admin login account of the logical server

Show Suggested 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:

Submit Cancel

Zona

8 months ago

Wait, are you sure about that? Sounds a bit off!

upvoted 0 times

...

Melynda

8 months ago

No way, it's the Azure AD account that created the database.

upvoted 0 times

...

Francine

9 months ago

I thought it was the server admin login account?

upvoted 0 times

...

Abel

9 months ago

I always thought the sa account had access to everything.

upvoted 0 times

...

Justa

9 months ago

It's definitely the Azure AD admin account!

upvoted 0 times

...

Theron

9 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

10 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

10 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

10 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

10 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

10 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

11 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

11 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

11 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

1 year ago

I think it's C) the sa account, because it's a system administrator account.

upvoted 0 times

...

Malinda

1 year 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

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.

upvoted 0 times

...

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.

upvoted 0 times

Maybelle

1 year ago

D) the server admin login account of the logical server - Yeah, I think that's the safest option too.

upvoted 0 times

...

Selma

1 year ago

A) the Azure Active director/ (Azure AO) account that created the database

upvoted 0 times

...

...

Nancey

1 year ago

I agree with Lore, because the account that created the database should always have access to it.

upvoted 0 times

...

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?

upvoted 0 times

...

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.

upvoted 0 times

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.

upvoted 0 times

...

Annice

1 year ago

B) the Azure Active Directly Azure AD) administrator account

upvoted 0 times

...

Maddie

1 year ago

A) the Azure Active director/ (Azure AO) account that created the database

upvoted 0 times

...

...

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.

upvoted 0 times

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.

upvoted 0 times

...

Janna

1 year ago

B) the Azure Active Directly Azure AD) administrator account

upvoted 0 times

...

Odette

1 year ago

A) the Azure Active director/ (Azure AO) account that created the database

upvoted 0 times

...

...

Lore

1 year ago

I think the answer is A) the Azure Active Directory account that created the database.

upvoted 0 times

...