Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
A team of developers has computers that run Windows 10 and Ubuntu (DP-900)
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?
A. sqlcmd
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Data Studio
D. Azure Data Explorer
Solution
Correct answer: C. Azure Data Studio.
Azure Data Studio is a cross-platform database management tool that supports Windows, macOS, and Linux. It provides IntelliSense code assistance features and supports connections to Azure SQL databases. Since the developers use both Windows 10 and Ubuntu Desktop, Azure Data Studio's cross-platform compatibility makes it a suitable choice.
Azure Data Studio also supports SQL Server, PostgreSQL, and other database platforms, making it a versatile tool for database management and querying.
Here's why the other options are not the best fit:
A. sqlcmd is a command-line tool that does not provide IntelliSense code assistance features.
B. Microsoft SQL Server Management Studio (SSMS) is a Windows-only application, which would not be suitable for the developers using Ubuntu Desktop.
D. Azure Data Explorer is a tool primarily used for big data analytics and does not provide the same level of database management and querying features as Azure Data Studio.
Category: Identify considerations for relational data on Azure