Implementing Analytics Solutions Using Microsoft Fabric — Question 33

You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode.
You suspect that some DAX queries load unnecessary columns into memory.
You need to identify the frequently used columns that are loaded into memory.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.

Answer options

• A. Use the Analyze in Excel feature.
• B. Use the Vertipaq Analyzer tool.
• C. Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV).
• D. Query the DISCOVER_MEMORYGRANT dynamic management view (DMV).

Correct answer: B, C

Explanation

The Vertipaq Analyzer tool (B) provides insights into the memory usage of columns, making it ideal for identifying unnecessary loads. Querying the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS DMV (C) grants access to column segment information, allowing for analysis of loaded columns. The other options either do not specifically target memory usage analysis or provide less relevant information.