Domain 5: Visualization Flashcards

1
Q

What is SPICE?

A

Super Fast, Parallel, In-memory, Calculation, Engine

Used for accelerating queries on large datasets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How much SPICE data is provided per user?

A

10GB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Is SPICE serverless?

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are QuickSight anti-patterns?

A

Highly formatted reports, ETL processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are some of QuickSight’s security options

A

MFA, RLS, private VPC access via Elastic Network Interface,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Can QuickSight connect to on-premises data?

A

Yes, via Direct Connect

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How are users defined in QuickSight?

A

IAM, email signup, or active directory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the annual subscription pricing with QuickSight

A

Standard: $9/user/month; Enterprise: $18/user/month

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How much is Extra SPICE on Quicksight?

A

Standard: $.25/GB/month; Enterprise: $.38/GB/month

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the monthly subscription pricing with QuickSight?

A

Standard: 12; Enterprise: 24

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the benefits of Enterprise Quicksight?

A

Encryption at rest, active directory integration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are some features of QuickSight Machine Learning insights?

A
  • Anomaly detection using RANDOM_CUT_FOREST
  • Forecasting using RANDOM_CUT_FOREST; excludes outliers and imputes missing values
  • Autonarratives adds stories of data to dashboards
  • “Insights” tab with automated visualizations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are bar charts used for?

A

Comparison and distribution (histograms)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are line graphs used for?

A

Changes over time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are Scatter plots, heat maps used for?

A

Correlation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are pie graphs/treemaps used for?

A

Aggregation

17
Q

What are pivot tables used for?

A

Tabular data, multidimensional data

18
Q

What are some tools for public facing data visualization?

A

D3.js, Chart.js, Highchart.js