This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
An analytics team builds a new semantic model in Microsoft Fabric with all data stored in a lakehouse. Which storage mode should they choose as the default for this model?
Import mode, because it provides the fastest query performance.
Direct Lake mode, because it reads Delta tables directly from OneLake without importing data.
DirectQuery mode, because it queries the source in real time.
A company has 60 base measures in a semantic model and needs Year-to-Date, Quarter-to-Date, and Month-to-Date versions of each. What should a model designer implement to avoid creating 180 additional measures?
A calculation group with time intelligence calculation items that use SELECTEDMEASURE().
DAX variables to store intermediate results and reduce repeated calculations.
Aggregations with pre-summarized tables at the monthly, quarterly, and yearly grain.
A model designer needs to use Tabular Editor for external model development and deploy through CI/CD pipelines. Which setting is a prerequisite for XMLA endpoint read/write access?
Large semantic model storage format.
OneLake integration.
Query scaleout.
A model designer enables the Assume referential integrity setting on a relationship between a fact table and a dimension table in a Direct Lake model. What is the performance benefit of this setting?
The engine uses INNER joins instead of LEFT OUTER joins, which reduces the number of rows processed.
The engine caches relationship metadata so that subsequent queries skip relationship evaluation.
The engine creates an index on the foreign key column to speed up relationship lookups.
A semantic model has a fact table with 150 million rows. Report users primarily view monthly and quarterly summaries by region. Which design pattern improves query performance for these summary-level visuals?
Aggregation tables that store precalculated totals at the monthly and quarterly grain.
Calculation groups with time intelligence calculation items.
Bi-directional filtering between the fact and dimension tables.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?