Practice Exam

Explanations for each answer:

• Change the MD5 hash to SHA256 is incorrect. Changing the hash algorithm from MD5 to SHA256 would increase computational overhead without improving query performance. The hash algorithm choice affects surrogate key generation but doesn't impact Direct Lake query performance or visual errors in Power BI reports.
• Increase the capacity is incorrect. While increasing capacity could temporarily improve performance by providing more compute resources, it doesn't address the root cause and would increase operational costs. The performance degradation is likely caused by the warehouse not having V-Order optimization enabled for Direct Lake queries.
• Enable V-Order is correct. V-Order is a write-time optimization to the parquet file format that enables lightning-fast reads under Microsoft Fabric compute engines including Power BI Direct Lake mode. Direct Lake mode depends on V-Order for optimal performance. Enabling V-Order will provide the best query performance without increasing costs, making it the ideal solution for Direct Lake-based reports showing year-over-year data.
• Modify the surrogate keys to use a different data type is incorrect. Changing the surrogate key data type might reduce storage slightly but won't significantly improve query performance for Direct Lake reports. The MD5 hash produces a unique identifier, and changing the data type doesn't address the underlying optimization issue affecting report performance.
• Create views is incorrect. Creating views would add an additional abstraction layer that could potentially slow down queries rather than improve performance. Views don't provide the file-level optimizations needed for Direct Lake mode to perform efficiently on large fact tables.