Play free

Data World 5 · Warehouse and Scale · Stage 2

Load It Right

Sixteen slices want sixteen files: split, compress, list them in a manifest, and leave the storefront its reads.

  • COPY parallelism
  • Slices and file counts
  • Manifests
  • COPY from DynamoDB
  • UNLOAD
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.5: Determine high-performing data ingestion and transformation solutions
  • DEA-C01Skill 2.3.1: Perform load and unload operations to move data between Amazon S3 and Amazon Redshift; Skill 1.1.3: Implement appropriate configuration options for batch ingestion; Skill 1.1.2: Read data from batch sources (for example, Amazon S3, AWS Glue, Amazon EMR, AWS DMS, Amazon Redshift, AWS Lambda, Amazon AppFlow); Skill 2.3.6: Protect data with appropriate resiliency and availability; Skill 1.1.9: Implement throttling and overcoming rate limits (for example, DynamoDB, Amazon RDS, Kinesis)