pbPassingBI
/
quicksight/flashcards/quicksight-flashcards-core

QuickSight essentials

Objects, SPICE, calculations, security. 12 cards. Click a card to flip, or use the arrow keys and space bar.

  1. Four core objects?

    Data source → dataset → analysis → dashboard.

  2. Analysis vs dashboard?

    An analysis is the editable authoring environment; a dashboard is a published read-only snapshot that needs republishing to update.

  3. What is SPICE?

    Super-fast, Parallel, In-memory Calculation Engine — QuickSight's compressed columnar in-memory store.

  4. What does incremental refresh require?

    A date column and a source that supports the filtered query.

  5. QuickSight equivalent of Tableau LOD?

    Level-aware aggregation functions such as sumOver, with PRE_FILTER, PRE_AGG and post-aggregate levels.

  6. runningSum arguments?

    The measure, the sort order, and the partition — the partition is where the calculation resets.

  7. How is RLS implemented?

    A rules dataset with a UserName or GroupName column plus one column per restricted field. Enterprise edition only.

  8. User missing from the rules dataset sees what?

    No data. Default-deny is the safe behaviour.

  9. Blank value in an RLS restriction column?

    Grants access to all values of that field.

  10. Anonymous embedding isolation mechanism?

    Session tags matched by the rules dataset, since there is no user identity.

  11. Which edition adds RLS and VPC connections?

    Enterprise.

  12. Three filter scopes?

    Single visual, all visuals using this dataset, or all applicable visuals.