Happy to Announce Our New Discussion Forum | Join Now

WhizQuiz Nov 15th, 2018

Which of the following services can be used as a business analytics service that can be used to build visualizations?

  • A. AWS Quicksight
  • B. AWS Visualizer
  • C. AWS Athena
  • D. AWS Presto

0 voters

1 Like

Hi,
Correct answer is Option A
Amazon QuickSight is an Amazon Web Services utility that allows a company to create and analyze visualizations of its customers’ data. The BI service uses AWS Super-fast, Parallel, In-memory Calculations Engine (SPICE) to quickly perform data calculations and create graphs.

Now, lets look why the other options are wrong.

AWS Athena - is a leader in Serverless Query Services. It uses ANSI-standard SQL to query directly from Amazon S3, and makes it easy to analyze big data directly in S3 using standard SQL.

AWS Preto - is an open-source distributed SQL query engine optimized for low-latency, ad-hoc analysis of data. Also referred as PrestoDB

Thanks
Viswanaht

Good Viswanath, correct answer with detailed explanation.

“The Correct Answer is Option A.”

Explanation: Amazon QuickSight is a fast business analytics service you can use to build visualizations, perform ad hoc analysis, and quickly get business insights from your data. Amazon QuickSight discovers AWS data sources, enables organizations to scale to hundreds of thousands of users, and delivers responsive performance by using a robust in-memory engine (SPICE).

For more information on AWS Quicksight please refer to the below URL:

Answer B is incorrect: No such AWS service

Answer C is incorrect: Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.

Note, you can visualize you Athena data with QuickSight:

Amazon QuickSight is a fast, cloud-powered business analytics service that makes it easy to build visualizations, perform ad-hoc analysis, and quickly get business insights from your data. You can easily run SQL queries using Athena on data stored in S3 and build business dashboards within QuickSight.

Answer D is incorrect. Presto is an open-source distributed SQL query engine optimized for low-latency, ad-hoc analysis of data. It supports the ANSI SQL standard, including complex queries, aggregations, joins, and window functions. Presto can process data from multiple data sources including the Hadoop Distributed File System (HDFS) and Amazon S3.

Note, the QuickSight integration and relation to Athena and Presto

You can upload CSV or Excel files; ingest data from AWS data sources such as Amazon Redshift, Amazon RDS, Amazon Aurora, Amazon Athena, Amazon S3, and Amazon EMR (Presto and Apache Spark); connect to databases like SQL Server, MySQL, and PostgreSQL, in the cloud or on-premises; or connect to SaaS applications like Salesforce. Future releases will let you ingest data from Amazon DynamoDB and Amazon Kinesis as well as other cloud applications.


(section: Choose your data source)

So, The correct answer is: AWS Quicksight.