Microsoft Azure Data Fundamentals — Question 285

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

Answer options

• A. Microsoft SQL Server Data Tools (SSDT)
• B. Microsoft SQL Server Management Studio (SSMS)
• C. Azure Databricks
• D. Azure Data Studio

Correct answer: A

Explanation

Microsoft SQL Server Data Tools (SSDT) is specifically designed for database development and modeling, making it the ideal choice for project-oriented offline tasks. In contrast, Microsoft SQL Server Management Studio (SSMS) is primarily for database management, Azure Databricks focuses on big data analytics, and Azure Data Studio is more suited for data analysis and querying rather than extensive database design.