A team has a 10 PB data store in EMR. All the data is stored in S3. There is a need for a data engineer to perform interactive analysis. The data engineer already has access to the EMR cluster via the AWS Console. Which of the following can be used by the data engineer for interactive analysis?

Answer options:

A.Presto
B.Apache sqoop
C.Oozie
D.Apache Pig

Answer – A
Presto is a fast SQL query engine designed for interactive analytic queries over large datasets from multiple sources.
Option B is incorrect since this is a tool for transferring data between Amazon S3, Hadoop, HDFS, and RDBMS databases
Option C is incorrect since this is used to manage and coordinate Hadoop jobs
Option D is incorrect since this is used to transform large data sets without having to write complex code in a lower level computer language like Java
For more information on AWS Presto, please refer to the below URL
https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-presto.html