pbPassingBI
/
quicksight/quizzes/quicksight-quiz-data
10 questions

Data sources & datasets — quiz

10 questions covering this module. Connecting, preparing datasets, SPICE and refresh.

  1. A SPICE refresh suddenly fails across several datasets. First thing to check?

    1. Chart configuration
    2. SPICE capacity in the admin console
    3. Dashboard permissions
    4. Parameter defaults

    Answer: SPICE capacity in the admin console — Exhausted account capacity is the usual cause, often from abandoned datasets.

  2. Which requires a date column?

    1. Full refresh
    2. Incremental refresh
    3. Direct query
    4. SPICE ingestion

    Answer: Incremental refresh — Incremental refresh filters a look-back window, which needs a date field.

  3. Map visuals are not available for your city field. Most likely cause?

    1. SPICE is full
    2. No geographic role assigned
    3. Wrong edition
    4. Direct query mode

    Answer: No geographic role assigned — QuickSight only offers geospatial charts once a geographic role is set on the field.

  4. Where is complex join logic best maintained?

    1. Custom SQL inside the dataset
    2. A view in the warehouse
    3. An analysis-level calculated field
    4. A dashboard filter

    Answer: A view in the warehouse — A warehouse view is version-controlled, reusable and easier to debug than embedded SQL.

  5. Connecting QuickSight to S3 requires:

    1. A bucket policy only
    2. A manifest file describing the objects
    3. A VPC connection
    4. SPICE capacity

    Answer: A manifest file describing the objects — It lists URIs or prefixes and the file format.

  6. A source works in the AWS console but not QuickSight. Likely cause?

    1. SPICE is full
    2. QuickSight lacks its own service permissions
    3. Wrong region
    4. The dataset is stale

    Answer: QuickSight lacks its own service permissions — Grant them in Manage QuickSight → Security & permissions.

  7. A calculation two reports both need belongs in:

    1. Each analysis
    2. The dataset
    3. The dashboard
    4. A parameter

    Answer: The dataset — Shared definitions prevent reports disagreeing.

  8. A numeric ID field is being summed. Fix:

    1. Change the visual
    2. Change its role from measure to dimension
    3. Add a filter
    4. Refresh SPICE

    Answer: Change its role from measure to dimension — Numeric fields default to measures.

  9. A dashboard shows stale data with no error. Check first:

    1. The visual type
    2. Whether SPICE capacity was exceeded and the refresh failed
    3. Parameters
    4. Permissions

    Answer: Whether SPICE capacity was exceeded and the refresh failed — Capacity failures are easy to miss.

  10. Incremental refresh does not capture:

    1. New rows
    2. Rows updated or deleted outside the lookback window
    3. Large tables
    4. Calculated fields

    Answer: Rows updated or deleted outside the lookback window — Hence a periodic full refresh.