Hotspot Question
You have a semantic model that contains the following tables:
- Sales
- Product
- Location
You are creating a DAX measure named Measure1that will calculate the percentage of all the sales of a selected product. Measure1will use the following DAX formula.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Drag and Drop Question
You are creating a data flow 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.

You plan to deploy Microsoft Power BI items by using Fabric deployment pipelines. You have a deployment pipeline that contains three stages named Development, Test, and Production. A workspace is assigned to each stage.
You need to provide Power BI developers with access to the pipeline. The solution must meet the following requirements:
- Ensure that the developers can deploy items to the workspaces for
Development and Test.
- Prevent the developers from deploying items to the workspace for
Production.
- Follow the principle of least privilege.
Which three levels of access should you assign to the developers? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

You have a Fabric tenant.
You are creating a Fabric Data Factory pipeline.
You have a stored procedure that returns the number of active customers and their average sales for the current month.
You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
Which type of activity should you add?

You need to create a Microsoft Power BI file that will be used to create multiple reports. The solution must meet the following requirements:
- The file must include predefined data source connections.
- The file must include the report structure and formatting.
- The file must NOT contain any data.
Which file format should you use?