Microsoft DP-900 Exam - Topic 1 Question 106 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 106
Topic #: 1

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?

AAzure Data Studio

Bsq1cmd

CMicrosoft SQL Server Management Studio (SSMS)

DAzure Data Explorer

Show Suggested Answer

Suggested Answer: A

Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.

Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

by Jennie at Jun 11, 2025, 10:24 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Luis

2 months ago

Definitely Azure Data Studio for intelliSense!

upvoted 0 times

...

Sommer

2 months ago

Wait, can Azure Data Studio run on Ubuntu?

upvoted 0 times

...

Junita

3 months ago

Azure Data Studio is great for code assistance!

upvoted 0 times

...

Eden

3 months ago

I think SSMS is better for Windows users.

upvoted 0 times

...

Francine

3 months ago

Not sure about Azure Data Explorer for this task...

upvoted 0 times

...

Maxima

3 months ago

I remember a question about command-line tools like sqlcmd, but I don't think it offers the IntelliSense that the developers need.

upvoted 0 times

...

Tresa

4 months ago

I recall practicing with Azure Data Explorer, but I don't think it has the same code assistance features as Azure Data Studio.

upvoted 0 times

...

Annelle

4 months ago

I'm not entirely sure, but I feel like SQL Server Management Studio is more for Windows only, right?

upvoted 0 times

...

Martha

4 months ago

I think Azure Data Studio might be the right choice since it supports both Windows and Ubuntu, and I remember it has good IntelliSense features.

upvoted 0 times

...

Theron

4 months ago

Azure Data Studio is the clear winner here. It's cross-platform, has the features we need, and is specifically designed for working with Azure SQL databases.

upvoted 0 times

...

Lashawn

4 months ago

I'm a bit confused on this one. I was considering sq1cmd, but I'm not sure if that has the code assistance features we need. I'll have to look into Azure Data Studio more.

upvoted 0 times

...

Ricarda

5 months ago

Azure Data Studio is definitely the right choice. It's designed for working with Azure SQL databases and has great IntelliSense support.

upvoted 0 times

...

Elli

5 months ago

Hmm, I'm not sure about this one. I was thinking SSMS might be the best option since it's a Microsoft product, but I'm not sure if it works on Ubuntu.

upvoted 0 times

...

Bettina

5 months ago

I think Azure Data Studio is the way to go here. It's cross-platform and has the code assistance features we need.

upvoted 0 times

...

Charlie

7 months ago

SQL cmd? Really? I mean, I get that it's a classic, but who wants to write queries in a plain text editor these days? C'mon, let's keep up with the times here.

upvoted 0 times

Rosina

7 months ago

B: Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Fernanda

7 months ago

A: Azure Data Studio

upvoted 0 times

...

Buffy

8 months ago

Hmm, Azure Data Explorer? I thought that was for Kusto queries, not Azure SQL. I'm gonna have to go with C on this one. SSMS is the tool for the job.

upvoted 0 times

Leonardo

7 months ago

Yeah, Azure Data Explorer is more for Kusto queries. SSMS is the best choice for this scenario.

upvoted 0 times

...

Eleni

7 months ago

I agree, SSMS is the way to go for connecting to Azure SQL.

upvoted 0 times

...

Lina

8 months ago

I'm pretty sure Azure Data Studio has the query editor and IntelliSense we need. Plus, it works on both Windows and Ubuntu, so it's the perfect cross-platform solution.

upvoted 0 times

Yuette

7 months ago

C: I agree, let's go with Azure Data Studio for connecting to and querying the Azure SQL database.

upvoted 0 times

...

Tien

7 months ago

B: Yeah, Azure Data Studio works on both Windows and Ubuntu, so it's the perfect cross-platform solution.

upvoted 0 times

...

Rodrigo

8 months ago

A: I think we should use Azure Data Studio. It has the query editor and IntelliSense we need.

upvoted 0 times

...

Willow

8 months ago

C'mon, it's obvious. SSMS is the way to go for code assistance features like IntelliSense. Azure Data Studio is a bit of a newcomer, and SQL cmd is just for the command line junkies.

upvoted 0 times