You have a large amount of data stored in an S3 bucket, and the data arrives at a fixed time. You want to analyze the data directly using standard SQL. You also need a service to help you to create databases and tables. The service should be able to categorize the data and automatically infer database and table schema. Which combinations of services would you choose? (Select TWO.)

Answer options:

A.Use Amazon QuickSight to connect to the dataset, build visualizations and get business insights from the data.
B.Use Amazon Athena to run ad-hoc queries with standard SQL and get results in seconds.
C.Configure a JDBC connection to connect the database to business intelligence tools such as SQL Workbench for further analysis.
D.Configure Amazon EMR to process the data for analytics purposes and business intelligence workloads based on the big data frameworks, such as Apache Hadoop and Apache Spark.
E.Set up an AWS Glue crawler to retrieve the schema information and use AWS Glue Data Catalog to store metadata such as table and column names.

Correct Answer – B, E
There are two requirements for the question. First, the data should be analyzed with standard SQL. Second, a service is required to generate databases for SQL queries. Amazon Athena and AWS Glue should be used. You can configure AWS Glue to connect to the data sources in Amazon S3 and prepare the databases for Athena. Details can be found in https://docs.aws.amazon.com/athena/latest/ug/data-sources-glue.html.
Option A is incorrect: Amazon QuickSight enables you to visualize the data and share it through data dashboards. This is not required in this question.
Option B is CORRECT: Because Athena helps to analyze unstructured, semi-structured, and structured data stored in Amazon S3 using ANSI SQL.
Option C is incorrect: Because tools such as SQL Workbench are used for performing further SQL queries with SQL scripts. It is not required in this scenario.
Option D is incorrect: Because Amazon EMR is a platform to process and analyze vast amounts of data. It is not needed as the question asks for standard SQL queries.
Option E is CORRECT: You can set up a crawler in AWS Glue to retrieve schema information automatically. After the connection is made, Athena can analyze the table using standard SQL and get results in seconds.