1What is the primary purpose of the 'Optimize' ribbon introduced in Power BI Desktop?
A.To write complex DAX formulas automatically
B.To create custom visual themes and layouts
C.To provide tools for controlling visual refresh and analyzing performance
D.To manage data relationships and cardinality
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.Stop Queries
B.Freeze Pane
C.Lock Visuals
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.Switch to Data view and back
C.Click the 'Refresh' button on the specific visual overlay
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.DAX Formatter
C.Query Editor
D.SQL Server Profiler
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.Other
B.Network latency
C.Visual display
D.DAX query
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.Theme Gallery
C.Optimization Presets
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 become invisible
B.Slicers automatically select all values
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.Duplicate the visual on the canvas
B.Copy the visual formatting settings
C.Copy the SQL or DAX generated by the visual to the clipboard
D.Copy the resulting data table to Excel
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 waiting for other visuals to load
B.Time required to render the visual elements (charts, graphs) on the screen
C.Time taken to retrieve data from the source
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.Rendering complex maps
B.Waiting for other visuals to finish refreshing (queueing)
C.Applying conditional formatting
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 'Pause Visuals'
B.Click 'Refresh Visuals'
C.Click 'Optimization Presets'
D.Close and Reopen the file
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.Live Connection
B.DirectQuery
C.Import Mode
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 changes color
B.It is usually disabled by default
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.Write a DAX measure
B.Click 'Start recording'
C.Export to Excel
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..CSV
B..PBIX
C..JSON
D..XML
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.Slicer
B.Simple Bar chart
C.Card visual
D.Maps or Scatter charts with thousands of data points
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 applied immediately
D.Changes are pending until the visual is unpaused or refreshed
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.DAX is not used in Power BI
B.The visual is broken
C.The data is being retrieved from the visual cache (already loaded)
D.The query failed
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.Delete the page
B.Use the 'Clear Cache' feature in DAX Studio or add a blank page then return
C.Toggle the visual type
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 has more than 2 pages
B.The report uses custom colors
C.Visuals take several seconds to load after clicking a slicer
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.SharePoint lists
B.Small Excel files
C.Large models and DirectQuery sources
D.Static CSVs
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 save the report
B.To apply the filter to all pages
C.To apply filter changes in bulk rather than individually
D.To apply formatting changes
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.You cannot sort the results
B.The View tab
C.The Optimize ribbon settings
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.Evaluation
B.Copy duration
C.Visual display
D.DAX query
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.No, it deletes the data source
C.No, it only stops the visual rendering on the canvas
D.Yes, but only for SQL sources
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 reduces the number of queries generated when selecting elements in a chart
C.It enables drill-through
D.It makes the report more colorful
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.Increase font size
C.Rewrite the DAX measure
D.Reduce the number of visuals on the page
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.Static Mode
C.Query Reduction
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 disappears
B.An overlay message says 'Visual is paused'
C.The visual shows old data with no warning
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, but only the DAX portion
B.No, custom visuals are ignored
C.Yes, they appear like any other visual
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.The visuals refresh once, then return to the paused state
B.Nothing happens
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.action
B.visualType
C.duration
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.Disable RLS for all users
B.Use RLS only on text columns
C.RLS has no impact on performance
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.Modeling > Manage Roles
B.Home > Transform Data
C.File > Options and settings > Options > Current File > Query reduction
D.View > Themes
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 prevents visuals from throwing errors or recalculating while the measure is incomplete or being typed
B.It writes the code for you
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.The visual is too slow
B.The visual generated no DAX query (e.g., a text box or image)
C.The visual is paused
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.Better performance at the cost of one-click interactivity
B.There is no trade-off
C.Better graphics at the cost of data accuracy
D.Faster refresh at the cost of security
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, but only for Excel sources
C.Yes, directly
D.No, it only analyzes the front-end report performance (DAX and Rendering)
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.When the user hovers over the slicer
B.Randomly
C.After every single checkbox click
D.Only when the user clicks 'Apply' after making all selections
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.Inefficient DAX code or high cardinality scans
C.Missing fonts
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 saves ink when printing
C.It reduces the number of concurrent queries the engine must process
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.Yes, by recording them side-by-side or sequentially
B.Only if they are custom visuals
C.No, it only works on bar charts
D.No, it only records the whole page
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.Query Reduction
B.Pause Visuals
C.Full Interactivity
D.Disable Optimization
Correct Answer: Full Interactivity
Explanation:
Full Interactivity is the default state where slicers and cross-filtering trigger updates immediately.