Redshift Schema Design Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Schema Design

What you'll be asked

  1. Which of the following is the primary purpose of a Distribution Key in Amazon Redshift?
  2. You have a large fact table that is joined frequently with multiple small dimension tables. Which distribution strategy should you use for the dimension tables?
  3. When designing a table in Redshift, which column data type is most efficient for storing a column that contains only 'True' or 'False' values?
  4. What is the primary benefit of choosing an appropriate Sort Key for a table in Redshift?
  5. You are designing a schema for a table that is frequently queried by a range of timestamps (e.g., last 30 days) but has high cardinality and is updated daily. Which sort key strategy provides the best balance of performance for range filters and data ingestion?

Answers and explanations come after you submit.