Data World 5 · Warehouse and Scale · Stage 3

Keys to the Join

Put the rows where the join needs them and the dates where the scan can skip them.

  • Distribution styles
  • Redistribution
  • Sort keys and zone maps
  • Query monitoring rules
  • Skew
Domain
Data engineering
World
Data World 5: Warehouse and Scale (Associate)
Game type
Warehouse: Shape a warehouse's loads and tables so every slice does its share.
Time
About 25 minutes on a first attempt (estimated)
Exam guides
  • SAA-C03Task 3.3: Determine high-performing database solutions
  • DEA-C01Skill 2.4.1: Design schemas for Amazon Redshift, DynamoDB, and Lake Formation; Skill 2.4.5: Describe best practices for indexing, partitioning strategies, compression, and other data optimization techniques; Skill 3.3.4: Troubleshoot performance issues; Skill 3.2.3: Use SQL in Amazon Redshift and Athena to query data or to create views; Skill 2.1.6: Manage locks to prevent access to data (for example, Amazon Redshift, Amazon RDS)