You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
Click on the arrows to vote for the correct answer
A. B. C. D.A
https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15The correct answer is A. Microsoft SQL Server Data Tools (SSDT).
Explanation: Microsoft SQL Server Data Tools (SSDT) is a graphical tool that supports project-oriented offline database development. It enables developers to design, develop, and deploy SQL Server databases from within Visual Studio. SSDT provides a visual design environment for creating and modifying database schemas, tables, views, and stored procedures.
Microsoft SQL Server Management Studio (SSMS) is a graphical tool for managing SQL Server databases. While it includes some design tools, it is primarily focused on administration tasks such as managing security, backups, and performance tuning.
Azure Databricks is a cloud-based big data processing and analytics platform. It is not a database design tool.
Azure Data Studio is a cross-platform database management tool for working with on-premises and cloud-based databases. While it includes some design tools, it is primarily focused on administration tasks such as querying, scripting, and debugging.
In summary, if you need to design and model a database by using a graphical tool that supports project-oriented offline database development, Microsoft SQL Server Data Tools (SSDT) is the best option.