Exam DP-900 topic 1 question 90 discussion

I agree with answer and link

This question came up on the exam today

option A

Correct Answer

https://learn.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver16

Agree, correct answer

SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project

...Using SSDT, you can create an offline database project... (https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15)

SDDT can create SSRS, SSIS, SSAS and database development by using the "database project".

Both A and B can do this Offline. Install the Management Studio and you will see that you can use visual tools and work offline.

I agree with the answer. The key word is OFFLINE.

Correct Answer: 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 SQL Server content type with the same ease as you would develop an application in Visual Studio.

Answer A is correct. - SSDT is for designing stuff related to Integration Services, Analysis Services, and Reporting Services. You can also use it to design and deploy databases to SQL Server instances. SSMS is a way to manage SQL server instances.

Given answer is correct.

I agree with the answer A as well.

Weird question. SSDT is not for database development, it includes SSIS for integration development.

A https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#:~:text=SQL%20Server%20Data%20Tools%20(SSDT)%20is%20a%20modern%20development%20tool,Reporting%20Services%20(RS)%20reports.