DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ48

VerifiedMonitor and optimize an analytics solution

You have a Fabric F32 capacity that includes a workspace. The workspace contains a warehouse named DW1, which is modeled by using MD5-hash surrogate keys.

DW1 has a single fact table that grew from 200 million rows to 500 million rows over the past year.

You have Microsoft Power BI reports based on Direct Lake. The reports display year-over-year values.

Users report that performance for some reports has degraded over time, and some visuals display errors.

You need to resolve the performance issues. The solution must meet these requirements:

  • Provide the best query performance.
  • Minimize operational costs.

Which action should you take?

Explanation

Direct Lake performance and memory efficiency improve when appropriate data types are used; Microsoft recommends integer data types instead of strings where possible. A compact numeric surrogate key reduces the memory and compression overhead of high-cardinality MD5 hash values in a 500-million-row fact table, helping avoid memory pressure while improving VertiPaq query performance without the recurring cost of a larger capacity. SQL views can require DirectQuery fallback for Direct Lake Warehouse sources, and V-Order is important to Direct Lake performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!