Answer-first summary for fast verification
Answer: Use the Vertipaq Analyzer tool., Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV).
B. The Vertipaq Analyzer tool is specifically designed to analyze and optimize data models in Power BI and Analysis Services, helping you identify frequently used columns that are loaded into memory. C. Querying the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV) directly provides information on storage details at the column segment level, which helps identify frequently used columns that are loaded into memory. Options A and D are not suitable for identifying frequently used columns in memory. Analyze in Excel (A) is meant more for data exploration and visualization, while the DISCOVER_MEMORYGRANT DMV (D) provides information about memory grants for queries, not specific columns.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
In your role as a Fabric Analytics Engineer, you are managing a Fabric tenant that includes a semantic model configured to utilize Direct Lake mode. You have concerns that some DAX (Data Analysis Expressions) queries might be inefficiently loading unnecessary columns into memory. To optimize performance, you need to pinpoint the columns that are frequently loaded into memory. What are two methods you can use to accomplish this? Each correct answer will provide a complete solution. NOTE: Each correct answer is worth one point.
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).