Analytics - Athena

Question 1

Interactive Query service for S3 where you can write SQL queries.

No need to load data, it stays in S3

Uses Presto under the hood

Serverless

a) RDS
b) Athena
c) S3

Answer 1

b) Athena

Supports many data formats.

Like human readable: CSV, TSV, JSON, Columnar/splittable Orc, Parquet, splittable Avo, compression Snapy, Zlib, LZO, Gzip.

Question 2

I want to perform adhoc queries of web logs. Which AWS service is better to use?

a) RDS
b) Athena
c) S3

Answer 2

B) Athena

Question 3

Which AWS service is better for querying staging data before loading to redshift

a) RDS
b) Athena
c) S3

Answer 3

b_athena

So like getting a bigger picture before you acutally commit data into a data warehouse.

Question 4

Which aws service is better for analyzing CloudTrail/CloudFront/VPC/ELB logs in S3

a) RDS
b) Athena
c) S3

Answer 4

b) Athena

Question 5

Which aws service is better for integration with jypter, zepplin, rstudio notebooks

a) RDS
b) Athena
c) S3

Answer 5

b) is has odcb and jdbc interfaces so you can treat athena like any other rdbms

You can also make use of amazon quicksight visualization tool into athena.

Question 6

How does Athena work with Glue?

For example, you have a Glue ____________________ populating the glue catalog for your s3 data.

a) RDS
b) Athena
c) S3
d) Glue Crawler

Answer 6

d) Glue Crawler

Extract columns and table definitions out of it for you. You can use the glue console to refine that definiiton as needed.

Question 7

Once you have a ___________________________ published for your S3 data, Athena will see it automatically and it can build a table from it.

a) RDS
b) Athena
c) S3
d) Glue data catalog

Answer 7

d) Anytime athena sees something in your glue data catalog in your account. Its going to make a table for that for you. So you can query it jus tlike you would any other sql database.

Other analytics tool can use that catalog to visulaize or analyze data like rds, redhsit, emr, redhsift spectrum. Services using apcahe give metastore.

Question 8

IN Athena you can control query access and track costs by ________________

a) RDS
b) Athena
c) S3
d) Workgroups

Answer 8

d) Workgroups

For example, specific types of quereis,

Each workgroup can have its own, Query hisotry, Data limits, IAM policies and encryption settings.

Question 9

in Athena how can you save lots of money by using ____________________.

ORC, Parquet. Save 30-90% and get better performance.

a) RDS
b) COlumnar formats
c) S3

Answer 9

Columnar formats

Partitions can also help lower the costs.

Question 10

IN Athena pay as you go model. Do failed queries get charged?

Answer 10

No - only successful or cancelled queries count.

No charge for DDL operations (alter/create/drop)

But you are chaged by $5 per TB scans

Question 11

True or Falase

Athena can encrypt results at rest in S3 staging directory

Answer 11

True

either server side - SSE-S3 (s3 managed key)

or SS-KMS (KMS Key)

or client side

CSE-KMS (KMS key)

Question 12

True or false

You can have cross account access in S3 bucket policy for Athena.

Answer 12

True

Question 13

True or Falase.

TLS encrypts in transit (between Athena and S3)

Answer 13

True

Question 14

Should you use Highly Formatted report/ Visaulisation for Athena?

Answer 14

No - Use QuickSight

AThena is jsut a sql query engine.

Question 15

Should you use Athena for ETL?

Answer 15

No

Thats was Glue is for.

Can also do that with apache saprk for larger data sets.

Question 16

Does using a smaller number of files help athena perform betten than large number of small files?

Answer 16

Yes

Consider using partitions aswell. Use MSCK REPAIR table command to go back and add metadata to be able to add paritions to existing tables.

Use columnar data (ORC, Parquet)

Question 17

IN athena concurnet users can safley make row level modicaitons

Answer 17

Yes - athena acid transactions supported.

Question 18

ACID transactions are powered by apcahe____________

a) RDS
b) iceburg

Answer 18

Iceburg

Just add ‘table_type; = ‘ICEBERG’ in your create table command.

Question 19

True or False athena supports time travel operations. Where you can recover data recently deleted with a select statement.

Answer 19

True

Question 20

True or false you can set up a govenred table in lake formation in order to have acid support in Athena

Answer 20

True

can also just create using a table with iceberb

Question 21

True or falase periodic compaction can help preserver performance in ACID tranasctions for athena

Answer 21

True

For example, OPTIMIZE table REWRITE DATA using BIN_PACK where catalog = ‘c1’