Question
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.
- A. Use the Analyze in Excel feature.
- B. Use the Vertipaq Analyzer tool. Correct
- C. Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV). Correct
- D. Query the DISCOVER_MEMORYGRANT dynamic management view (DMV).
Explanation
Direct Lake loads (transcodes) whole columns into memory on demand, and the DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS DMV reports for each column segment whether it is resident and its temperature, which shows how frequently it is used. VertiPaq Analyzer reads the same storage DMVs and presents residency and temperature per column. Analyze in Excel only queries the model, and DISCOVER_MEMORYGRANT reports memory grants for queries, not which columns are loaded.
