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

The video tutorial covers the integration of AWS Glue and Amazon Athena, focusing on how Glue can structure unstructured data for Athena to query like a database. It explains the use of Glue crawlers and data catalogs, cross-region data access, and the role of work groups in managing access and costs. The tutorial also discusses cost-saving strategies like using columnar formats and partitioning, security measures including IAM policies and encryption, and anti-patterns to avoid when using Athena.

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

• To store data in S3

• To provide a SQL interface

• To populate the Glue Data Catalog

• To visualize data with charts

How can you query data in a different region using Athena?

• By moving data to the same region as Athena

• By directly querying across regions with Athena

• By using a Glue crawler in the same region as Athena

• By using a different SQL engine

What is a key feature of Athena work groups?

• They allow for data encryption

• They organize users and control query access

• They provide a visual interface for data

• They automatically optimize queries

How does using a columnar format like ORC or Parquet benefit Athena users?

• It simplifies data visualization

• It reduces costs and improves performance

• It allows for real-time data updates

• It increases the amount of data scanned

Which of the following is NOT a security feature of Athena?

• Server-side encryption with S3 managed keys

• Cross-account access through bucket policies

• Real-time data replication

• Transport Layer Security (TLS) for data in transit

What is an anti-pattern for using Athena?

• Using it for SQL-based queries

• Using it for highly formatted reports

• Querying data stored in S3

• Integrating with AWS Glue

What is the cost model for using Athena?

• Flat monthly fee

• Pay-per-query

• Free for all operations

• Pay-per-TB scanned