Question 67 of 156 from exam DP-900: Microsoft Azure Data Fundamentals

Question 67 of 156 from exam DP-900: Microsoft Azure Data Fundamentals

Question

HOTSPOT -

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

Explanations

Box 1: Yes -

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

You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.

Box 2: No -

SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.

Instead use Azure Data Studio to create SQL notebook.

Box 3: Yes -

You can use the Azure Data Studio to restore databases.

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