Implementing Data Engineering Solutions Using Microsoft Fabric — Question 53

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?

Answer options

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

Correct answer: D

Explanation

Increasing the capacity (option D) directly addresses the performance issues by providing more resources to handle the larger dataset, thus improving query performance. The other options either do not significantly impact performance or may increase complexity and operational costs without directly addressing the underlying resource limitations.