FlexiToner uses AWS to query 10 years’ worth of historical data and get results in moments, with the flexibility to explore data for deeper insights. Movable Ink provides real-time personalization of marketing emails based on a wide range of user, device, and contextual data, driving higher response rates and better customer experiences.Also FlexiToner hosts log files captured from web servers running out of different EC2 machines
FlexiToner has lot of data assets available in structured, semi-structured and unstructured data forms containing emails, logs, structured data from databases in csv files with formats in CSV, LOG, JSON and binary formats like Parquet and ORC.FlexiToner is interested to build a data lake out of all the files stored on S3 and provide Data Lake as a service to users from different departments based on pay per queries run. What could be an effective solution to manage the environments?Select 3 options.

Answer options:

A.Athena being serverless, allows to run ad-hoc queries on S3 using ANSI SQL interactively, without the need to aggregate or load the data
B.Athena running on scalable EC2 machines, allows to run ad-hoc queries on S3 using ANSI SQL interactively, without the need to aggregate or load the data
C.Athena integrates with Amazon QuickSight for easy data visualization
D.Athena can act as a component of Amazon QuickSight for easy data visualization
E.Athena integrates with the AWS Glue Data Catalog, which offers a persistent metadata store for your data in Amazon S3
F.Athena integrates with the AWS RDS, which offers a persistent metadata store for your data in Amazon S3

Answer: A, C, E
Option A is correct -Athena is serverless, so there is no infrastructure to set up or manage, and you pay only for the queries you run. Athena scales automatically—executing queries in parallel—so results are fast, even with large datasets and complex queries. Athena helps you analyze unstructured, semi-structured, and structured data stored in Amazon S3. Examples include CSV, JSON, or columnar data formats such as Apache Parquet and Apache ORC. You can use Athena to run ad-hoc queries using ANSI SQL, without the need to aggregate or load the data into Athena
https://docs.aws.amazon.com/athena/latest/ug/what-is.html
Option B is incorrect - Athena is serverless, so there is no infrastructure to set up or manage, and you pay only for the queries you run. Athena scales automatically—executing queries in parallel—so results are fast, even with large datasets and complex queries. Athena helps you analyze unstructured, semi-structured, and structured data stored in Amazon S3. Examples include CSV, JSON, or columnar data formats such as Apache Parquet and Apache ORC. You can use Athena to run ad-hoc queries using ANSI SQL, without the need to aggregate or load the data into Athena
https://docs.aws.amazon.com/athena/latest/ug/what-is.html
Option C is correct - Athena integrates with Amazon QuickSight for easy data visualization. You can use Athena to generate reports or to explore data with business intelligence tools or SQL clients connected with a JDBC or an ODBC driver.
Option D is incorrect - Athena integrates with Amazon QuickSight for easy data visualization.You can use Athena to generate reports or to explore data with businessintelligence tools or SQL clients connected with a JDBC or an ODBC driver.
https://docs.aws.amazon.com/athena/latest/ug/when-should-i-use-ate.html
Option E is correct - Athena integrates with the AWS Glue Data Catalog, which offers a persistent metadata store for your data in Amazon S3. This allows you to create tables and query data in Athena based on a central metadata store available throughout your AWS account and integrated with the ETL and data discovery features of AWS Glue.
https://docs.aws.amazon.com/athena/latest/ug/when-should-i-use-ate.html
Option F is incorrect - Athena does not integrate with Amazon RDS, Instead Athena integrates with the AWS Glue Data Catalog, which offers a persistent metadata store for your data in Amazon S3. This allows you to create tables and query data in Athena based on a central metadata store available throughout your AWS account and integrated with the ETL and data discovery features of AWS
Glue.
https://docs.aws.amazon.com/athena/latest/ug/when-should-i-use-ate.html