lab challenge

Amazon Redshift Challenge

Up to 1h 30m
Get challenged in a real environmentProve your skills in a real-world, provisioned environment.
Push your limitsComplete an unguided mission within the time limit.
See resultsTest your problem-solving skills and track your progress.


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.


  • Configuring Distribution Styles and Table Access in Amazon Redshift (Lab)
  • Amazon Redshift Distribution Styles (Course)
  • SQL Master Class (Course)

Intended audience

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

What will be assessed

  • Amazon Redshift
  • Structured Query Language (SQL)

About the author

Learning paths

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.

Covered topics


Amazon Redshift Challenge