Amazon QuickSight

Question 1

What is Amazon QuickSight?

Answer 1

A fast, easy-to-use, cloud-powered business intelligence (BI) service that makes it easy to deliver insights to everyone in your organization.

Question 2

Name 3 key features of QuickSight.

Answer 2

Any three of the following:
* Build interactive visualizations and dashboards
* Perform ad-hoc data analysis
* Create paginated reports
* Receive alerts on anomalies in your data
* Access data anytime, on any device (browser or mobile)

Question 3

What is SPICE?

Answer 3

SPICE (Super-fast, Parallel, In-memory Calculation Engine) is QuickSight’s in-memory engine that uses columnar storage, in-memory technologies, and machine code generation to perform calculations and serve data.

Question 4

Give 3 examples of data sources QuickSight can connect to.

Answer 4

Any three of the following:
* AWS data sources (Amazon Redshift, Aurora, RDS, Athena, S3)
* On-premises databases (via JDBC/ODBC)
* Files (Excel, CSV, TSV, CLF)
* SaaS applications (Salesforce)

Question 5

What is an anti-pattern when using QuickSight?

Answer 5

Performing heavy Extract, Transform, Load (ETL) processes within QuickSight. It’s better to use AWS Glue for complex ETL tasks.

Question 6

What are the two editions of QuickSight?

Answer 6

Standard and Enterprise. Enterprise edition offers additional features like column-level security and Microsoft Active Directory integration.

Question 7

How can you secure QuickSight access to an Amazon Redshift cluster in a different AWS Region?

Answer 7

Authorize access from the QuickSight IP range of the relevant region in your Redshift security group.

Question 8

Name 2 ways to enable cross-account access to Redshift/RDS from QuickSight.

Answer 8

Any two of the following:
* AWS Transit Gateway
* VPC peering
* AWS PrivateLink
* (Enterprise edition only) Elastic Network Interface and peering connection

Question 9

How are users managed in QuickSight?

Answer 9

Users can be defined via AWS Identity and Access Management (IAM), or through email signup. Enterprise edition also offers an Active Directory connector.

Question 10

What is the pricing model for QuickSight?

Answer 10

QuickSight uses an annual or monthly subscription pricing model per user, with different tiers for Standard and Enterprise editions.

Question 11

What are QuickSight dashboards?

Answer 11

Read-only snapshots of an analysis that can be shared with others.

Question 12

How can you share QuickSight dashboards with people who don’t have a QuickSight account?

Answer 12

By embedding dashboards in an application using the QuickSight embedding SDK and APIs.

Question 13

What are some of the machine learning capabilities of QuickSight?

Answer 13

• Anomaly detection
• Forecasting
• Autonarratives (text summaries of data)
• Suggested Insights

Question 14

What algorithm does QuickSight use for anomaly detection?

Answer 14

Random Cut Forest

Question 15

What are ‘Autonarratives’ in QuickSight?

Answer 15

Autonarratives are AI-generated text summaries that describe the key findings and insights from your data visualizations, added to your dashboards to provide context.

Question 16

Where can users find ‘Suggested Insights’ in QuickSight?

Answer 16

In the ‘Insights’ tab. QuickSight automatically analyzes your data and provides a set of ready-to-use insights.

Question 17

True or False: QuickSight allows you to bring your own ML models from Amazon SageMaker.

Answer 17

True

Question 18

True or False: You can use customer-managed keys for encryption in QuickSight.

Answer 18

False. AWS manages all encryption keys.

Question 19

What is QuickSight Q?

Answer 19

QuickSight Q is a natural language query tool powered by machine learning that allows users to ask questions about their data in plain English and receive instant answers.

Question 20

What is the QuickSight JavaScript SDK used for?

Answer 20

It is used to embed QuickSight dashboards and visualizations into other applications and websites.