NEW
Font size
WorksheetsAmazon Athena Worksheet
Total questions: 23
Worksheet time: 12mins
Amazon Athena primarily allows you to query data stored in:
Amazon EC2
Amazon S3
Amazon RDS
Amazon DynamoDB
Athena is a:
Fully managed ETL tool
Serverless interactive query service
Managed NoSQL database
Data warehouse
Which query language does Athena use?
T-SQL
MySQL
Hive SQL (Presto/Trino)
Mongo Query
Athena charges are mainly based on:
Number of queries run
Amount of data scanned per query
Query execution time
Number of databases created
To reduce Athena query cost, you should:
Use S3 Transfer Acceleration
Compress and partition data
Increase EC2 instance size
Encrypt data
Athena is integrated with which catalog for metadata?
Route 53
AWS Glue Data Catalog
CloudWatch Logs
Athena results are stored by default in:
Amazon DynamoDB
Amazon RDS
S3 bucket
EC2 instance
What happens if you run an Athena query on unpartitioned data?
Cost increases
Query runs faster
Data becomes encrypted
Schema gets updated
Athena is best suited for:
Real-time OLTP
Interactive analytics on S3
Data warehousing on EC2
High-frequency trading
Which AWS service can schedule Athena queries?
Amazon SNS
AWS Glue
Amazon S3
Amazon EventBridge
Athena federation allows you to query:
Only S3
Multiple regions
Databases like RDS, DynamoDB using connectors
Local files
Athena eliminates the need for:
Managing servers
Writing SQL
Storing data
Access control
Athena CTAS stands for:
Create Table And Save
Create Table As Select
Copy Table And Store
Create Temporary Athena Schema
Your S3 bucket contains 2 TB of CSV logs. Athena queries are slow and expensive. What should you do?
Convert data to Parquet and partition it
Move data to EBS
Use smaller queries
Add more EC2 instances
Your team runs Athena queries accidentally on large datasets. You want to enforce cost control. What should you use?
IAM Roles
Athena Workgroups with data scan limits
S3 lifecycle rules
CloudTrail
Your Athena query fails because the data schema does not match table definition. What should you do?
Change AWS region
Update the Glue Data Catalog table schema
Delete the S3 bucket
Restart Athena
A user cannot run Athena queries because they get an Access Denied error. Cause?
Wrong SQL syntax
Missing S3 permissions in IAM policy
Athena server is down
Region misconfigured
You want Athena to query data from MySQL without loading into S3. Which feature helps?
Glue Crawlers
Athena Federated Query
S3 Select
EMR integration
You want to automate daily Athena queries and email the results. Which combination works?
SNS + RDS
EventBridge + Athena + SNS
EC2 + S3
CloudTrail + S3
A team wants to create tables in Athena without writing SQL. Which tool can help?
Cloud9
Glue Data Catalog + Crawlers
S3 sync
CloudFormation
What does Athena require before querying S3 data?
A. A database engine to install
B. Index file generation
C. Table definitions with column mapping
D. Storing data in RDS
A. Workgroup budgets B. Query result caching C. Glue Data Catalog D. Partition merging
Workgroup budgets
Query result caching
Glue Data Catalog
Partition merging
Scenario: An S3 bucket is updated with new hourly log files, but Athena is not recognizing the new data. What must be done?
Delete old partitions
Repair or add partitions in Glue / Athena
Restart Athena engine
Change bucket policy
