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 S3, and querying data with Redshift Spectrum. It emphasizes the importance of managing costs by shutting down the cluster when not in use. The tutorial also prepares users for the next exercise involving Quick Site, highlighting the need to keep the cluster running if continuing soon.

What is the first step after setting up the Redshift cluster?

• Run a query

• Delete the cluster

• Sign into the database

• Create a new S3 bucket

What is the purpose of creating an external schema in Redshift?

• To export data from Redshift to S3

• To delete data from S3

• To connect Redshift with S3 data using Glue

• To import data from S3 into Redshift

Which service is used to query data in place on S3?

• AWS Glue

• Redshift Spectrum

• Amazon Athena

• AWS Lambda

What SQL clause is used to filter orders from a specific country?

• ORDER BY

• WHERE

• HAVING

• GROUP BY

What should you do to avoid unexpected charges when not using the Redshift cluster?

• Increase the node size

• Create more clusters

• Delete the cluster

• Leave it running

What is the cost per hour for running the Redshift cluster?

• $1.00

• $2.50

• $0.25

• $0.10

What is the potential monthly cost if the Redshift cluster is left running continuously?

• $250

• $180

• $100

• $50