Question 91

You have a Microsoft Power Bl semantic model that is used by your company ' s finance and sales departments for monthly reporting. The semantic model contains two explicit measures named sales Amount and Orders and a measure named KPI Title that returns text for dynamic visual titles.
You need to implement a calculation group named Time Intelligence that contains a column named Time Calculation. The solution must meet the following requirements
* Apply time-intelligence patterns to both explicit measures by using SELECTEDMEASURE().
* Format only the yoy% calculation item as a percentage.
What should you configure ' To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point

Question 92

You have Fabric tenant.
You need to create a sematic model that delivers fast report rendering, minimizes query latency, and maximizes flexibility for DAX calculations.
Which storage mode should you select?
  • Question 93

    You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?
  • Question 94

    You have a Fabric warehouse that contains a table named SalesOrderDetail. SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.
    You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.
    Which T-SQL statement should you run?
  • Question 95

    You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement.
    You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine.
    How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value 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.
    NOTE: Each correct selection is worth one point.