exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 78 discussion

Actual exam question from Microsoft's DP-900
Question #: 78
Topic #: 1
[All DP-900 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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.
Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
dayan911
Highly Voted 3 years, 3 months ago
1. Yes 2.No 3.Yes
upvoted 60 times
...
Meyti
Highly Voted 2 years, 11 months ago
I was not sure with option 3 , but the answer is correct, and the source: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio?view=sql-server-ver15#database-administration
upvoted 16 times
Jangoman
2 years, 9 months ago
You can restore but cant take backups
upvoted 6 times
BabyBee
2 years, 6 months ago
Can do Restore/Backups with Azure Data Studio. Feature Azure Data Studio SSMS Backup / Restore Yes Yes
upvoted 4 times
...
...
...
PI_Team
Most Recent 5 months, 2 weeks ago
see the tables! BTW, option 3 is in preview so I presume Yes is the correct answer https://learn.microsoft.com/en-us/azure-data-studio/what-is-azure-data-studio?view=sql-server-ver16
upvoted 2 times
...
AGTraining
8 months ago
1. Yes 2.No 3.Yes
upvoted 1 times
...
gabo
8 months, 2 weeks ago
Backup/Restore option is in Preview mode in Azure Data Studio, but never the less, it's available, so the answer is YES.
upvoted 2 times
...
jxs221
8 months, 3 weeks ago
The correct answer is Yes , No , NO
upvoted 1 times
...
chiiiweiii
1 year, 8 months ago
YNY are Correct Answer
upvoted 3 times
...
xRiot007
2 years, 3 months ago
Yes - you can use Az Data Studio to query DBs. The device is irrelevant No Yes - the tool can do restores.
upvoted 5 times
...
RichMelbourne
2 years, 6 months ago
Shown on test 15/04/2022
upvoted 5 times
...
SiDoCiOuS
2 years, 7 months ago
Appeared on the exam on 03/22/2022 Answers are correct! Yes, No, Yes
upvoted 5 times
...
Meyti
2 years, 11 months ago
I was not sure with option 3 , but the answer is correct, and the source: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio?view=sql-server-ver15#database-administration
upvoted 2 times
...
azurebilearning
3 years, 1 month ago
Correct Answers
upvoted 2 times
...
MONALISA10
3 years, 1 month ago
answers are correct
upvoted 1 times
...
valente_sven1
3 years, 2 months ago
Given answers are correct
upvoted 1 times
...
azureprac1
3 years, 4 months ago
Option 1 seem to be incorrect
upvoted 2 times
...
NarendraGillalu
3 years, 4 months ago
Correct!
upvoted 3 times
...
Ihueghian
3 years, 5 months ago
SQL notebook: Azure Data Studio instead
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago