DRAG DROP - Match the tools to the appropriate descriptions. To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all. Select and Place:
Suggested Answer:
Box 1: Microsoft SQL Server Management Studio (SSMS) SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.
Box 2: Azure Data Studio - Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. Box 3: Microsoft SQL Server Data Tools (SSDT) SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio. Reference: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms https://code.visualstudio.com/docs/supporting/FAQ https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
SSDT for database projects is normally what people talk about when they say "why should I use ssdt over ssms", what I normally say is that ssms is an administration tool, and ssdt is the developer tool. If you have a simple database and it is not very complex then ssdt is probably an overhead you don't need.
https://stackoverflow.com/questions/36370135/i-do-not-understand-what-ssdt-do-as-opposed-to-or-not-ssms-and-sql-server-obj#:~:text=SSDT%20for%20database%20projects%20is,overhead%20you%20don't%20need.
You can see this table, also you know that you have access to this table during the exam
https://learn.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio?view=sql-server-ver15.
Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, and view and save results as text, JSON, or Excel. Edit data, organize your favourite database connections and browse database objects in a familiar object browsing experience.
upvoted 4 times
...
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
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.
PatYeo
Highly Voted 2 years, 1 month agoPI_Team
Most Recent 5 months, 2 weeks agoAGTraining
8 months agoHRKK
1 year, 4 months agochiiiweiii
1 year, 8 months agoPRALLAB
2 years ago