Microsoft
70-463 · Question #230
70-463 Question #230: Real Exam Question with Answer & Explanation
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
Explanation
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.
Common mistakes.
- A. SSDT is not an extension of SQL Server Management Studio; it is a distinct Visual Studio-based toolset with a different architecture and purpose.
- B. SSDT is not a special edition of SQL Server Management Studio; SSMS and SSDT are separate tools with different design goals.
- D. 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
Reference. https://learn.microsoft.com/en-us/sql/ssdt/sql-server-data-tools
Community Discussion
No community discussion yet for this question.