Optimize enterprise-scale semantic models
10 practice questions under this official exam objective (DP-600) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Replacing FILTER with KEEPFILTERS in Power BI
Replacing the FILTER function with KEEPFILTERS in DAX measures improves performance when filtering a single column in an Import mode table. This page
What Implements Calculation Groups for Direct Lake Semantic Models?
Contoso's Research division semantic models must run in Direct Lake mode, so calculation groups must be authored with an XMLA modeling tool rather tha
How to Reduce Fabric Semantic Model Memory and Refresh Time?
This DP-600 question tests how to reduce memory usage and refresh time for a 100-million-row Import mode Fabric semantic model. The page confirms the
How to find frequently used columns loaded into memory in Direct Lake?
In a Fabric Direct Lake semantic model, Vertipaq Analyzer and the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS DMV both reveal which columns are fre
How to Enable Scale-Out for a Semantic Model
To enable scale-out for a semantic model in Power BI Premium, you must first configure the large dataset storage format. This page confirms that setti
Does Replacing > 0 with >= 0 Optimize DAX Query Performance?
Replacing a greater-than-zero condition with greater-than-or-equal-to-zero in a DAX CALCULATE function alters the query logic but does not improve exe
How to Identify Fabric Warehouse Throttling
When Microsoft Fabric warehouse query performance degrades due to suspected compute throttling, administrators must use the correct monitoring tool to
Identify Surrogate Key Summarization in Power BI
Identifying surrogate key columns with incorrect Summarize By properties in a Power BI semantic model requires an automated scanning tool to minimize
Optimize XMLA Endpoint Semantic Model Deployment
Deploying a semantic model via the XMLA endpoint requires the Large semantic model storage format to optimize write operations and minimize deployment
DAX Performance Optimization with NOT and COUNTROWS
Replacing a DAX condition with a logically equivalent expression using NOT and COUNTROWS does not improve query performance. This page confirms that l