DP-500 Question #143: Real Exam Question with Answer & Explanation

Question

You need to create a DAX measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total. How should you complete the measure? To answer, drag the appropriate DAX functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. You have an Azure Synapse Analytics workspace that is connected to an Azure Data Lake Storage Gen2 account. From Synapse Studio, you run the following query. SELECT YEAR (OrderDate) AS OrderYear, SUM(UnitPrice * Quantity) + TaxAmount) AS GrossRevenue FROM dbo.orders GROUP BY YEAR(OrderDate) ORDER BY OrderYear; You need to create a column chart to visualize the changes in gross revenue over time. How should you populate the chart? To answer, drag the appropriate columns to the correct settings. Each column may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.