pbPassingBI
/
looker studio/exams/looker-studio-exam-full

Looker Studio full mock exam

12 questions sampled across all 4 modules. Timed like the real thing: answer everything, then review the explanations.

  1. Which panel changes the dimension a chart uses?

    1. Style
    2. Setup
    3. Theme
    4. Layout

    Answer: Setup — Setup is data; Style is appearance.

  2. Your Sheet gives columns named "Column 1". Likely cause?

    1. Wrong permissions
    2. Title or blank rows above the header row
    3. Too many rows
    4. Wrong connector

    Answer: Title or blank rows above the header row — Use a named range, or remove everything above the headers.

  3. Where should you fix a metric formatted as the wrong currency?

    1. On each chart
    2. In the data source
    3. In Theme
    4. In the sheet

    Answer: In the data source — One change in the data source applies everywhere.

  4. What makes a scorecard genuinely useful?

    1. Compact numbers
    2. A comparison date range showing the change
    3. A border
    4. A long title

    Answer: A comparison date range showing the change — A number alone gives no sense of whether it is good or bad.

  5. A time series with a 30-value breakdown dimension gives:

    1. A clear chart
    2. 30 unreadable lines
    3. An error
    4. A pivot table

    Answer: 30 unreadable lines — Filter to the top few or use a table.

  6. SUM(Revenue)/SUM(Sessions) differs from SUM(Revenue/Sessions) because:

    1. It is faster
    2. The second averages per-row ratios, weighting rows equally
    3. The first fails on nulls
    4. They are identical

    Answer: The second averages per-row ratios, weighting rows equally — Ratio of sums is the correct form for a rate.

  7. One chart ignores the date range control. Why?

    1. It is broken
    2. It has its own date range set in Setup
    3. Wrong data source
    4. Caching

    Answer: It has its own date range set in Setup — Chart-level settings take precedence.

  8. A filter control affects only some charts. Likely cause?

    1. A bug
    2. Some charts use a source without that field
    3. Wrong control type
    4. Caching

    Answer: Some charts use a source without that field — Blended sources are a common reason.

  9. What does cross-filtering do?

    1. Filters the data source
    2. Clicking a chart element filters the other charts on the page
    3. Adds a control
    4. Blends sources

    Answer: Clicking a chart element filters the other charts on the page — Enabled per chart in Setup.

  10. Why set canvas size before building?

    1. It cannot be changed
    2. Changing it later reflows every component
    3. It affects data
    4. It sets the theme

    Answer: Changing it later reflows every component — You would reposition everything by hand.

  11. Owner's credentials means viewers:

    1. Must authenticate themselves
    2. See data through the owner's access, regardless of their own
    3. Cannot see the report
    4. Get read-only data

    Answer: See data through the owner's access, regardless of their own — Convenient, and the usual cause of unintended data exposure.

  12. Which typically gives the biggest speed improvement?

    1. Removing colours
    2. Extract data, or aggregating upstream
    3. Fewer pages
    4. A different theme

    Answer: Extract data, or aggregating upstream — Query volume and row count dominate performance.