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.Freeze Pane
B.Pause Visuals
C.Lock Visuals
D.Stop Queries
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.Switch to Data view and back
D.There is no way to update a single visual
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.Query Editor
B.SQL Server Profiler
C.Performance Analyzer
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 it takes to render the visual on the screen
B.The time taken to download data from the cloud
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.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.An 'Apply' button is added to slicers
B.Slicers become invisible
C.Slicers are converted to dropdowns
D.Slicers automatically select all values
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 visual formatting settings
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 required to render the visual elements (charts, graphs) on the screen
B.Time spent calculating DAX measures
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.Applying conditional formatting
C.Rendering complex maps
D.Waiting for other visuals to finish refreshing (queueing)
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 'Pause Visuals'
C.Click 'Refresh Visuals'
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.Dual 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.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.DAX Studio
B.Notepad
C.Power Automate
D.Excel
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..PBIX
D..JSON
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.Creating new DAX functions
D.Changing the report background
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.Changes are applied immediately
B.Changes are pending until the visual is unpaused or refreshed
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.Use the 'Clear Cache' feature in DAX Studio or add a blank page then return
B.There is a 'Clear Cache' button directly in the Optimize ribbon
C.Delete the page
D.Toggle the visual type
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 a Star Schema
C.The report uses custom colors
D.Visuals take several seconds to load after clicking a slicer
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.Static CSVs
C.SharePoint lists
D.Large models and DirectQuery sources
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.No, it stops when you switch pages
B.Only if the pages are duplicated
C.Only in Power BI Service
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 the filter to all pages
C.To save the report
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.The Optimize ribbon settings
B.The sort icons in the header of the Performance Analyzer pane
C.The View tab
D.You cannot sort the results
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.Yes, but only for SQL sources
D.No, it only stops the visual rendering on the canvas
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 increases the file size
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.Increase font size
B.Reduce the number of visuals on the page
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.Static Mode
C.Fixed Layout
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.The visual disappears
B.The visual turns black
C.An overlay message says 'Visual is paused'
D.The visual shows old data with no warning
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.No, custom visuals are ignored
B.No, only native visuals
C.Yes, they appear like any other visual
D.Yes, but only the DAX portion
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 produces an error
B.Nothing happens
C.The visuals refresh once, then return to the paused state
D.It automatically turns off 'Pause visuals' permanently
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.action
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.Use RLS only on text columns
B.Test performance with RLS roles applied as it can impact query generation
C.RLS has no impact on performance
D.Disable RLS for all users
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.View > Themes
C.File > Options and settings > Options > Current File > Query reduction
D.Home > Transform Data
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.Import all columns from the source
B.Keep all relationships bi-directional
C.Use a Star Schema and remove unnecessary columns
D.Use Calculated Columns instead of Measures
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.Better performance at the cost of one-click interactivity
B.Better graphics at the cost of data accuracy
C.Faster refresh at the cost of security
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.No, it only analyzes the front-end report performance (DAX and Rendering)
C.Yes, under the 'ETL' category
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.Only when the user clicks 'Apply' after making all selections
B.Randomly
C.When the user hovers over the slicer
D.After every single checkbox click
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 Desktop
C.Power BI Report Builder only
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.Missing fonts
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 saves ink when printing
B.It allows more colors to be used
C.It automatically fixes DAX errors
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.No, it only works on bar charts
C.Yes, by recording them side-by-side or sequentially
D.Only if they are custom visuals
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.Full Interactivity
B.Disable Optimization
C.Query Reduction
D.Pause Visuals
Correct Answer: Full Interactivity
Explanation:
Full Interactivity is the default state where slicers and cross-filtering trigger updates immediately.