Lab Challenge

Amazon Redshift Challenge

Push your skills to the next level in a live environment
Start Lab Challenge


Time Limit

1h 30m



About Lab Challenges

Lab challenges are hands-on labs with the gloves off. You jump into an auto-provisioned cloud environment and are given a goal to accomplish. No instructions, no hints. To pass, you'll have a limited time to demonstrate your problem-solving skills and get the checks that inspect the state of your lab environment.

Challenge Description

Amazon Redshift is a data warehouse in the public AWS cloud. Commonly used for performing analytical workloads on large datasets, it is performant, cost-effective, and stores your data securely. Amazon Redshift supports configurations to make data and queries more efficient, and to restrict access to subsets of data.

Anyone aiming to get the AWS Certified Data Analytics Specialty certification should be comfortable using features of Amazon Redshift to control access and configure tables.

This hands-on lab challenge will test your practical ability to modify a solution in a production-like AWS environment. You will be presented with a task and set of requirements you must fulfill to pass the challenge.

This is a real environment, which means you can prove your knowledge in an applied way, substituting multiple choice questions for a dynamic performance-based exam situation.

What will be assessed

  • Amazon Redshift
  • Structured Query Language (SQL)

Intended audience

  • Candidates for the AWS Certified Data Analytics Specialty certification
  • DevOps Engineers
  • Data Engineers


  • Configuring Distribution Styles and Table Access in Amazon Redshift (Lab)
  • Amazon Redshift Distribution Styles (Course)
  • SQL Master Class (Course)
About the Author
Learning paths3

Andrew is a Labs Developer with previous experience in the Internet Service Provider, Audio Streaming, and CryptoCurrency industries. He has also been a DevOps Engineer and enjoys working with CI/CD and Kubernetes.

He holds multiple AWS certifications including Solutions Architect Associate and Professional.