Question 1

1. How can you create a user-friendly way to return to an unfiltered state on a Power BI report page?

Accepted Answer

Use a bookmark and assign it to a button.

Answer

Use a filter pane reset option.

Answer

Use a slicer and clear selections manually.

Answer

Use a visual-level filter reset.

Question 2

2. What happens if you apply a filter to one visual and then switch to another visual without clearing the previous filter?

Accepted Answer

It overrides the previous filter.

Answer

It saves the previous filter as a bookmark.

Answer

It applies both filters simultaneously.

Answer

It clears all filters automatically.

Question 3

3. How can you ensure that filters on one visual do not affect another visual in Power BI?

Accepted Answer

Turn off cross-filtering for the specific visual.

Answer

Use a different data model for each visual.

Answer

Use a separate report page for each visual.

Answer

Apply a slicer to clear all filters.

Question 4

4. What is the primary purpose of using bookmarks in Power BI?

Accepted Answer

Capture and return to a specific state of the report.

Answer

Export the report to a PDF.

Answer

Schedule an automatic report refresh.

Answer

Save a copy of the report.

Question 5

5. How do you test the action associated with a button in Power BI Desktop?

Accepted Answer

Control-click the button.

Answer

Alt-click the button.

Answer

Right-click the button.

Answer

Double-click the button.

Question 6

6. When using Power BI Service, what might an administrator need to do for maps to work correctly?

Accepted Answer

Enable maps in tenant settings.

Answer

Provide user access to Bing Maps.

Answer

Configure a separate maps server.

Answer

Install a maps plugin.

Question 7

7. What should you do to make a Power BI visual more intuitive when filtering by multiple fields?

Accepted Answer

Hold Control while applying filters.

Answer

Use a hierarchy to combine fields.

Answer

Use a separate slicer for each field.

Answer

Apply filters one at a time.

Question 8

8. Why is it beneficial to add multiple location fields when creating maps in Power BI?

Accepted Answer

To avoid ambiguity in location data.

Answer

To increase the visual appeal of the map.

Answer

To make the map load faster.

Answer

To ensure data privacy.

Question 9

9. What is the advantage of using latitude and longitude for geospatial data in Power BI?

Accepted Answer

Ensures the most accurate mapping.

Answer

Improves map visualization speed.

Answer

Simplifies the data import process.

Answer

Reduces the size of the data model.

Question 10

10. What is the purpose of using a custom slicer panel in Power BI?

Accepted Answer

To add filters without cluttering the report page.

Answer

To improve the performance of the report.

Answer

To provide filter options for export only.

Answer

To create more complex filter logic.

Question 11

11. What must be done to create a fields parameter in Power BI?

Accepted Answer

Select the desired fields in the parameter creation dialog.

Answer

Use the query editor to combine fields.

Answer

Apply filters to each field individually.

Answer

Manually write DAX code to capture field values.

Question 12

12. How can you dynamically change which metric is shown in a visual using a fields parameter?

Accepted Answer

Add the parameter to the Y-axis of the chart.

Answer

Use a slicer to change the metric.

Answer

Manually update the chart title.

Answer

Apply conditional formatting to the chart.

Question 13

13. What is a key use case for numeric range parameters in Power BI?

Accepted Answer

Scenario testing to see the impact of numerical inputs.

Answer

Adding additional visuals to the report.

Answer

Setting row-level security rules.

Answer

Creating custom tooltips for visuals.

Question 14

14. What should you do if you notice a partial week in your drill down data?

Accepted Answer

Disable drill mode for that visual.

Answer

Remove the weekly level from the hierarchy.

Answer

Adjust the data granularity to daily.

Answer

Apply a filter to exclude partial weeks.

Question 15

15. How can you ensure that row-level security (RLS) is properly applied in Power BI?

Accepted Answer

Assign users to roles in Power BI Service.

Answer

Use bookmarks to simulate RLS.

Answer

Apply visual-level filters for each role.

Answer

Configure roles only in Power BI Desktop.

Question 16

16. Why is it useful to create a custom tooltip page in Power BI?

Accepted Answer

To add more context and information without cluttering the main report.

Answer

To improve the loading speed of visuals.

Answer

To create a backup of the report.

Answer

To export detailed data to Excel.

Question 17

17. What is the benefit of using mobile layouts in Power BI?

Accepted Answer

Optimizes the report for viewing on mobile devices.

Answer

Increases the loading speed of the report.

Answer

Reduces the complexity of the data model.

Answer

Simplifies the report design process.

Question 18

18. How do you publish a Power BI report to the cloud?

Accepted Answer

Click the Publish button in the home menu.

Answer

Use the Share option in the file menu.

Answer

Export the report to a PDF.

Answer

Save the report in OneDrive.

Question 19

19. How can you use custom visuals in Power BI?

Accepted Answer

Import visuals from AppSource.

Answer

Apply conditional formatting to existing visuals.

Answer

Manually code the visuals using DAX.

Answer

Use only the default visual templates.

Question 20

20. What is the advantage of using drillthrough in Power BI?

Accepted Answer

Allows users to navigate to specific report pages filtered on selected data.

Answer

Simplifies the creation of data models.

Answer

Enables the export of data to Excel.

Answer

Increases the speed of data loading.

Related quizzes

Related quizzes