Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You are writing a set of SQL queries that administrators will use to (DP-900)
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?
A. Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
C. Azure CLI
D. Azure PowerShell
Solution
Correct answer: B. Azure Data Studio.
Azure Data Studio is a cross-platform database tool that allows you to embed documents and query results into a SQL notebook. This feature is particularly useful for troubleshooting Azure SQL databases, as it enables administrators to create interactive reports and documentation that can be shared with other team members.
In contrast, the other options are not suitable for this task:
A. Microsoft SQL Server Management Studio (SSMS) is a desktop application that can be used to manage SQL Server databases, but it does not have the notebook functionality required for this use case.
C. Azure CLI is a command-line interface for managing Azure resources, but it does not provide a notebook environment for embedding documents and query results.
D. Azure PowerShell is a PowerShell-based command-line interface for managing Azure resources, similar to Azure CLI, and it also does not have the notebook capabilities needed for this task.
Category: Identify considerations for relational data on Azure