[Developer] Advanced Analytics Topics

Question 1

What does OLAP stand for?

Answer 1

Online Analytics Processing

Question 2

What does Columnar Data Storage optimize for?

Answer 2

read performance

It allows queries to only the necessary columns and gets better compression

Question 3

When should a developer choose Amazon Redshift over traditional RDS databases?

Answer 3

For OLAP use-cases

Question 4

What are the two key performance technologies Redshift uses?

Answer 4

Massive Parallel Processing
and
Columnar Data Storage

Question 5

How can you run standard SQL queries against data stored in S3?

Answer 5

Amazon Athena

Question 6

Is Amazon Athena serverless?

Answer 6

Yes

Question 7

What is the primary format your data should be in for cost-effective querying with Athena?

Answer 7

Columnar Formats (like Parquet or ORC)

Athena only pays for the data it scans

Question 8

What is the best choice for developers needing a managed solution for full-text search, log aggregation, and real-time application monitoring?

Answer 8

Amazon OpenSearch Service

(previously called ElasticSearch)

Question 9

What is the key difference between OpenSearch and a traditional database?

Answer 9

OpenSearch is a search and analytics engine designed for unstructured data, and focuses on fast flexible search over transactional ACID compliance

Question 10

What does EMR stand for?

Answer 10

Elastic MapReduce

Question 11

When should a developer use EMR instead of Redshift, Athena, or Lambda?

Answer 11

For a customized, complex big data framework (like Hadoop, Spark or Hive)

Question 12

Where is input data typically ingested for EMR?

Answer 12

S3

Question 13

Where is output data usually written to from EMR?

Answer 13

S3

Question 14

What is the serverless ETL service that Amazon Offers?

Answer 14

AWS Glue

Question 15

What specialized component of AWS Glue is essential for services like Athena to understand the structure of data in S3?

Answer 15

The Glue Data Catalog

Question 16

What AWS service simplifies setting up a secure data lake and centrally manages security and access permissions for data stored in S3?

Answer 16

AWS Lake Formation

Question 17

What is the key benefit of Lake Formation’s security model?

Answer 17

It provides fine-grained access control (down to the column/row level) for various analytics services (Athena, Redshift, EMR) reading from the S3 data lake.

Question 18

What is AWS’s Business Intelligence offering?

Answer 18

Amazon Quicksight