pbPassingBI
/
looker studio/exams/looker-exam-practice

Looker Studio practice exam

Fifteen questions across connections, charts, blends, controls and sharing.

  1. Which panel changes a chart's dimension?

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

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

  2. A Sheet produces columns named "Column 1". Fix:

    1. Change connector
    2. Remove rows above the header, or use a named range
    3. Add a filter
    4. Re-share the sheet

    Answer: Remove rows above the header, or use a named range — Headers must be the first row.

  3. A numeric order ID is being summed. Fix:

    1. Change chart type
    2. Set its type to text and role to dimension
    3. Blend the source
    4. Add a control

    Answer: Set its type to text and role to dimension — Numeric fields default to metrics.

  4. Reusable calculated fields belong at:

    1. Chart level
    2. Data source level
    3. Report level
    4. Blend level

    Answer: Data source level — Chart-level fields cannot be reused.

  5. The correct form for a conversion rate is:

    1. SUM(conv/sessions)
    2. SUM(conv)/SUM(sessions)
    3. AVG(conv/sessions)
    4. COUNT(conv)/COUNT(sessions)

    Answer: SUM(conv)/SUM(sessions) — Ratio of sums, not sum of ratios.

  6. A blend returns all nulls. Most likely:

    1. Too many sources
    2. Join keys differ in format
    3. Wrong chart
    4. Stale cache

    Answer: Join keys differ in format — Normalise keys before blending.

  7. Maximum sources in one blend:

    1. 2
    2. 5
    3. 10
    4. Unlimited

    Answer: 5 — Five.

  8. A chart ignores the page date control because:

    1. It is broken
    2. It has its own date range in Setup
    3. It is blended
    4. Caching

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

  9. To apply a date control across all pages, place it:

    1. On each page
    2. In the report header
    3. In the theme
    4. In the data source

    Answer: In the report header — Header components repeat across pages.

  10. Cross-filtering means:

    1. Filtering the source
    2. Clicking a chart filters other charts on the page
    3. Blending two sources
    4. Adding a control

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

  11. Owner's credentials means viewers see data:

    1. Only what they may access
    2. Through the owner's access regardless of their own
    3. Without any data
    4. Aggregated only

    Answer: Through the owner's access regardless of their own — The usual cause of accidental exposure.

  12. Scheduled email PDFs render with:

    1. The last used filters
    2. The report default filter state
    3. No filters
    4. The recipient's filters

    Answer: The report default filter state — Set defaults before scheduling.

  13. The biggest lever on a slow report is usually:

    1. Fewer colours
    2. Extract data or aggregate upstream
    3. A lighter theme
    4. Smaller canvas

    Answer: Extract data or aggregate upstream — Each component runs its own query.

  14. Why must canvas size be set before building?

    1. It is fixed
    2. Changing it later reflows every component
    3. It sets the theme
    4. It affects data freshness

    Answer: Changing it later reflows every component — Repositioning by hand otherwise.

  15. Optional metrics let the viewer:

    1. Edit the report
    2. Add metrics themselves from a menu
    3. Change the date
    4. Export data

    Answer: Add metrics themselves from a menu — Keeping the default chart clean.