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.Add a unique field to each row.
• B.Modify the Sort Column By property for all columns.
• C.Modify the Summarize By property for all columns.
• D.Reference the columns in the Python code by index.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.
You create a Microsoft Power Bl semantic model named Modell that uses the CSV files as a data source. You configure incremental refresh for Model 1 and publish the model to a Premium capacity in the Fabric tenant.
When you initiate a refresh of Model1, the refresh fails after running out of resources.
What is a possible cause of the failure?

• A.Query folding is occurring.
• B.Only refresh complete days is selected.
• C.XMLA Endpoint is set to Read Only.
• D.Query folding is NOT occurring.
• E.The data type of the column used to partition the data has changed.

Comment: *

Name: *

Email: *

Verification: *

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 features option for specific security groups.
• B.Enable the Allow Azure Active Directory guest users to access Microsoft Fabric option for specific security groups.
• C.Enable the Users can create Fabric items option and exclude specific security groups.
• D.Enable the Users can try Microsoft Fabric paid features option for the entire organization.
• E.Enable the Users can create Fabric items option for specific security groups.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer.
When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.
You need to identify whether maintenance tasks were performed on Customer.
Solution: You run the following Spark SQL statement:
DESCRIBE HISTORY customer
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains two lakehouses.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *