Instiq

2Data Store Management

Practice questions →Glossary →
  • 2.1Designing an S3 Data Lake

    Understand an S3-centric data lake (raw/cleaned/curated layers), partitioning and columnar formats, and cost optimization via storage classes and lifecycle. The starting point for "Data Store Management" in DEA-C01.

  • 2.2Data Warehouse and Querying (Redshift, Athena)

    Understand Amazon Redshift (columnar warehouse), querying S3 directly with Redshift Spectrum and Athena, and choosing ETL vs. ELT.

  • 2.3Choosing Purpose-Built Data Stores

    Understand choosing purpose-built stores by access pattern (DynamoDB = NoSQL, RDS/Aurora = relational OLTP, Redshift = OLAP), plus catalogs and schema evolution.