Search Header Logo
AWS Certified Data Analytics Specialty 2021 - Hands-On! - [Exercise] Amazon Web Services (AWS) Glue and Athena

AWS Certified Data Analytics Specialty 2021 - Hands-On! - [Exercise] Amazon Web Services (AWS) Glue and Athena

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

The video tutorial explains how to use Amazon Athena with AWS Glue to query data stored in an S3 data lake. It covers setting up a Glue crawler to infer a schema, creating a database, and partitioning data. The tutorial demonstrates querying the data using Athena, highlighting the ease of treating S3 data as a SQL database. It also discusses potential issues with data types and suggests using ETL jobs for data transformation.

Read more

7 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the first step to set up AWS Glue for querying data in S3?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain the purpose of the crawler in AWS Glue.

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What security option is mentioned regarding AWS Glue logs?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What should you do if the inferred column names from the CSV data are incorrect?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of partition fields in the context of querying data?

Evaluate responses using AI:

OFF

6.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the structure of the data in S3 for order logs.

Evaluate responses using AI:

OFF

7.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you query the data in Athena after setting up Glue?

Evaluate responses using AI:

OFF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?