AWS Data Lake Immersion Day

What is a Data Lake?

• A centralized repository for structured data

• A distributed repository for data analytics

• A centralized repository for structured and unstructured data

• A centralized repository for unstructured data

What can you do with a Data Lake?

• Query directly with Amazon Athena

• Analyze with Hadoop on Amazon EMR

• Create visualizations with Amazon QuickSight

• Create a central data catalog with AWS Glue

What are the common data sources to hydrate a Data Lake?

• Databases

• Streams

• Logs

• Files

What is the AWS DMS Service?

• A service to transform and clean up data in databases

• A service to visualize data stored in relational databases

• A service to securely migrate and/or replicate databases and data werehouses to AWS

• A service to centralize permissions of data stored in AWS

What is AWS Snowball?

• Is a data transport solution that accelerates moving data into and out of AWS using storage appliances

• Is a data transfer solution that uses dedicated bandwidth to transfer large amounts of data into AWS

• Is a data aggregation service that compresses data to get transferred over the Internet

Makes it possible to query data without leaving S3

• S3 query

• S3 Select

• AWS Glue

• AWS Lake Formation

An AWS service that allows you to analyze data streams with SQL or Java

• Kinesis Data Streams

• Kinesis Data Firehose

• Kinesis Data Analytics

• Kinesis Video Streams

Partitioning data allows you to optimize for cost and performance

• True

• False

An AWS Glue Data Crawler can detect file types, extract fields, define the schema, and identify partitions in an on-premises SAN

• True

• False

It's a visual authoring tool for ETL jobs

• AWS Glue Crawler

• AWS Glue Studio

• AWS Glue Data Catalog