pbPassingBI
/
power bi/quizzes/power-bi-quiz-report
12 questions

Visualisation & sharing — quiz

12 questions covering this module. Visuals, drill-through, bookmarks, publishing and security.

  1. You want a summary visual to send users to a detail page carrying the selected product. Use:

    1. Bookmark
    2. Drillthrough
    3. Drill down
    4. Sync slicer

    Answer: Drillthrough — Drillthrough passes the selected context to a dedicated detail page.

  2. Which controls whether clicking one visual filters another?

    1. Sync slicers
    2. Edit interactions
    3. Bookmarks
    4. Page filters

    Answer: Edit interactions — Edit interactions sets each target visual to filter, highlight, or none.

  3. A developer needs to edit reports but not manage app access. Which role?

    1. Admin
    2. Member
    3. Contributor
    4. Viewer

    Answer: Contributor — Contributor can create and edit content without publishing the app or managing permissions.

  4. Which source requires an on-premises gateway?

    1. Azure SQL Database
    2. SharePoint Online
    3. On-premises SQL Server
    4. A dataflow

    Answer: On-premises SQL Server — Gateways bridge the Service to sources that are not publicly reachable.

  5. Which function should dynamic RLS use to identify the viewer?

    1. USERNAME()
    2. USERPRINCIPALNAME()
    3. CUSTOMDATA()
    4. LOOKUPVALUE()

    Answer: USERPRINCIPALNAME() — USERPRINCIPALNAME returns the UPN consistently in both Desktop and the Service.

  6. Why might RLS appear not to work when you test it?

    1. DAX is wrong by definition
    2. You are a workspace Admin or Member, who bypass RLS
    3. RLS needs Premium
    4. Roles only work on import mode

    Answer: You are a workspace Admin or Member, who bypass RLS — Admins and Members bypass RLS on datasets they can edit; test as a Viewer or use Test as role.

  7. Which certification is the current Power BI analyst exam?

    1. DA-100
    2. PL-300
    3. PL-900
    4. DP-500

    Answer: PL-300 — PL-300 replaced DA-100 as the Power BI Data Analyst Associate exam.

  8. Which area is easiest to under-prepare for?

    1. DAX measures
    2. Governance: workspace roles, refresh, gateways
    3. Chart selection
    4. Power Query basics

    Answer: Governance: workspace roles, refresh, gateways — The manage-and-secure area is reliably tested but often skipped in favour of DAX practice.

  9. Drill-through differs from drill-down because it:

    1. Is faster
    2. Navigates to another page carrying the selected context
    3. Only works on dates
    4. Requires a hierarchy

    Answer: Navigates to another page carrying the selected context — Drill-down stays within one visual.

  10. "Keep all filters" off means the detail page shows:

    1. Only the drilled value, ignoring other page filters
    2. Everything
    3. Nothing
    4. The same as on

    Answer: Only the drilled value, ignoring other page filters — Usually not what people expect.

  11. How is a chart-type switcher usually built?

    1. A DAX measure
    2. Overlapping visuals toggled by bookmarks and the selection pane
    3. A slicer
    4. Drill-through

    Answer: Overlapping visuals toggled by bookmarks and the selection pane — The user appears to switch type; you swap visibility.

  12. A report misbehaves after editing a visual. Likely cause?

    1. A broken relationship
    2. A bookmark still holds the old state
    3. Wrong data type
    4. A slicer

    Answer: A bookmark still holds the old state — Update bookmarks after changing what they capture.