1What is the primary purpose of the 'Optimize' ribbon introduced in Power BI Desktop?
A.To create custom visual themes and layouts
B.To manage data relationships and cardinality
C.To provide tools for controlling visual refresh and analyzing performance
D.To write complex DAX formulas automatically
Correct Answer: To provide tools for controlling visual refresh and analyzing performance
Explanation:
The Optimize ribbon provides specific features like Pausing Visuals, Optimization Presets, and the Performance Analyzer to help report authors improve report efficiency.
Incorrect! Try again.
2Which button in the Optimize ribbon prevents visuals from updating automatically while you are making changes to the report?
A.Pause Visuals
B.Stop Queries
C.Lock Visuals
D.Freeze Pane
Correct Answer: Pause Visuals
Explanation:
The 'Pause Visuals' button stops visuals from sending DAX queries when you make changes to slicers or filters, allowing you to make multiple adjustments without waiting for renders.
Incorrect! Try again.
3When 'Pause Visuals' is active, what must a user do to see the updated data in a specific visual?
A.There is no way to update a single visual
B.Click the 'Refresh' button on the specific visual overlay
C.Switch to Data view and back
D.Restart Power BI Desktop
Correct Answer: Click the 'Refresh' button on the specific visual overlay
Explanation:
When paused, visuals display a 'Visual is paused' banner. You can click 'Refresh' on that specific visual to update only that one, or 'Refresh visuals' in the ribbon to update all.
Incorrect! Try again.
4Which tool is used to record and analyze the time taken by visual elements to load and render?
A.Performance Analyzer
B.SQL Server Profiler
C.Query Editor
D.DAX Formatter
Correct Answer: Performance Analyzer
Explanation:
Performance Analyzer records the duration of actions in the report, breaking down the time spent on DAX queries, visual display, and other processing.
Incorrect! Try again.
5In the Performance Analyzer results, what does the 'DAX query' metric represent?
A.The time taken to download data from the cloud
B.The time it takes to render the visual on the screen
C.The time waiting for other operations to complete
D.The time required by the analytical engine to execute the query
Correct Answer: The time required by the analytical engine to execute the query
Explanation:
DAX query time is purely the duration the Analysis Services engine takes to process the request and return the data rows.
Incorrect! Try again.
6Which of the following is NOT a category of duration shown in Performance Analyzer?
A.Network latency
B.Visual display
C.DAX query
D.Other
Correct Answer: Network latency
Explanation:
Performance Analyzer breaks durations into 'DAX query', 'Visual display', and 'Other'. While network latency affects DirectQuery, it is not explicitly labeled as a standalone category in the standard breakdown; it usually contributes to DAX or Other depending on the wait.
Incorrect! Try again.
7What feature in the Optimize ribbon allows you to quickly apply pre-configured settings for 'Query reduction' or 'Interactivity'?
A.Performance Tuner
B.Optimization Presets
C.Theme Gallery
D.Quick Measures
Correct Answer: Optimization Presets
Explanation:
Optimization Presets allow authors to toggle between settings that favor instant interactivity or query reduction (which adds Apply buttons to slicers) with a single click.
Incorrect! Try again.
8If you select the 'Query reduction' setting within Optimization Presets, what change is commonly applied to slicers?
A.Slicers automatically select all values
B.Slicers become invisible
C.An 'Apply' button is added to slicers
D.Slicers are converted to dropdowns
Correct Answer: An 'Apply' button is added to slicers
Explanation:
Query reduction adds 'Apply' buttons to slicers so that the report does not attempt to refresh visuals until the user explicitly confirms their selection.
Incorrect! Try again.
9In Performance Analyzer, what does the 'Copy query' function allow you to do?
A.Copy the resulting data table to Excel
B.Copy the SQL or DAX generated by the visual to the clipboard
C.Copy the visual formatting settings
D.Duplicate the visual on the canvas
Correct Answer: Copy the SQL or DAX generated by the visual to the clipboard
Explanation:
This allows you to take the underlying query generated by Power BI and analyze it further in external tools like DAX Studio or SQL Management Studio.
Incorrect! Try again.
10What is the meaning of the 'Visual display' duration in Performance Analyzer?
A.Time spent calculating DAX measures
B.Time required to render the visual elements (charts, graphs) on the screen
C.Time spent waiting for other visuals to load
D.Time taken to retrieve data from the source
Correct Answer: Time required to render the visual elements (charts, graphs) on the screen
Explanation:
Visual display is the client-side processing time required to draw the visual after the data has been received.
Incorrect! Try again.
11Under the 'Other' category in Performance Analyzer, what is a common cause for a high duration?
A.Complex DAX calculations
B.Waiting for other visuals to finish refreshing (queueing)
C.Rendering complex maps
D.Applying conditional formatting
Correct Answer: Waiting for other visuals to finish refreshing (queueing)
Explanation:
'Other' often indicates waiting time caused by the limit on the number of concurrent queries Power BI can execute.
Incorrect! Try again.
12When using the Optimize ribbon, how can you force all visuals to reload data from the cache or source?
A.Close and Reopen the file
B.Click 'Optimization Presets'
C.Click 'Refresh Visuals'
D.Click 'Pause Visuals'
Correct Answer: Click 'Refresh Visuals'
Explanation:
The 'Refresh Visuals' button in the Optimize ribbon initiates a refresh of the visuals on the current page.
Incorrect! Try again.
13Which storage mode generally benefits most from 'Query Reduction' settings?
A.Dual Mode
B.Import Mode
C.Live Connection
D.DirectQuery
Correct Answer: DirectQuery
Explanation:
DirectQuery sources send queries to the database for every interaction. Query Reduction prevents unnecessary intermediate queries, significantly improving performance on slow sources.
Incorrect! Try again.
14What happens to cross-highlighting when 'Query reduction' presets are applied?
A.It changes color
B.It becomes faster
C.It is usually disabled by default
D.It forces a data refresh
Correct Answer: It is usually disabled by default
Explanation:
To reduce the number of queries sent, strict query reduction presets often disable default cross-highlighting/filtering interactions between visuals.
Incorrect! Try again.
15To use Performance Analyzer, what must you do first after opening the pane?
A.Export to Excel
B.Click 'Start recording'
C.Write a DAX measure
D.Select a visual
Correct Answer: Click 'Start recording'
Explanation:
The tool does not capture performance metrics until you explicitly click 'Start recording' and then interact with the report.
Incorrect! Try again.
16Which external tool is most commonly paired with Performance Analyzer to fine-tune DAX queries?
A.DAX Studio
B.Excel
C.Power Automate
D.Notepad
Correct Answer: DAX Studio
Explanation:
Users often copy the query from Performance Analyzer and paste it into DAX Studio to view the execution plan and server timings in detail.
Incorrect! Try again.
17What file format does Performance Analyzer export its results to?
A..XML
B..JSON
C..PBIX
D..CSV
Correct Answer: .JSON
Explanation:
Performance Analyzer exports the recorded session data as a JSON file.
Incorrect! Try again.
18In the context of the Optimize ribbon, what does 'Customizing' presets allow?
A.Manually adjusting settings for slicers and filters distinct from the default presets
B.Changing the color of the ribbon
C.Changing the report background
D.Creating new DAX functions
Correct Answer: Manually adjusting settings for slicers and filters distinct from the default presets
Explanation:
You can customize the specific behavior (e.g., adding Apply buttons to filters but not slicers) via Options -> Query Reduction, effectively customizing the preset.
Incorrect! Try again.
19Which visual type typically consumes the most 'Visual display' time?
A.Card visual
B.Maps or Scatter charts with thousands of data points
C.Simple Bar chart
D.Slicer
Correct Answer: Maps or Scatter charts with thousands of data points
Explanation:
Visuals that require rendering a high number of individual data points or complex geospatial data take longer to render on the client side.
Incorrect! Try again.
20When 'Pause Visuals' is enabled, what happens to the Filter Pane?
A.Changes are pending until the visual is unpaused or refreshed
B.Changes are applied immediately
C.It disappears
D.It works normally
Correct Answer: Changes are pending until the visual is unpaused or refreshed
Explanation:
Similar to slicers, changes made in the Filter Pane will not trigger a query execution until the visuals are refreshed/unpaused.
Incorrect! Try again.
21Why might a DAX query duration be 0 ms or extremely low in Performance Analyzer?
A.The query failed
B.DAX is not used in Power BI
C.The visual is broken
D.The data is being retrieved from the visual cache (already loaded)
Correct Answer: The data is being retrieved from the visual cache (already loaded)
Explanation:
If Power BI has already calculated the result for a visual and it hasn't changed, it serves the data from the cache, resulting in near-instant DAX time.
Incorrect! Try again.
22How can you clear the cache to get an accurate cold-cache reading in Performance Analyzer without restarting?
A.Toggle the visual type
B.There is a 'Clear Cache' button directly in the Optimize ribbon
C.Delete the page
D.Use the 'Clear Cache' feature in DAX Studio or add a blank page then return
Correct Answer: Use the 'Clear Cache' feature in DAX Studio or add a blank page then return
Explanation:
While 'Refresh Visuals' reloads data, a true engine cache clear usually requires an external tool like DAX Studio connecting to the model.
Incorrect! Try again.
23Which of the following is a symptom of a report needing optimization?
A.The report has more than 2 pages
B.Visuals take several seconds to load after clicking a slicer
C.The report uses custom colors
D.The report uses a Star Schema
Correct Answer: Visuals take several seconds to load after clicking a slicer
Explanation:
Long load times (latency) during interactivity are the primary indicator that performance optimization is required.
Incorrect! Try again.
24The 'Optimize' ribbon was introduced to help report creators working specifically with which type of data models?
A.Small Excel files
B.Large models and DirectQuery sources
C.Static CSVs
D.SharePoint lists
Correct Answer: Large models and DirectQuery sources
Explanation:
While useful for all, the tools address pain points specifically associated with large datasets and DirectQuery, where query latency is a major issue.
Incorrect! Try again.
25Can Performance Analyzer record actions across multiple report pages?
A.Only in Power BI Service
B.Only if the pages are duplicated
C.No, it stops when you switch pages
D.Yes, it continues recording until you press Stop
Correct Answer: Yes, it continues recording until you press Stop
Explanation:
Performance Analyzer persists the recording session as you navigate through different pages, allowing you to test page transition performance.
Incorrect! Try again.
26What is the 'Apply' button on the Filter pane used for in Optimization settings?
A.To apply filter changes in bulk rather than individually
B.To apply formatting changes
C.To save the report
D.To apply the filter to all pages
Correct Answer: To apply filter changes in bulk rather than individually
Explanation:
This allows a user to select multiple criteria in the filter pane (e.g., Year, Region, Category) and send only one query to update the report, rather than one query per selection.
Incorrect! Try again.
27Which element allows you to sort Performance Analyzer results by 'Total duration' or 'Action order'?
A.The Optimize ribbon settings
B.The View tab
C.You cannot sort the results
D.The sort icons in the header of the Performance Analyzer pane
Correct Answer: The sort icons in the header of the Performance Analyzer pane
Explanation:
The pane includes options to sort the recorded events either by the sequence in which they occurred or by which took the longest.
Incorrect! Try again.
28If a visual displays a 'Loading...' spinner for a long time, which Performance Analyzer metric will likely be highest?
A.DAX query
B.Evaluation
C.Visual display
D.Copy duration
Correct Answer: DAX query
Explanation:
The spinner usually indicates the visual is waiting for data from the engine, meaning the DAX query is still executing.
Incorrect! Try again.
29Using the 'Optimize' ribbon, where can you find the option to 'Add an Apply button to all slicers'?
This specific configuration is part of the Query Reduction presets.
Incorrect! Try again.
30Does the 'Pause Visuals' feature stop the data refresh from the underlying data source (e.g., scheduled refresh)?
A.Yes, but only for SQL sources
B.No, it deletes the data source
C.No, it only stops the visual rendering on the canvas
D.Yes, it stops all data movement
Correct Answer: No, it only stops the visual rendering on the canvas
Explanation:
Pause Visuals is a UI/Canvas feature. It does not stop the actual dataset from refreshing data from the source; it stops the report visuals from querying that dataset.
Incorrect! Try again.
31What is the benefit of disabling 'Cross-highlighting' in optimization presets?
A.It makes the report more colorful
B.It reduces the number of queries generated when selecting elements in a chart
C.It enables drill-through
D.It increases the file size
Correct Answer: It reduces the number of queries generated when selecting elements in a chart
Explanation:
Every time you click a bar in a bar chart, it queries every other visual on the page to filter them. Disabling this reduces query load.
Incorrect! Try again.
32If 'Other' duration is high in Performance Analyzer, what is a potential fix?
A.Rewrite the DAX measure
B.Reduce the number of visuals on the page
C.Change the chart color
D.Increase font size
Correct Answer: Reduce the number of visuals on the page
Explanation:
Since 'Other' often implies waiting for query slots, reducing the number of visuals reduces the queue, allowing remaining visuals to load simultaneously.
Incorrect! Try again.
33Which visual interaction setting sends the most queries by default?
A.Static Mode
B.Query Reduction
C.Full Interactivity (default)
D.Fixed Layout
Correct Answer: Full Interactivity (default)
Explanation:
Full interactivity means every click on a slicer or visual immediately triggers queries for all other supported visuals.
Incorrect! Try again.
34What indicates that a visual is currently 'Paused'?
A.The visual turns black
B.The visual shows old data with no warning
C.The visual disappears
D.An overlay message says 'Visual is paused'
Correct Answer: An overlay message says 'Visual is paused'
Explanation:
Power BI makes it explicit by greying out the visual slightly and showing a text overlay.
Incorrect! Try again.
35In the Performance Analyzer, can you see the performance of Custom Visuals?
A.Yes, they appear like any other visual
B.No, custom visuals are ignored
C.Yes, but only the DAX portion
D.No, only native visuals
Correct Answer: Yes, they appear like any other visual
Explanation:
Performance Analyzer tracks custom visuals as well, often revealing if a specific custom visual is the cause of poor rendering performance.
Incorrect! Try again.
36What is the result of clicking 'Refresh visuals' in the Optimize ribbon while 'Pause visuals' is still active?
A.It automatically turns off 'Pause visuals' permanently
B.Nothing happens
C.It produces an error
D.The visuals refresh once, then return to the paused state
Correct Answer: The visuals refresh once, then return to the paused state
Explanation:
This allows for a 'one-off' update to check your work while keeping the pause mode active for further editing.
Incorrect! Try again.
37Which of the following is NOT a column in the exported JSON file from Performance Analyzer?
A.programmerName
B.duration
C.action
D.visualType
Correct Answer: programmerName
Explanation:
The export contains technical metrics (start time, end time, duration, query text), not metadata about who wrote the code.
Incorrect! Try again.
38When optimizing a report, what is the recommended approach for row-level security (RLS)?
A.Test performance with RLS roles applied as it can impact query generation
B.Disable RLS for all users
C.Use RLS only on text columns
D.RLS has no impact on performance
Correct Answer: Test performance with RLS roles applied as it can impact query generation
Explanation:
RLS adds complexity to the DAX queries generated (adding WHERE clauses). Performance should be tested as a user within a role.
Incorrect! Try again.
39If you want to permanently keep 'Apply' buttons on slicers for a specific report, where should you configure this if not using the Optimize ribbon presets?
A.View > Themes
B.Modeling > Manage Roles
C.Home > Transform Data
D.File > Options and settings > Options > Current File > Query reduction
Correct Answer: File > Options and settings > Options > Current File > Query reduction
Explanation:
This is the backend location for the settings that the Optimization Presets toggle.
Incorrect! Try again.
40How does 'Pause Visuals' help when creating a new DAX measure?
A.It writes the code for you
B.It prevents visuals from throwing errors or recalculating while the measure is incomplete or being typed
C.It increases the DAX formula bar size
D.It highlights syntax errors
Correct Answer: It prevents visuals from throwing errors or recalculating while the measure is incomplete or being typed
Explanation:
It prevents the 'Waiting for...' cycle every time you press Enter or commit a change to a measure that is used on the canvas.
Incorrect! Try again.
41Which of these is a best practice for optimizing data models before using the Optimize ribbon tools?
A.Use Calculated Columns instead of Measures
B.Keep all relationships bi-directional
C.Import all columns from the source
D.Use a Star Schema and remove unnecessary columns
Correct Answer: Use a Star Schema and remove unnecessary columns
Explanation:
Tools like Performance Analyzer diagnose problems, but a good Star Schema prevents them. Removing unused columns reduces model size and improves engine scan speeds.
Incorrect! Try again.
42In Performance Analyzer, if 'Copy query' is greyed out (unavailable) for a specific item, what does it likely mean?
A.You are not an admin
B.The visual generated no DAX query (e.g., a text box or image)
C.The visual is paused
D.The visual is too slow
Correct Answer: The visual generated no DAX query (e.g., a text box or image)
Explanation:
Static elements like shapes, images, or text boxes do not query the data model, so there is no DAX to copy.
Incorrect! Try again.
43What is the primary trade-off when using Optimization Presets set to 'Query Reduction'?
A.Better graphics at the cost of data accuracy
B.Faster refresh at the cost of security
C.Better performance at the cost of one-click interactivity
D.There is no trade-off
Correct Answer: Better performance at the cost of one-click interactivity
Explanation:
Users have to click 'Apply' to see results, which adds friction to the user experience but ensures the report remains usable on slow connections.
Incorrect! Try again.
44Can Performance Analyzer identify bottlenecks caused by Power Query transformations?
A.Yes, but only for Excel sources
B.Yes, under the 'ETL' category
C.No, it only analyzes the front-end report performance (DAX and Rendering)
D.Yes, directly
Correct Answer: No, it only analyzes the front-end report performance (DAX and Rendering)
Explanation:
Performance Analyzer looks at report query performance. Power Query load times are handled during dataset refresh, which is not measured by this tool.
Incorrect! Try again.
45If a slicer allows 'Multi-select' with an Apply button enabled, when is the query sent?
A.Randomly
B.After every single checkbox click
C.Only when the user clicks 'Apply' after making all selections
D.When the user hovers over the slicer
Correct Answer: Only when the user clicks 'Apply' after making all selections
Explanation:
This is the main benefit; a user can select 5 distinct items and send 1 query, rather than 5 sequential queries.
Incorrect! Try again.
46The Optimize ribbon is available in which version of Power BI?
A.Power BI Mobile only
B.Power BI Report Builder only
C.Power BI Desktop
D.Excel Add-in only
Correct Answer: Power BI Desktop
Explanation:
The Optimize ribbon is a feature of the Power BI Desktop authoring environment.
Incorrect! Try again.
47What does a high 'Evaluation' time in a DAX query (seen in detailed breakdown) usually suggest?
A.Inefficient DAX code or high cardinality scans
B.Slow rendering
C.Slow internet
D.Missing fonts
Correct Answer: Inefficient DAX code or high cardinality scans
Explanation:
This indicates the formula engine or storage engine is working hard to crunch the numbers.
Incorrect! Try again.
48How does limiting the number of visuals on a page help optimization?
A.It saves ink when printing
B.It reduces the number of concurrent queries the engine must process
C.It allows more colors to be used
D.It automatically fixes DAX errors
Correct Answer: It reduces the number of concurrent queries the engine must process
Explanation:
Power BI has a limit on parallel query execution. Fewer visuals mean fewer queries and less waiting in the 'Other' queue.
Incorrect! Try again.
49Can you use Performance Analyzer to compare the speed of two different visuals displaying the same data?
A.Only if they are custom visuals
B.No, it only works on bar charts
C.No, it only records the whole page
D.Yes, by recording them side-by-side or sequentially
Correct Answer: Yes, by recording them side-by-side or sequentially
Explanation:
This is a common use case: A/B testing a matrix vs. a table, or a custom visual vs. a native visual to see which renders faster.
Incorrect! Try again.
50If you wish to return to the default behavior after using 'Optimization Presets', which option should you choose?
A.Disable Optimization
B.Pause Visuals
C.Full Interactivity
D.Query Reduction
Correct Answer: Full Interactivity
Explanation:
Full Interactivity is the default state where slicers and cross-filtering trigger updates immediately.
Incorrect! Try again.
Did this save you a night before the exam?
LPU Notes is free, and it stays free. Ads cover part of the server bill.
The rest comes out of a student's own pocket: the domain, the storage,
and keeping the site up through the weeks everyone needs it at once.
The payment button didn't load. An ad blocker or a filtered network is the usual reason.
to try again.
Nothing here is ever locked, and nothing unlocks. Chip in only if it was worth it.
What it pays for →