Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes

You are writing a set of SQL queries that administrators will use to (DP-900)

Updated on 08/26/2024

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

There are no comments yet.

Authentication required

You must log in to post a comment.
Log in to like this solution

Log in

Support us!
Subscribe Now

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All" you consent to our use of cookies. Privacy Policy.