70-463 · Question #230
Which statements best describe SQL Server Development Tools (SSDT)? (Choose all that apply.)
The correct answer is C. SSDT is a special edition of Visual Studio, distributed with SQL Server 2012, providing a. SQL Server Data Tools (SSDT) is a Visual Studio-based IDE distributed with SQL Server 2012 that provides an integrated development environment for database and BI projects.
Question
Which statements best describe SQL Server Development Tools (SSDT)? (Choose all that apply.)
Options
- ASSDT is an extension of the SQL Server Management Studio that can be used to create
- BSSDT is a special edition of the SQL Server Management Studio, designed to provide an
- CSSDT is a special edition of Visual Studio, distributed with SQL Server 2012, providing a
- DSSDT is a new service in SQL Server 2012 that can be used to perform SQL Server
How the community answered
(43 responses)- A5% (2)
- B2% (1)
- C93% (40)
Why each option
SQL Server Data Tools (SSDT) is a Visual Studio-based IDE distributed with SQL Server 2012 that provides an integrated development environment for database and BI projects.
SSDT is not an extension of SQL Server Management Studio; it is a distinct Visual Studio-based toolset with a different architecture and purpose.
SSDT is not a special edition of SQL Server Management Studio; SSMS and SSDT are separate tools with different design goals.
SSDT is a specialized edition of Visual Studio - not SQL Server Management Studio - that ships with SQL Server 2012 and provides integrated tools for developing database schemas, SSIS packages, SSAS models, and SSRS reports within a single IDE.
SSDT is a development IDE, not a SQL Server service or runtime component; it runs on the developer's workstation, not as a SQL Server service.
Concept tested: SQL Server Data Tools identity and purpose
Source: https://learn.microsoft.com/en-us/sql/ssdt/sql-server-data-tools
Topics
Community Discussion
No community discussion yet for this question.