👉Get Full PDF
| Question.26 DRAG DROP You have a Fabric tenant that contains a Microsoft Power BI report named Report1. Report1 is slow to render. You suspect that an inefficient DAX query is being executed. You need to identify the slowest DAX query, and then review how long the query spends in the formula engine as compared to the storage engine. Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.  |
26. Click here to View Answer
Answer:
| Question.27 You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view? (A) displayHTML (B) show (C) write (D) display |
27. Click here to View Answer
Answer: D
| Question.28 DRAG DROP You create a semantic model by using Microsoft Power BI Desktop. The model contains one security role named SalesRegionManager and the following tables: Sales SalesRegion SalesAddress You need to modify the model to ensure that users assigned the SalesRegionManager role cannot see a column named Address in SalesAddress. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.  |
28. Click here to View Answer
Answer:
| Question.29 HOTSPOT You have a Fabric tenant that contains lakehouse named Lakehouse1. Lakehouse1 contains a Delta table with eight columns. You receive new data that contains the same eight columns and two additional columns. You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements: Keep all the existing rows. Ensure that all the new data is added to the table. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.  |
29. Click here to View Answer
Answer:
| Question.30 You have a Fabric workspace named Workspace1 and an Azure SQL database. You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join. The solution must minimize development effort. What should you do? (A) Append the queries by using fuzzy matching. (B) Merge the queries by using fuzzy matching. (C) Append the queries by using a lookup table. (D) Merge the queries by using a lookup table. |
30. Click here to View Answer
Answer: B