A company is planning on using an EMR cluster to process data from their On-premise log files. They need to perform SQL queries on the underlying data. Which of the following can be used along with the EMR cluster to satisfy this requirement? Choose 2 answers from the options given below

Answer options:

A.Hive
B.Presto
C.HCatalog
D.Sqoop

Answer – A and B
The AWS Documentation mentions the following
Hive is an open-source, data warehouse, and analytic package that runs on top of a Hadoop cluster. Hive scripts use a SQL-like language called Hive QL (query language) that abstracts programming models and supports typical data warehouse interactions. Hive enables you to avoid the complexities of writing Tez jobs based on directed acyclic graphs (DAGs) or MapReduce programs in a lower level computer language, such as Java.
Presto is a fast SQL query engine designed for interactive analytic queries over large datasets from multiple sources.
Option C is incorrect since this tool is used to access Hive metastore tables
Option D is incorrect since this tool is used for transferring data between Amazon S3, Hadoop, HDFS, and RDBMS databases
For more information on hive and presto, please refer to the below URL
https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-hive.html
https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-presto.html