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 query data stored in S3. It explains the process of creating a Redshift cluster, configuring IAM roles for necessary permissions, and exploring network and security settings. The tutorial emphasizes cost-effective options and provides a step-by-step guide to finalizing the setup.

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

• It reduces the cost of data storage.

• It allows for faster data processing.

• It eliminates the need for data duplication.

• It provides better security features.

When creating a Redshift cluster, which instance type is recommended for cost efficiency?

• DS-2.large

• DC-1.large

• DS-1.large

• DC-2.large

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

• 3306

• 5439

• 1521

• 5432

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

• To increase the processing speed of queries.

• To allow Redshift to access AWS Glue and S3.

• To reduce the cost of running the cluster.

• To enable multi-factor authentication.

Which permissions are required for the IAM role to access data in S3?

• Amazon S3 Admin Access

• Amazon S3 Write Access

• Amazon S3 Read Only Access

• Amazon S3 Full Access

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

• Encrypting data only during transit.

• Ensuring encryption is only applied to specific tables.

• Using AWS KMS or Amazon HSM for encryption at rest.

• Using third-party encryption tools.

What monitoring tool can be used to track the performance and logs of a Redshift cluster?

• AWS CloudTrail

• AWS Config

• Amazon CloudWatch

• AWS Inspector