Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You need to design and model a database by using a graphical tool that (DP-900)
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
A. Microsoft SQL Server Data Tools (SSDT)
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Azure Data Studio
Solution
Correct answer: A. Microsoft SQL Server Data Tools (SSDT).
SSDT is a project-oriented offline database development tool that supports graphical modeling of databases. It allows you to design and develop databases offline, and then deploy them to various platforms, including on-premises SQL Server and Azure SQL Database.
SSMS (B) is primarily a database management and administration tool, while Azure Databricks (C) is a cloud-based analytics platform. Azure Data Studio (D) is a cross-platform database management tool, but it's not specifically designed for offline database development.
Category: Identify considerations for relational data on Azure