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

The video tutorial covers setting up an Amazon Redshift cluster, using Redshift Spectrum to access S3 data, and configuring necessary IAM roles and permissions. It provides a step-by-step guide to creating a cost-effective Redshift cluster, including network and security settings, and finalizing the setup using the AWS Management Console.

What is one of the main advantages of using Redshift Spectrum over copying data directly into Redshift?

• It reduces the cost of data storage.

• It eliminates the need to store a copy of the data in Redshift.

• It allows for faster data processing.

• It provides better data encryption.

When creating a Redshift cluster, what is the recommended instance type for a cost-effective setup?

• DC-1.large

• DS-1.large

• DC-2.large

• DS-2.large

What is the default database port number for connecting to a Redshift cluster externally?

• 1521

• 5432

• 3306

• 5439

Why is it necessary to create an IAM role for the Redshift cluster?

• To enable multi-factor authentication.

• To enable automatic backups.

• To allow the cluster to access AWS Glue and S3 data.

• To increase the cluster's processing power.

Which permissions are required for the IAM role to allow Redshift to query data from S3?

• AmazonS3ExecuteAccess

• AmazonS3WriteAccess

• AmazonS3ReadOnlyAccess

• AmazonS3FullAccess

What is a key consideration when setting up encryption for a Redshift cluster?

• Enabling CloudWatch monitoring.

• Setting up a multi-region replication.

• Ensuring the cluster is in a private subnet.

• Choosing between AWS KMS and a hardware security module.

What is the purpose of using CloudWatch with a Redshift cluster?

• To provide additional storage space.

• To monitor logs and set alarms for unexpected behavior.

• To enhance data encryption.

• To automate data backups.