Connect to Azure SQL Database from Windows 10 and Ubuntu Desktop | Code Assistance Features | Exam DP-900

Connect to Azure SQL Database from Windows 10 and Ubuntu Desktop

Question

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

The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense.

What should the developers use?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

C

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

The best option for the developers to connect to and query an Azure SQL database from both Windows 10 and Ubuntu Desktop and to have code assistance features such as IntelliSense is to use Azure Data Studio.

Azure Data Studio is a free, cross-platform database tool that can be used to connect to different data sources such as SQL Server, Azure SQL Database, and Azure Data Explorer. It provides a modern, user-friendly interface that allows developers to write, execute, and debug SQL queries, as well as manage their databases.

Azure Data Studio is compatible with both Windows and Linux operating systems, making it an ideal choice for a team of developers that uses different platforms. Additionally, it provides code assistance features such as IntelliSense, which can help developers write accurate SQL queries faster.

While sqlcmd and Microsoft SQL Server Management Studio (SSMS) are also useful tools for connecting to and querying Azure SQL databases, they do not provide the cross-platform compatibility and code assistance features that Azure Data Studio offers.

Azure Data Explorer, on the other hand, is a specialized tool