You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

• A.Change the MD5 hash to SHA256.
• B.Increase the capacity.C Enable V-Order
• C.Modify the surrogate keys to use a different data type.
• D.Create views.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:
Orders
Customer
Employee
The Employee table contains Personally Identifiable Information (PII).
A data engineer is building a workflow that requires writing data to the Customer table, however, the user does NOT have the elevated permissions required to view the contents of the Employee table.
You need to ensure that the data engineer can write data to the Customer table without reading data from the Employee table.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Assign the data engineer the Contributor role for Workspace1.
• B.Assign the data engineer the Contributor role for Workspace2.
• C.Create a new workspace named Workspace2 that contains a new lakehouse named Lakehouse2.
• D.Assign the data engineer the Viewer role for Workspace1.
• E.Assign the data engineer the Viewer role for Workspace2.
• F.Migrate the Employee table from Lakehouse1 to Lakehouse2.
• G.Share Lakehouse1 with the data engineer.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a semantic model named Model1.
You need to dynamically execute and monitor the refresh progress of Model1.
What should you use?

• A.dynamic management views in Microsoft SQL Server Management Studio
• B.Monitoring hub
• C.dynamic management views in Azure Data Studio
• D.a semantic link in a notebook

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a data pipeline named Pipeline! as shown in the exhibit.
(Click the Exhibit tab.) What will occur the next time Pipelinel tuns?

• A.Copy.kdi will run first, and then Execute procedurel will run.
• B.Both activities will be skipped.
• C.Both activities will run simultaneously.
• D.Execute procedure1 will run first, and then Copy_kdi will run.
• E.Copy.kdi will run and Execute procedurel will be skipped.
• F.Execute procedurel will run and Copy_kdi will be skipped.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a warehouse named Warehouse1.
In Warehouse1, you create a table named DimCustomer by running the following statement.

You need to set the Customerkey column as a primary key of the DimCustomer table.
Which three code segments should you run in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *