Many users view a daily sales dashboard.
Reduce repeated base-table queries while meeting a defined daily freshness target.
Which approach is most appropriate?
Load the dataset into QuickSight SPICE and configure a scheduled refresh when daily freshness is sufficient.
Detailed explanation
Source workload and response time grow with the number of viewers.
Source workload and response time grow with the number of viewers.
An in-memory dataset can serve many viewers without querying the source for every view.
An in-memory dataset can serve many viewers without querying the source for every view.
Archive retrieval is unsuitable for interactive visualization.
Archive retrieval is unsuitable for interactive visualization.
API audit records do not represent the business sales dataset.
API audit records do not represent the business sales dataset.
Check official documentation
Compare the following points with the official documentation.
Amazon QuickSight SPICE、scheduled refresh、direct queryの公式説明を確認する。
What to confirm
SPICEとライブクエリの鮮度・性能・コストの違いを説明できる。
Key points
- QuickSight
- SPICE
- Refresh
- Direct query
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Freshness SLA
Choose SPICE or direct query based on acceptable staleness and source load.
Capacity
Monitor dataset size, refresh duration, failures, and incremental-ingestion options.