Implement and manage semantic models Questions
Practice questions for Implement and manage semantic models topic in Microsoft Certified: Fabric Analytics Engineer Associate. 56 questions covering this domain.
You are configuring incremental refresh in Power BI Desktop. Which setup is required before you can define the policy?
What kind of measures do calculation groups apply to in Power BI semantic models?
Which storage mode retrieves data from the source system when visuals load instead of storing table data in the semantic model?
You want report readers to switch between fields in a visual by using field parameters. What must you create if one of the choices is an aggregated nu...
A modeler wants one semantic model that directly mixes Direct Lake on SQL endpoint tables with new DirectQuery tables. What is the supported guidance?
A report author builds a composite model that includes a remote semantic model and local tables, then defines RLS on the local tables. What should the...
A semantic model owner wants incremental refresh plus a real-time DirectQuery partition. Which licensing statement is correct?
A Direct Lake semantic model is built on a warehouse SQL endpoint, and one table is based on a SQL view. What should you expect if fallback is enabled...
A BI team has already chained three semantic models together by using DirectQuery on Power BI semantic models. What happens if they try to extend the ...
A composite model relates a local imported table to a remote DirectQuery table from another source. What is the default behavior of that cross-source ...
In Power BI Desktop, what does selecting Make changes to this model after connecting to a Power BI semantic model do?
A semantic model will stay under the default size limit, but the team plans to manage it with XMLA write operations from external tools. What should t...
A semantic model uses Direct Lake on OneLake tables. Which statement about fallback behavior is correct?
Which Power BI feature lets two report visuals dynamically swap measures or fields based on a slicer choice?
A team enables Q&A on a semantic model. Which model feature most improves natural-language results for synonyms and aliases?
Which DAX function returns the sum of an expression evaluated for each row of a table?
Which DAX time intelligence function returns dates in the same period of the prior year, given a date column?
A modeler wants to hide an entire measure from specific users while keeping it visible to others, using model security. Which feature should they use?
A team applies dynamic RLS that uses USERPRINCIPALNAME() against a Users dimension. Test users see all rows in the Power BI service. Which is the most...
Which DAX function returns a table of distinct values from a column, considering current filter context?
Sign in to see all 56 questions
Create a free account to browse all questions — completely free during our launch phase.