AWS Certified Data Analytics Specialty 2021 – Hands-On - Presto on EMR

Presto is a powerful tool that connects to various big data databases, allowing SQL-style queries across them. It supports interactive queries at petabyte scale and is optimized for OLAP applications. Originally developed by Facebook, Presto is open-source and used by Amazon Athena. It offers interfaces like JDBC and Tableau, and supports connectors for HDFS, S3, Cassandra, and more. Presto is faster than Hive and integrates easily with Amazon EMR, but is not suitable for OLTP or batch processing.

What is a key feature of Presto that makes it suitable for handling large-scale data queries?

• It is designed for OLTP applications.

• It offers interactive queries at petabyte scale.

• It can only connect to SQL databases.

• It uses a new programming language.

Which company originally developed Presto, and what is its current status?

• Microsoft, and it is available for purchase.

• Amazon, and it is a closed-source project.

• Facebook, and it remains open-source.

• Google, and it is now proprietary.

How does Amazon Athena relate to Presto?

• Athena is a database that Presto cannot connect to.

• Athena is a proprietary version of Presto.

• Athena is a serverless version of Presto.

• Athena is a competitor to Presto.

What makes Presto faster than Hive in many cases?

• It uses a new query language.

• It is optimized for OLTP applications.

• It processes data on disk.

• It processes data in memory and pipelines it across the network.

Why is Presto not suitable for OLTP or batch processing?

• It is designed for interactive OLAP queries.

• It is too slow for large data sets.

• It requires extensive configuration.

• It cannot connect to SQL databases.