1What is the primary purpose of the 'Optimize' ribbon introduced in Power BI Desktop?
A.To write complex DAX formulas automatically
B.To manage data relationships and cardinality
C.To provide tools for controlling visual refresh and analyzing performance
D.To create custom visual themes and layouts
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.Freeze Pane
B.Lock Visuals
C.Stop Queries
D.Pause Visuals
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.Restart Power BI Desktop
C.Click the 'Refresh' button on the specific visual overlay
D.Switch to Data view and back
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.SQL Server Profiler
B.DAX Formatter
C.Query Editor
D.Performance Analyzer
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 waiting for other operations to complete
B.The time taken to download data from the cloud
C.The time required by the analytical engine to execute the query
D.The time it takes to render the visual on the screen
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.DAX query
C.Other
D.Visual display
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.Optimization Presets
B.Performance Tuner
C.Quick Measures
D.Theme Gallery
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 are converted to dropdowns
B.Slicers automatically select all values
C.Slicers become invisible
D.An 'Apply' button is added to slicers
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.Duplicate the visual on the canvas
B.Copy the resulting data table to Excel
C.Copy the visual formatting settings
D.Copy the SQL or DAX generated by the visual to the clipboard
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 required to render the visual elements (charts, graphs) on the screen
B.Time spent calculating DAX measures
C.Time taken to retrieve data from the source
D.Time spent waiting for other visuals to load
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.Applying conditional formatting
B.Waiting for other visuals to finish refreshing (queueing)
C.Rendering complex maps
D.Complex DAX calculations
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.Click 'Refresh Visuals'
B.Click 'Pause Visuals'
C.Close and Reopen the file
D.Click 'Optimization Presets'
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.Import Mode
B.Live Connection
C.Dual Mode
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 forces a data refresh
B.It changes color
C.It is usually disabled by default
D.It becomes faster
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.Click 'Start recording'
B.Select a visual
C.Write a DAX measure
D.Export to Excel
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.Notepad
B.Excel
C.Power Automate
D.DAX Studio
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..CSV
B..XML
C..JSON
D..PBIX
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.Changing the report background
B.Changing the color of the ribbon
C.Creating new DAX functions
D.Manually adjusting settings for slicers and filters distinct from the default presets
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.Maps or Scatter charts with thousands of data points
B.Simple Bar chart
C.Slicer
D.Card visual
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.It works normally
C.Changes are applied immediately
D.It disappears
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 data is being retrieved from the visual cache (already loaded)
D.The visual is broken
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.Use the 'Clear Cache' feature in DAX Studio or add a blank page then return
B.Toggle the visual type
C.There is a 'Clear Cache' button directly in the Optimize ribbon
D.Delete the page
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.Static CSVs
B.Small Excel files
C.Large models and DirectQuery sources
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 if the pages are duplicated
B.Yes, it continues recording until you press Stop
C.Only in Power BI Service
D.No, it stops when you switch pages
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 formatting changes
B.To apply filter changes in bulk rather than individually
C.To apply the filter to all pages
D.To save the report
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.You cannot sort the results
C.The View tab
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.Copy duration
C.Evaluation
D.Visual display
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 only stops the visual rendering on the canvas
C.No, it deletes the data source
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 increases the file size
B.It makes the report more colorful
C.It reduces the number of queries generated when selecting elements in a chart
D.It enables drill-through
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.Change the chart color
B.Reduce the number of visuals on the page
C.Rewrite the DAX measure
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.Full Interactivity (default)
B.Fixed Layout
C.Static Mode
D.Query Reduction
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.An overlay message says 'Visual is paused'
B.The visual shows old data with no warning
C.The visual disappears
D.The visual turns black
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.It produces an error
C.The visuals refresh once, then return to the paused state
D.Nothing happens
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.duration
B.visualType
C.action
D.programmerName
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.RLS has no impact on performance
C.Disable RLS for all users
D.Use RLS only on text columns
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.Home > Transform Data
C.Modeling > Manage Roles
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 highlights syntax errors
B.It writes the code for you
C.It increases the DAX formula bar size
D.It prevents visuals from throwing errors or recalculating while the measure is incomplete or being typed
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.Import all columns from the source
B.Keep all relationships bi-directional
C.Use Calculated Columns instead of Measures
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.The visual generated no DAX query (e.g., a text box or image)
B.The visual is paused
C.The visual is too slow
D.You are not an admin
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.There is no trade-off
B.Faster refresh at the cost of security
C.Better graphics at the cost of data accuracy
D.Better performance at the cost of one-click interactivity
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.No, it only analyzes the front-end report performance (DAX and Rendering)
B.Yes, directly
C.Yes, under the 'ETL' category
D.Yes, but only for Excel sources
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.After every single checkbox click
B.Only when the user clicks 'Apply' after making all selections
C.Randomly
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.Excel Add-in only
C.Power BI Report Builder only
D.Power BI Desktop
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.Slow rendering
B.Slow internet
C.Missing fonts
D.Inefficient DAX code or high cardinality scans
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 automatically fixes DAX errors
B.It saves ink when printing
C.It allows more colors to be used
D.It reduces the number of concurrent queries the engine must process
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 records the whole page
C.Yes, by recording them side-by-side or sequentially
D.No, it only works on bar charts
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.Pause Visuals
B.Disable Optimization
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 →