- All Exams Instant Download
Which function should you include in the step?
You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?A . Table....
What should you do?
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?A . Reference the...
What are two ways to achieve the goal?
You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode. You suspect that some DAX queries load unnecessary columns into memory. You need to identify the frequently used columns that are loaded into memory. What are two ways to achieve the goal? Each correct...
How should you complete the DAX expression?
DRAG DROP You have a Fabric tenant that contains a semantic model. The model contains data about retail stores. You need to write a DAX query that will be executed by using the XMLA endpoint The query must return a table of stores that have opened since December 1,2023. How...
How should you complete the DAX code?
HOTSPOT You need to create a DAX measure to calculate the average overall satisfaction score. How should you complete the DAX code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: The measure should use the AVERAGE function...
Which three actions in the Fabric Admin portal should you include in the recommendation?
You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of...
What should you do first?
You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first?A . At the semantic model level, set Large dataset storage format to Off.B . At the tenant level, set Create and use Metrics...
Which two actions should you recommend performing from the Fabric Admin portal?
You need to recommend a solution to prepare the tenant for the PoC. Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.A . Enable the Users can try Microsoft Fabric paid...
When users interact with a report built from the model, which mode will be used by the DAX queries?
You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When users interact with a report built from the model, which mode will be used by the DAX...
How should you complete the T-SQL statement?
HOTSPOT You need to resolve the issue with the pricing group classification. How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: You should use CREATE VIEW to make the pricing group...
