DP-900 Describe an analytics workload on Azure Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Azure Synapse Studio

  Why it's wrong here

  Azure Synapse Studio is designed for large-scale data warehousing and big data analytics, not for self-service interactive reporting from a single Azure SQL Database; it requires provisioning a dedicated SQL pool and involves complex pipeline orchestration, which contradicts the minimal IT support requirement. It is tempting because Synapse Studio includes a built-in visual query editor and can connect to Azure SQL Database, but its primary purpose is enterprise-scale data integration and analytics, where it would be correct for scenarios needing unified data lake and warehouse processing with Microsoft Entra ID authentication.

• ✗

  SQL Server Management Studio

  Why it's wrong here

  SQL Server Management Studio (SSMS) is a database administration and query tool that provides a rich Object Explorer, T-SQL editor, and execution plans, but it does not include a report authoring surface for interactive visuals. While SSMS can integrate with SQL Server Reporting Services (SSRS) to deploy paginated reports, that requires separate Report Builder or Visual Studio tooling and is not a self-service experience for an analyst. Its purpose is to manage database objects, not to craft clickable, filterable dashboards from a data source.

• ✓

  Power BI Desktop

  Why this is correct

  Power BI Desktop is the correct choice because it is a dedicated self-service business intelligence tool that lets an analyst connect to an Azure SQL Database, import or DirectQuery data, shape it with Power Query, and build a semantic model with relationships and DAX measures. It provides drag-and-drop, interactive visuals—like slicers, cross-filtering, and drill-through—that can be published to the Power BI service for sharing and collaboration. This aligns with the analyst's requirement to create interactive reports without needing IT administrator intervention.

• ✗

  Azure Data Studio

  Why it's wrong here

  Azure Data Studio is a cross-platform, modern editor for querying SQL Server and Azure SQL, offering T-SQL queries, SQL notebooks, and charting extensions, but its core focus is on database development, not report creation. It lacks the rich interactive visual canvas, drill-down, and paginated-report sharing capabilities of a dedicated BI tool, and it is primarily used by developers and admins for scripting and monitoring. An analyst could produce a simple chart, but not a shareable, interactive report ecosystem.