AWS Certified Data Analytics Specialty 2021 - Hands-On! - [Exercise] Redshift Spectrum - Part 2

The video tutorial guides users through setting up a Redshift cluster, creating an external schema using AWS Glue, and running SQL queries on data stored in an S3 data lake. It emphasizes the importance of managing costs by shutting down the cluster when not in use. The tutorial also prepares users for the next steps in the course, which involve using QuickSight to build upon the Redshift cluster.

What is the first step in setting up a Redshift cluster?

• Creating an external schema

• Selecting the cluster and signing in

• Running a SQL query

• Deleting the cluster

What tool is used to connect Redshift with S3 data?

• AWS CloudFormation

• AWS Lambda

• Amazon RDS

• Redshift Spectrum

Which service is used to create an external schema in Redshift?

• Amazon DynamoDB

• AWS S3

• Amazon EC2

• AWS Glue

What is the purpose of the SQL query discussed in the tutorial?

• To update the database schema

• To import data into Redshift

• To count product descriptions from a specific country and time

• To delete data from the database

Which country is used as a filter in the SQL query example?

• Italy

• France

• United States

• Germany

What should you do to avoid unnecessary costs when not using the Redshift cluster?

• Leave it running

• Delete the cluster

• Increase the node size

• Create more clusters

How much does it cost per hour to run the Redshift cluster?

• $2.50

• $0.25

• $0.10

• $1.00