AWS Certified Data Analytics Specialty 2021 – Hands-On - Athena and Glue, Costs, and Security

The video tutorial explains how AWS Glue and Athena work together to structure unstructured data in S3, allowing it to be queried like a database. It covers the use of Glue Data Catalogs, Athena workgroups for organizing users and controlling costs, and strategies for optimizing costs and performance using columnar formats and partitioning. Security measures, including IAM policies and encryption, are discussed, along with common anti-patterns to avoid when using Athena.

What is the primary function of AWS Glue in relation to Amazon Athena?

• To store data in S3

• To visualize data

• To provide a SQL interface

• To populate the Glue Data Catalog

How do Athena workgroups help manage query access?

• By providing a SQL interface

• By organizing users and controlling access

• By visualizing data

• By storing data in S3

What is the cost model of Amazon Athena?

• Subscription-based

• Pay-as-you-go

• Free for all queries

• Flat monthly fee

Which data format can help reduce costs when using Athena?

• JSON

• XML

• CSV

• ORC

What is a potential benefit of partitioning data in S3 for Athena?

• Improved data security

• Reduced data scanning costs

• Faster data retrieval

• Increased storage costs

What is one way to secure Athena query results?

• Using IAM policies

• Encrypting results at rest

• Storing data in S3

• Using QuickSight

Which of the following is NOT recommended for use with Athena?

• Data visualization

• Highly formatted reports

• ETL operations

• SQL queries