Data World 1 · Lake Foundations · Stage 2

Cut by Date

Partition by what the queries filter on, as fine as the commonest query and no finer.

  • Partitioning
  • Partition pruning
  • CTAS and INSERT INTO
Domain
Data engineering
World
Data World 1: Lake Foundations (Associate)
Game type
Lake tuner: Tune a lake's tables until the queries fit their limit and budget.
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.4.5: Describe best practices for indexing, partitioning strategies, compression, and other data optimization techniques; Skill 1.2.4: Optimize costs while processing data; Skill 1.2.6: Transform data between formats (for example, from .csv to Apache Parquet); Skill 3.1.7: Query data (for example, Amazon Athena)