You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

The correct answer is A. 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…

Submitted by takeshi77· Mar 30, 2026Identify considerations for relational data on Azure

Question

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

Options

AMicrosoft SQL Server Data Tools (SSDT)
BMicrosoft SQL Server Management Studio (SSMS)
CAzure Databricks
DAzure Data Studio

How the community answered

(16 responses)

A
94% (15)
C
6% (1)

Explanation

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 https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database- development?view=sql-server-ver15

Topics

#SSDT#database design tools#offline development#SQL Server

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice