AWS Certified Cloud Practitioner (CLF-C01)- Amazon Athena

This video tutorial provides an overview of various analytic tools available on the AWS platform, focusing on Amazon Athena. It explains how Athena is a serverless, interactive query service that allows users to analyze data stored in Amazon S3 using standard SQL. The video highlights Athena's benefits, such as cost efficiency and ease of use, and demonstrates how to create databases and tables, and run queries using sample data. The tutorial concludes with a brief mention of the next topic, Amazon Kinesis.

Which of the following is NOT an analytic tool mentioned in the video?

• Amazon Redshift

• Amazon Athena

• Amazon Kinesis

• Amazon QuickSight

What is a key feature of Amazon Athena?

• It charges per query execution time.

• It requires complex ETL processes.

• It is a serverless service.

• It only supports JSON data format.

How can you reduce query costs in Amazon Athena?

• By increasing query execution time.

• By using more servers.

• By using only JSON data format.

• By compressing and partitioning data.

Which SQL support does Amazon Athena offer?

• MySQL

• T-SQL

• PL/SQL

• Presto and ANSI SQL

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

• It provides a server for Athena.

• It offers a metadata repository and ETL capabilities.

• It is used for data storage.

• It enhances query speed.

What is the first step in using Amazon Athena to query data?

• Run a query.

• Create a table.

• Upload data to S3.

• Create a database.

What type of data can be queried using Amazon Athena?

• Only structured data

• Only unstructured data

• Both structured and unstructured data

• Only data in JSON format