Question 18: You are working in a company which does the analysis of all US based companys annual report, these reports are publicly available and can be downloaded any time from either companys website or from the

stock exchange where it is listed, they also have some private companies data as well. You have stored this data in S3 bucket after converting them into csv format. Now you need to show analysis of this company data

online to your customer who does the equity investments in all these company, they also want to see this data in graphical format. Which of the following components would be helpful for the given requirement, with the

minimum effort?

1. You will be using AWS Lambda to create the graphs using the data stored in S3 bucket.

2. You will be using AWS Athena service to create the graphs using the data stored in S3 bucket.

3. You will be using AWS QuickSight service to create the graphs using the data stored in S3 bucket.

4. You will be using third party visualization software to create the graphs using the data stored in S3 bucket.

Correct Answer : 3 Exp : AWS QuickSight is a BI (Business Intelligence) service , using this you can get the insights from the stored data. Even using QuickSight you can create and publish dashboards that can be

accessed from browsers or mobile devices and even you can embed dashboard in your applications. QuickSight can directly connect to wide variety of data sources including SaaS application like Salesforce, Square,

ServiceNow, Twitter, Github, JIRA etc. and also you can use databases like TeraData, MySQL, Postgres, Oracle and SQL Server.

AWS services like Redshift, Athena, S3, RDS, and Aurora can be used as a data source for the QuickSight visualization and files data like csv, JSON and Presto.

Based on this we can say that option-3 is correct choice.

3