You are mapping queries to aggregated data in user-defined aggregations. Which two tools should you use? Each correct answer presents part of the solution.

• A. DAX Studio & SQL Server Profiler
• B. SSMS & Azure Data Studio
• C. Power BI Performance Analyzer & DAX Studio
• D. SQL Server Profiler & Excel

Answer: (A)

When mapping queries to aggregated data in user-defined aggregations, you need visibility into both the DAX layer and what the data source actually receives. DAX Studio lets you see the DAX queries issued by your Power BI model, including how measures and aggregations are resolved and what the engine is executing. SQL Server Profiler captures the real SQL statements and engine events that go to the data source (useful when you’re on DirectQuery or a Live connection), showing exactly which SQL hits which tables and which aggregated structures are used. Together, they let you connect a DAX query to the exact SQL path and the aggregated data being hit, enabling precise mapping from query to aggregation.

Other tool pairs don’t provide this dual visibility. General database tools aren’t focused on analyzing DAX execution within Power BI, and while Power BI Performance Analyzer helps diagnose performance, it doesn’t expose the source-SQL-level details needed to map to aggregations in the same way Profiler does.