1What is the primary purpose of the 'Optimize' ribbon introduced in Power BI Desktop?
A.To manage data relationships and cardinality
B.To provide tools for controlling visual refresh and analyzing performance
C.To write complex DAX formulas automatically
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.Pause Visuals
B.Lock Visuals
C.Stop Queries
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.Restart Power BI Desktop
B.Click the 'Refresh' button on the specific visual overlay
C.There is no way to update a single visual
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.Performance Analyzer
B.SQL Server Profiler
C.DAX Formatter
D.Query Editor
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 it takes to render the visual on the screen
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 waiting for other operations to complete
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.DAX query
B.Visual display
C.Network latency
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.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 automatically select all values
B.Slicers are converted to dropdowns
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.Copy the visual formatting settings
B.Copy the resulting data table to Excel
C.Duplicate the visual on the canvas
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 taken to retrieve data from the source
B.Time spent waiting for other visuals to load
C.Time required to render the visual elements (charts, graphs) on the screen
D.Time spent calculating DAX measures
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.Rendering complex maps
C.Waiting for other visuals to finish refreshing (queueing)
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.Click 'Optimization Presets'
B.Close and Reopen the file
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.Import Mode
B.Live Connection
C.DirectQuery
D.Dual Mode
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 is usually disabled by default
B.It changes color
C.It forces a data refresh
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.Export to Excel
B.Write a DAX measure
C.Select a visual
D.Click 'Start recording'
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.Power Automate
B.Excel
C.Notepad
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..XML
B..PBIX
C..JSON
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.Creating new DAX functions
C.Changing the report background
D.Changing the color of the ribbon
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.Slicer
B.Maps or Scatter charts with thousands of data points
C.Card visual
D.Simple Bar chart
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.It disappears
B.It works normally
C.Changes are pending until the visual is unpaused or refreshed
D.Changes are applied immediately
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 data is being retrieved from the visual cache (already loaded)
B.The visual is broken
C.The query failed
D.DAX is not used in Power BI
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.Use the 'Clear Cache' feature in DAX Studio or add a blank page then return
C.Delete the page
D.There is a 'Clear Cache' button directly in the Optimize ribbon
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 uses a Star Schema
B.Visuals take several seconds to load after clicking a slicer
C.The report has more than 2 pages
D.The report uses custom colors
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.SharePoint lists
C.Large models and DirectQuery sources
D.Small Excel files
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.No, it stops when you switch pages
C.Only if the pages are duplicated
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 formatting changes
B.To apply the filter to all pages
C.To apply filter changes in bulk rather than individually
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 View tab
B.You cannot sort the results
C.The sort icons in the header of the Performance Analyzer pane
D.The Optimize ribbon settings
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.Visual display
B.Evaluation
C.DAX query
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, it stops all data movement
B.Yes, but only for SQL sources
C.No, it only stops the visual rendering on the canvas
D.No, it deletes the data source
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 reduces the number of queries generated when selecting elements in a chart
B.It makes the report more colorful
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.Reduce the number of visuals on the page
B.Increase font size
C.Change the chart color
D.Rewrite the DAX measure
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.Query Reduction
C.Fixed Layout
D.Static Mode
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.Yes, but only the DAX portion
C.No, only native visuals
D.No, custom visuals are ignored
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.Nothing happens
B.The visuals refresh once, then return to the paused state
C.It automatically turns off 'Pause visuals' permanently
D.It produces an error
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.visualType
B.programmerName
C.action
D.duration
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.Disable RLS for all users
B.RLS has no impact on performance
C.Use RLS only on text columns
D.Test performance with RLS roles applied as it can impact query generation
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.File > Options and settings > Options > Current File > Query reduction
C.Home > Transform Data
D.Modeling > Manage Roles
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 increases the DAX formula bar size
C.It writes the code for you
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.Use Calculated Columns instead of Measures
B.Use a Star Schema and remove unnecessary columns
C.Keep all relationships bi-directional
D.Import all columns from the source
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 is too slow
B.The visual generated no DAX query (e.g., a text box or image)
C.You are not an admin
D.The visual is paused
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.Faster refresh at the cost of security
B.Better performance at the cost of one-click interactivity
C.Better graphics at the cost of data accuracy
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, under the 'ETL' category
B.Yes, directly
C.No, it only analyzes the front-end report performance (DAX and Rendering)
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.When the user hovers over the slicer
C.Only when the user clicks 'Apply' after making all selections
D.Randomly
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 Report Builder only
B.Power BI Desktop
C.Excel Add-in only
D.Power BI Mobile 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.Missing fonts
B.Inefficient DAX code or high cardinality scans
C.Slow rendering
D.Slow internet
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 allows more colors to be used
B.It automatically fixes DAX errors
C.It saves ink when printing
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.No, it only records the whole page
B.Yes, by recording them side-by-side or sequentially
C.Only if they are custom visuals
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.Disable Optimization
B.Pause Visuals
C.Query Reduction
D.Full Interactivity
Correct Answer: Full Interactivity
Explanation:
Full Interactivity is the default state where slicers and cross-filtering trigger updates immediately.