DP-600 · Question #26
DP-600 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
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.
Options
- AUse the Analyze in Excel feature.
- BUse the Vertipaq Analyzer tool.
- CQuery the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic
- DQuery the DISCOVER_MEMORYGRANT dynamic management view (DMV).
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.